Python Foundations
Units 1-3 cover setup, notebooks, syntax, data structures, functions, files, and error handling.
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.
Units 1-3 cover setup, notebooks, syntax, data structures, functions, files, and error handling.
Units 4-6 cover NumPy, pandas, missing data, types, validation, outliers, and cleaning workflows.
Unit 7 starts the topic; the training notebook adds distributions, sampling, confidence intervals, and hypothesis tests.
Unit 9 introduces SQL/APIs, but advanced joins, window functions, CTEs, JSON, and source quality need a full module.
Unit 8 has visualization tools. The missing layer is choosing charts, writing insights, and packaging dashboards for decisions.
Unit 10 now covers Git, GitHub, reproducibility, README structure, and release checklists. Deployment can become a later expansion.
Finish Units 1-3 first. The goal is comfort with notebooks, scripts, functions, data structures, errors, and reusable code.
Use Units 4-6 to build the working analyst toolkit: arrays, DataFrames, missing values, outliers, types, and cleaning rules.
Turn summaries into real questions: distributions, segments, correlations, confidence intervals, and hypothesis testing.
Expand beyond files: relational joins, CTEs, window functions, APIs, JSON normalization, and responsible scraping.
Move from charts to communication: chart choice, annotation, executive summaries, accessibility, and narrative order.
Package the work: Plotly or Streamlit dashboards, demo apps, polished project summaries, and deployment notes.
Keep ML practical: train/test split, leakage, baseline models, metrics, feature importance, and business interpretation.
Finish with real datasets, a clean notebook, a dashboard or report, a README, and 5-7 decision-focused insights.
| 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. |
The notebooks already add practical coverage for Git, EDA, statistics, SQL, APIs, dashboards, and portfolio preparation while the web units are being expanded.