Course Structure

Professional Data Analysis Roadmap

This page turns the course audit into a practical expansion plan. The first professional unit is now live, and the lesson-level review is documented in LESSON_AUDIT.md. The next layer should continue closing the gaps around EDA, statistics, advanced SQL, data products, storytelling, and portfolio delivery.

Coverage Audit

What is covered now?

covered

Python Foundations

Units 1-3 cover setup, notebooks, syntax, data structures, functions, files, and error handling.

covered

Analysis Core

Units 4-6 cover NumPy, pandas, missing data, types, validation, outliers, and cleaning workflows.

partial

EDA and Statistics

Unit 7 starts the topic; the training notebook adds distributions, sampling, confidence intervals, and hypothesis tests.

gap

SQL and Data Sources

Unit 9 introduces SQL/APIs, but advanced joins, window functions, CTEs, JSON, and source quality need a full module.

partial

Storytelling and Dashboards

Unit 8 has visualization tools. The missing layer is choosing charts, writing insights, and packaging dashboards for decisions.

partial

Portfolio Workflow

Unit 10 now covers Git, GitHub, reproducibility, README structure, and release checklists. Deployment can become a later expansion.

01

Python Foundations

Finish Units 1-3 first. The goal is comfort with notebooks, scripts, functions, data structures, errors, and reusable code.

  • Outcome: write clean Python scripts and notebooks.
  • Practice: solve every lesson task without opening the solution first.
02

Analysis Core

Use Units 4-6 to build the working analyst toolkit: arrays, DataFrames, missing values, outliers, types, and cleaning rules.

  • Outcome: clean a raw CSV into an analysis-ready dataset.
  • Practice: document every cleaning decision.
03

EDA and Statistics

Turn summaries into real questions: distributions, segments, correlations, confidence intervals, and hypothesis testing.

  • Outcome: produce 5 decision-ready findings.
  • Practice: use the training notebook statistics sections.
04

SQL and Data Sources

Expand beyond files: relational joins, CTEs, window functions, APIs, JSON normalization, and responsible scraping.

  • Outcome: combine database, API, and CSV data in one project.
  • Practice: rebuild a pandas analysis from SQL queries.
05

Visualization and Storytelling

Move from charts to communication: chart choice, annotation, executive summaries, accessibility, and narrative order.

  • Outcome: one-page insight report with annotated visuals.
  • Practice: rewrite chart titles as business conclusions.
06

Dashboards and Portfolio

Package the work: Plotly or Streamlit dashboards, demo apps, polished project summaries, and deployment notes.

  • Outcome: one public portfolio project.
  • Practice: ship a dashboard and a clean README.
07

ML for Analysts

Keep ML practical: train/test split, leakage, baseline models, metrics, feature importance, and business interpretation.

  • Outcome: explain model performance without overclaiming.
  • Practice: compare a baseline with one improved model.
08

Capstone Delivery

Finish with real datasets, a clean notebook, a dashboard or report, a README, and 5-7 decision-focused insights.

  • Outcome: interview-ready project evidence.
  • Practice: review the project as if it belongs to a client.
Expansion Priority

Recommended future units

Next unit Main problem it solves Expected deliverable
Unit 11: EDA and Applied Statistics The current path needs deeper business questions, distributions, sampling, confidence, and hypothesis testing. An EDA report with evidence-backed recommendations.
Unit 12: Advanced SQL and Data Sources Unit 9 is crowded; SQL, APIs, JSON, and scraping deserve a dedicated workflow. A mini warehouse analysis using SQL plus an external API.
Unit 13: Dashboards and Data Storytelling Charts become valuable only when they support decisions and can be shared clearly. A dashboard and a one-page executive summary.
Unit 14: Portfolio Review and Deployment Learners need to turn exercises into polished portfolio artifacts. A deployed portfolio project with review checklist.
Current Companion Files

Use these resources now

The notebooks already add practical coverage for Git, EDA, statistics, SQL, APIs, dashboards, and portfolio preparation while the web units are being expanded.