Data Analytics Roadmap

From learning the fundamentals to building real analytical projects.

Overall Progress

30%

01

SQL

Building a strong foundation in querying, analysis and database concepts.

In Progress82%

9 completed · 2 remaining

  • SQL Fundamentals
  • SELECT statements
  • Filtering & sorting
  • Aggregations
  • GROUP BY
  • JOINs
  • CASE statements
  • Subqueries
  • CTEs
  • Advanced SQL
  • SQL Project

02

Excel

Cleaning, modelling and reporting on data with spreadsheets.

In Progress30%

3 completed · 7 remaining

  • Excel Fundamentals
  • Formulas & Functions
  • Data Cleaning
  • Pivot Tables
  • Charts
  • Advanced Excel
  • Power Query
  • Power Pivot
  • Dashboard
  • Excel Project

03

Power BI

Turning models into clear, decision-ready dashboards.

Not Started0%

0 completed · 9 remaining

  • Power BI Fundamentals
  • Importing Data
  • Data Cleaning
  • Data Modelling
  • Relationships
  • DAX
  • Visualizations
  • Dashboard Design
  • Power BI Project

04

Python

Programmatic analysis, automation and visualization.

Not Started0%

0 completed · 10 remaining

  • Python Fundamentals
  • Variables & Data Types
  • Functions
  • Lists & Dictionaries
  • Pandas
  • Data Cleaning
  • Data Analysis
  • Matplotlib
  • Data Visualization
  • Python Project