PLAN-101 Career OS
All Levels Estimated: 12 Weeks 12 Topics

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.

  1. 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.
  2. 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.
  3. 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.

  1. 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.
  2. 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.
  3. 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.

  1. 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).
  2. 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.
  3. 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.

  1. 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.
  2. 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.
  3. 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:

3-Year CSE Roadmap → Frontend Developer → Backend Developer → Full-Stack Developer →

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