Skip to main content
FreeAcademy

Learning Roadmaps

Data Analyst

Learn to collect, process, and analyze data. Start with Python and SQL, practice hands-on queries, wrangle real datasets with Pandas, visualize them with Matplotlib and Seaborn, and speed up your work with AI.

7 courses~7h total100% free, certificate included with every course

Roadmap badge

Complete all courses in this roadmap to earn its badge.

Start with step 1

Courses in this roadmap

  1. Step 1Beginner~4h

    Python for Beginners

    Learn Python from scratch by building 8 mini-projects you run in your browser, from a tip calculator to a flashcard quiz app. No install, no signup to start, and a free certificate. Powered by Pyodide.

  2. Step 2Beginner

    SQL Basics

    Master the fundamentals of SQL from scratch. Learn to query, manipulate, and design databases using PostgreSQL. Build real-world database systems through hands-on exercises and a capstone project. No prior database experience required.

  3. Step 3Beginner

    Interactive SQL Practice

    Practice SQL with hands-on exercises in your browser. Write real queries against a live database, get instant feedback, and build confidence through guided challenges. No setup required - start coding immediately.

  4. Step 4Intermediate

    Interactive JSON & Data Transformation

    Master JSON parsing, manipulation, and transformation with hands-on exercises. Learn to navigate complex data structures, transform API responses, and build data pipelines in your browser.

  5. Step 5Intermediate

    Interactive Pandas Practice

    Master data analysis with Pandas through hands-on exercises. Learn to create, manipulate, filter, group, and transform DataFrames in your browser. Practice real-world data wrangling with live Python execution.

  6. Step 6Intermediate

    Data Visualization with Python (Matplotlib & Seaborn)

    Master data visualization using Matplotlib and Seaborn. Learn to create compelling visualizations from basic plots to advanced statistical charts. Practice with real datasets and build visualization skills for data science, analytics, and business reporting.

  7. Step 7Beginner~3h

    AI for Data Analysts

    Learn how to use AI tools to transform your work as a data analyst. Discover practical techniques for SQL generation, data cleaning, building dashboards, and communicating insights. No extra coding required.