Data Analyst Roadmap
Comprehensive 4-phase roadmap for Data Analyst covering 12 key topics with practical deliverables.
Original PLAN-101 Career Guide
A useful analyst does more than create attractive charts. The hard work is defining a question, checking how data was collected, cleaning it without changing its meaning and explaining uncertainty.
This roadmap uses an end-to-end study question: Which classes improved their assignment completion rate? You will define the denominator, examine missing submissions and check whether a dashboard measure gives the same result as a manual calculation.
Hands-on Projects and Acceptance Goals
- Student Study Habit Report: Analyse anonymised weekly study totals and assignment completion, reporting group sizes and missing data. Tools: CSV, SQL, spreadsheets or Python
- Placement Funnel Dashboard: Define applicants, shortlisted candidates and offers with distinct denominators and explain each rate. Tools: SQL, spreadsheet charts
- Data Quality Audit: Profile duplicate IDs, invalid dates and null values before building any performance chart. Tools: SQL, Python or spreadsheet formulas
Frequently Asked Questions
Should I start with machine learning? Not necessarily. SQL, data cleaning and clear analysis are more directly useful for an entry-level data analyst portfolio.
How do I make my dashboard credible? Publish metric definitions, sample sizes, data quality checks and a reproducible calculation. Avoid unsupported causal claims.
Curriculum Syllabus & Milestones
Phase 1: Foundations
Focus area covering 3 core topics in Foundations.
-
Excel/Spreadsheets
Master pivot tables, VLOOKUP/XLOOKUP and charts on a sample dataset.
- Study primary concepts for: Excel/Spreadsheets
- Actionable guide: Master pivot tables, VLOOKUP/XLOOKUP and charts on a sample dataset.
- Build or test a practical mini-project applying Excel/Spreadsheets.
-
SQL Fundamentals
Practice SELECT, JOIN, GROUP BY and window functions on a public dataset.
- Study primary concepts for: SQL Fundamentals
- Actionable guide: Practice SELECT, JOIN, GROUP BY and window functions on a public dataset.
- Build or test a practical mini-project applying SQL Fundamentals.
-
Statistics Basics
Learn mean/median/variance, distributions and correlation vs causation.
- Study primary concepts for: Statistics Basics
- Actionable guide: Learn mean/median/variance, distributions and correlation vs causation.
- Build or test a practical mini-project applying Statistics Basics.
Phase 2: Core Skills
Focus area covering 3 core topics in Core Skills.
-
Data Cleaning
Clean a messy CSV (duplicates, missing values, types) using Python/Pandas or Excel.
- Study primary concepts for: Data Cleaning
- Actionable guide: Clean a messy CSV (duplicates, missing values, types) using Python/Pandas or Excel.
- Build or test a practical mini-project applying Data Cleaning.
-
Exploratory Data Analysis
Run an EDA notebook on a Kaggle dataset and summarize 3 findings.
- Study primary concepts for: Exploratory Data Analysis
- Actionable guide: Run an EDA notebook on a Kaggle dataset and summarize 3 findings.
- Build or test a practical mini-project applying Exploratory Data Analysis.
-
Data Visualization
Build clear charts (bar, line, heatmap) following visualization best practices.
- Study primary concepts for: Data Visualization
- Actionable guide: Build clear charts (bar, line, heatmap) following visualization best practices.
- Build or test a practical mini-project applying Data Visualization.
Phase 3: Applied Practice
Focus area covering 3 core topics in Applied Practice.
-
BI Tool (Power BI/Tableau)
Build an interactive dashboard answering a real business question.
- Study primary concepts for: BI Tool (Power BI/Tableau)
- Actionable guide: Build an interactive dashboard answering a real business question.
- Build or test a practical mini-project applying BI Tool (Power BI/Tableau).
-
Storytelling with Data
Write a short executive summary translating your analysis into a decision.
- Study primary concepts for: Storytelling with Data
- Actionable guide: Write a short executive summary translating your analysis into a decision.
- Build or test a practical mini-project applying Storytelling with Data.
-
A/B Testing Basics
Design and analyze a simple A/B test with hypothesis testing.
- Study primary concepts for: A/B Testing Basics
- Actionable guide: Design and analyze a simple A/B test with hypothesis testing.
- Build or test a practical mini-project applying A/B Testing Basics.
Phase 4: Career
Focus area covering 3 core topics in Career.
-
SQL for Analytics at Scale
Practice CTEs and advanced window functions on a larger dataset.
- Study primary concepts for: SQL for Analytics at Scale
- Actionable guide: Practice CTEs and advanced window functions on a larger dataset.
- Build or test a practical mini-project applying SQL for Analytics at Scale.
-
Portfolio Project
Publish an end-to-end analysis (data -> insight -> dashboard) on GitHub.
- Study primary concepts for: Portfolio Project
- Actionable guide: Publish an end-to-end analysis (data -> insight -> dashboard) on GitHub.
- Build or test a practical mini-project applying Portfolio Project.
-
Interview Prep
Practice SQL and case-study style analyst interview questions.
- Study primary concepts for: Interview Prep
- Actionable guide: Practice SQL and case-study style analyst interview questions.
- Build or test a practical mini-project applying Interview Prep.
Related Career Paths & Cross-Skill Roadmaps
Expand your engineering versatility by exploring interconnected role roadmaps:
Track Your Data Analyst Roadmap Progress
Sign in with Google to check off completed topics, save code notes, and monitor your placement readiness score.
Start Tracking Roadmap