Data Analyst roadmap
Excel, SQL, BI dashboards and statistics, then storytelling and experimentation.
Interview questions for this role- 1
Foundations
Spreadsheets and statistics.
Excel / Google Sheets
basic~20hWhy it matters: Still the first tool in most analyst tests.
Descriptive statistics and probability
basic~25hWhy it matters: Needed to avoid misleading conclusions.
Milestone: Can you clean a messy CSV and summarise it with pivots and charts?
- 2
Core
SQL and Python.
SQL: joins, window functions, CTEs
basic~40hWhy it matters: SQL is tested in nearly every analyst interview.
Python with pandas
intermediate~30hWhy it matters: Handles data too big or awkward for spreadsheets.
Milestone: Can you answer a business question from three joined tables using SQL and pandas?
- 3
Job-ready
Dashboards and storytelling.
Power BI or Tableau
intermediate~30hWhy it matters: Dashboards are the deliverable stakeholders see.
Two end-to-end portfolio analyses
intermediate~40hWhy 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?