Skip to content
All roadmaps

Data Analyst roadmap

Excel, SQL, BI dashboards and statistics, then storytelling and experimentation.

Interview questions for this role
0% complete0 done · 0 skipped · ~185h left
  1. 1

    Foundations

    Spreadsheets and statistics.

    • Excel / Google Sheets

      basic~20h

      Why it matters: Still the first tool in most analyst tests.

    • Descriptive statistics and probability

      basic~25h

      Why it matters: Needed to avoid misleading conclusions.

    Milestone: Can you clean a messy CSV and summarise it with pivots and charts?

  2. 2

    Core

    SQL and Python.

    Milestone: Can you answer a business question from three joined tables using SQL and pandas?

  3. 3

    Job-ready

    Dashboards and storytelling.

    • Power BI or Tableau

      intermediate~30h

      Why it matters: Dashboards are the deliverable stakeholders see.

    • Two end-to-end portfolio analyses

      intermediate~40h

      Why it matters: Shows you can go from question to recommendation.

    Milestone: Can you present a dashboard and a clear recommendation to a non-technical audience?