A woman in glasses working on a laptop in a busy office

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

    Scientific Python

    4 labs

    From raw CSV to first insight

  2. 2

    Wrangling real-world data

    5 labs

    Clean data you can defend

  3. 3

    Visual storytelling

    3 labs

    Charts that tell the truth

  4. 4

    Statistics & inference

    6 labs

    Numbers with honest error bars

  5. 5

    Experiments & causal thinking

    4 labs

    Cause, not just correlation

  6. 6

    Real-world data & tools

    5 labs

    Fluent in the working toolkit

  7. 7

    Communicating with data

    3 labs

    Data scientist

What you'll build

5 projects from real local data

Syllabus

Every module and lab

  • Lesson
  • Interactive
  • Quiz
  • Trace
  • Puzzle
  • Find the bug
  • Scenario
  • Practice
  • Challenge
  • Reflect
01

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 activities
  • Lab 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 activities
  • Lab 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 activities
  • Lab 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.

02

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 activities
  • Lab 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 activities
  • Lab 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 activities
  • Lab 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 activities
  • Project · 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.

03

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 activities
  • Lab 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 activities
  • Lab 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.

04

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 activities
  • Lab 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 activities
  • Lab 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 activities
  • Lab 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 activities
  • Lab 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 activities
  • Project · 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.

05

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 activities
  • Lab 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 activities
  • Lab 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 activities
  • Project · 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.

06

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 activities
  • Lab 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 activities
  • Lab 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 activities
  • Lab 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 activities
  • Project · 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.

07

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 activities
  • Lab 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 activities
  • Project · 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.