Data Analyst Roadmap

🧠 Skills & Key Topics

• Excel

  • Formulas (VLOOKUP, IF, etc.)

  • Pivot Tables

  • Charts & Graphs

  • Data Cleaning

  • Basic data analysis

• SQL

  • SELECT, WHERE, GROUP BY, HAVING

  • Joins (INNER, LEFT, etc.)

  • Window functions

  • Writing queries on large datasets

• Tableau

  • Connecting to data

  • Using multiple data sources

  • Filters

  • Creating dashboards and visualizations

• Python

  • pandas

• Cloud

  • AWS

  • Pipelines (ETL)

🧪 Projects

Create 3–4 projects combining tools (e.g., SQL + Tableau)

Each project should solve a real problem and tell a story

Use free datasets from:

• Kaggle

• Reddit

• data.gov