
Track · Intermediate
Data Science
Turn messy real-world data into decisions people trust.
Clean and join messy records, measure uncertainty honestly, run experiments, and work in the tools teams actually use — Excel, SQL, survey data and maps — ending with an investigation of real World Bank data.
- Modules
- 7
- Labs
- 30
- Projects
- 5
- Activities
- 229
The journey
7 modules, one skill at a time
- 1
Scientific Python
4 labs
From raw CSV to first insight
- 2
Wrangling real-world data
5 labs
Clean data you can defend
- 3
Visual storytelling
3 labs
Charts that tell the truth
- 4
Statistics & inference
6 labs
Numbers with honest error bars
- 5
Experiments & causal thinking
4 labs
Cause, not just correlation
- 6
Real-world data & tools
5 labs
Fluent in the working toolkit
- 7
Communicating with data
3 labs
Data scientist
What you'll build
5 projects from real local data

Project · Module 2
Clinic Records Clean-up
A regional health office gets messy monthly exports from 18 clinics. Build the clean-up pipeline, a data-quality report to send back to the clinics, and a malaria summary they can trust.

Project · Module 4
Did the Programme Work?
A county gave 20 struggling schools extra support, and their exam scores jumped. Before the county scales it up, work out how much of that jump the programme caused — and how sure anyone can be.

Project · Module 5
The Savings Reminder Trial
A mobile-money provider ran a randomised trial of two SMS reminders. Analyse it properly — balance, lifts with intervals, what the trial can and can't tell apart — and advise on the rollout.

Project · Module 6
County Services Survey Report
A county planning office commissioned a household survey. Produce the official estimates — weighted, with uncertainty — and deliver them as an Excel workbook and a map they can put straight into their plan.

Project · Module 7
Open-Data Investigation
Your final project uses real open data. An energy-access charity asks: which African countries made the fastest progress on electricity since 2000 — and did rural areas keep up? Investigate the World Bank's data end to end and deliver a brief, a chart and a workbook.
Syllabus
Every module and lab
- Lesson
- Interactive
- Quiz
- Trace
- Puzzle
- Find the bug
- Scenario
- Practice
- Challenge
- Reflect
Scientific Python
NumPy, pandas and matplotlib — the toolkit every analysis is built on. Shared with the AI & ML track.
4 labs · 32 activities
Lab 01 · Arrays & vectorisation
NumPy: Whole Columns at Once
Machine learning is maths on thousands of numbers at once. NumPy arrays let you do it in one line — no loops — and they're what every ML library runs on underneath.
35 min8 activitiesLab 02 · DataFrames
pandas: Tables You Can Question
pandas is the spreadsheet of data science. Load 80 farms, select, filter, group and clean them — the everyday moves before any model is trained.
40 min8 activitiesLab 03 · matplotlib
Visualising Data
A chart shows in a second what a table hides. Learn to pick the right chart for the question and draw it with matplotlib — scatter, bar, line and histogram.
40 min8 activitiesLab 04 · EDA
Exploratory Data Analysis
Before any model: get to know your data. Summaries, distributions, outliers and correlations — and the discipline to say what the data does and doesn't show.
45 min8 activities
Milestone 1
From raw CSV to first insight
You can load, summarise and chart a dataset — and say what it does and doesn't show.
Wrangling real-world data
Turn a vague question into an answerable one, and messy multi-table records into data you can trust.
5 labs · 42 activities
Lab 05 · Questions, units and denominatorsThinking lab
Framing a Data Question
A county health officer asks: "Where is malaria worst?" Before any code, turn that into a question data can answer — and discover how the choice of denominator changes the answer.
30 min9 activitiesLab 06 · Duplicates, labels and impossible values
Cleaning Real-World Data
Clinic records typed by busy staff are full of double entries, spelling variants, "999 = unknown" codes and unit slips. Clean them with rules you can defend — and count what every rule changed.
45 min9 activitiesLab 07 · Merges, pivots and melts
Joining & Reshaping
Answers usually need more than one table. Join visits to clinics and populations without losing or doubling rows, then reshape the result between long and wide to answer month-by-month questions.
45 min9 activitiesLab 08 · The columns that cause the most bugs
Dates, Text & Categories
Three date formats in one column, a pandas shortcut that silently gets hundreds of them wrong, and ages that need grouping. Parse, extract and categorise with care — then find the malaria season.
45 min10 activitiesProject · Capstone
Clinic Records Clean-up
A regional health office gets messy monthly exports from 18 clinics. Build the clean-up pipeline, a data-quality report to send back to the clinics, and a malaria summary they can trust.
60 min5 activities
Milestone 2
Clean data you can defend
You can frame a precise question, clean messy records with logged rules, join and reshape tables safely, and parse dates without silent errors.
Visual storytelling
See the shape of the data, find real relationships, and design charts that make the point honestly.
3 labs · 23 activities
Lab 09 · The shape of the data
Distributions & Outliers
Before any average, look at the whole distribution. Explore 600 incomes: their skew, why mean and median disagree, which values are outliers — and how urban and rural applicants compare.
40 min8 activitiesLab 10 · Scatter plots, correlation and its traps
Relationships
Two variables moving together can mean a lot or nothing. Plot before you calculate, measure correlation properly, and meet the paradox where every group says one thing and the total says the opposite.
40 min8 activitiesLab 11 · Charts that make the point — honestly
Designing Clear Charts
A correct chart isn't the same as a clear one. Turn a default bar chart into one a busy decision-maker understands in five seconds, keep the axes honest, and compare six counties at a glance.
40 min7 activities
Milestone 3
Charts that tell the truth
You can describe distributions, read relationships without being fooled by them, and design clear, honest charts.
Statistics & inference
How sure can you be? Sampling, uncertainty and tests — building on the shared Statistics and Probability labs.
6 labs · 45 activities
Lab 12 · Distributions & spread
Statistics That Matter
Mean, median, standard deviation, the normal distribution, and why a sample never tells you the exact truth — the statistics every model result leans on.
35 min8 activitiesLab 13 · Conditional probability
Probability & Bayes
Why a positive test can still be unlikely, how spam filters think, and how to reason about uncertainty with simulation and Bayes' rule.
35 min8 activitiesLab 14 · How a few can describe many
Samples & Populations
Surveys ask a few thousand people and describe millions. See why that works — sampling error shrinks predictably — and why it fails when the sample is biased, however big it gets.
40 min8 activitiesLab 15 · Honest error bars
Confidence Intervals & the Bootstrap
An estimate without uncertainty is half an answer. Build confidence intervals for a proportion, check what "95%" really promises, and use the bootstrap to put error bars on anything — even a median.
40 min8 activitiesLab 16 · Signal or noise?
Hypothesis Tests
A new maize variety yields 2 more bags per acre on trial plots. Real, or luck? Build a permutation test from scratch, check it against the t-test, and learn why testing everything guarantees false discoveries.
45 min8 activitiesProject · Capstone
Did the Programme Work?
A county gave 20 struggling schools extra support, and their exam scores jumped. Before the county scales it up, work out how much of that jump the programme caused — and how sure anyone can be.
60 min5 activities
Milestone 4
Numbers with honest error bars
You can say how sure an estimate is, test whether a difference is real, and spot regression to the mean before it fools a decision-maker.
Experiments & causal thinking
Telling "causes" from "goes along with" — with experiments when you can, and careful comparisons when you can't.
4 labs · 28 activities
Lab 17 · Randomised experiments
A/B Tests
A mobile-money provider wants to know whether an SMS reminder makes customers save. Randomise, check the groups are balanced, estimate the lift with a confidence interval — and work out how many users you'd need.
45 min8 activitiesLab 18 · When a third factor fools you
Confounding
Students who get private tuition score 9 points higher. Does tuition cause that? Find the confounder, compare like with like, and adjust with regression — and see how much of the gap survives.
40 min7 activitiesLab 19 · Difference-in-differences
Natural Experiments
Machakos launched a community health programme and child immunisation rose. But it was rising before, and in neighbouring Makueni too. Use difference-in-differences to separate the programme from the trend.
40 min7 activitiesProject · Capstone
The Savings Reminder Trial
A mobile-money provider ran a randomised trial of two SMS reminders. Analyse it properly — balance, lifts with intervals, what the trial can and can't tell apart — and advise on the rollout.
60 min6 activities
Milestone 5
Cause, not just correlation
You can design and analyse an A/B test, adjust for confounders, and evaluate a policy with difference-in-differences.
Real-world data & tools
The tools analysts use every day — Excel, SQL, survey weights and maps — on data shaped like the real thing.
5 labs · 36 activities
Lab 20 · Working with the world's most-used data tool
Excel & Spreadsheets
Most organisations still run on spreadsheets. Read a real-looking office workbook — title rows, totals, lost leading zeros and all — tidy it with pandas, and hand back a clean Excel report your colleagues can open.
45 min8 activitiesLab 21 · Asking questions of databases
SQL for Analysts
Real data lives in databases, and SQL is how you ask for it. Build a database in your browser, then filter, group, join and clean with SQL — and hand the answers to pandas.
45 min7 activitiesLab 22 · Estimating for a whole population
Survey Data & Weights
Household surveys deliberately over-sample small areas, so a plain average is wrong. Use design weights to turn a sample of 760 households back into an estimate for all 5,000 — and for totals, not just shares.
40 min8 activitiesLab 23 · Coordinates, boundaries and choropleths
Maps & Location Data
Where something happens is often the story. Draw Kenya's 47 counties from real boundary data, map population density honestly, and measure distances between places on a round Earth.
45 min8 activitiesProject · Capstone
County Services Survey Report
A county planning office commissioned a household survey. Produce the official estimates — weighted, with uncertainty — and deliver them as an Excel workbook and a map they can put straight into their plan.
60 min5 activities
Milestone 6
Fluent in the working toolkit
You can read and write Excel workbooks, query databases with SQL, produce weighted survey estimates and map data honestly.
Communicating with data
Findings only matter if people understand and act on them.
3 labs · 23 activities
Lab 24 · From analysis to messageThinking lab
Storytelling with Data
Kenya went from 15% to 76% electricity access in two decades — the fastest gain among 20 African countries. Turn real World Bank data into a message a busy reader gets in one glance: the right numbers, in context, on an annotated chart.
35 min9 activitiesLab 25 · The tools of recurring reporting
Reports & Dashboards
Some questions come back every month. Design a dashboard for a county health director, build it in Python, and publish it as a shareable report — and learn where Power BI, Tableau, Looker Studio and notebooks fit.
45 min8 activitiesProject · Final capstone
Open-Data Investigation
Your final project uses real open data. An energy-access charity asks: which African countries made the fastest progress on electricity since 2000 — and did rural areas keep up? Investigate the World Bank's data end to end and deliver a brief, a chart and a workbook.
75 min6 activities
Milestone 7
Data scientist
You can take a real question from raw open data to a clear brief, chart and workbook that a decision-maker can act on.