Every module includes three substantial lessons, downloadable source files, practical exercises, explained solutions and a knowledge check. Modules marked free are available under the current public access rules. Protected self-learning modules are free after registration and email verification. Publication, prerequisites and explicit private-access rules still apply.
01Free module
Understand your source data
Inspect file structure, encoding, business grain and field meaning before calculating anything.
- A source inventory with hashes and row counts
- A field dictionary with grain and units
- An acceptance contract and open questions
Overview & practice files ↗View lesson outline
- File formats and encodings
- Data types and analytical grain
- Build a source inventory and dictionary
02Free module
Clean data without losing evidence
Resolve defensible defects, quarantine uncertainty and keep a traceable record of every correction.
- A missingness and duplicate profile
- A category mapping and correction log
- A reconciled acceptance report
Overview & practice files ↗View lesson outline
- Missing values and duplicate records
- Inconsistent categories and safe corrections
- Document corrections and reconcile the result
03Free · verified account
Processing data with Python
Load explicit schemas, transform safely and retain errors as reviewable records.
- A local Python environment and typed inputs
- A validated line-level transformation
- A rejected-record file and executable checks
View access requirements ↗View lesson outline
- Reading CSV, Excel and JSON · Verified account
- Transforming columns with explicit rules · Verified account
- Handling errors and rejected records · Verified account
04Free · verified account
Combining and restructuring datasets
Protect grain while joining, reshaping and reconciling multiple sources.
- A tested many-to-one enrichment
- A six-row long planning table
- A reconciliation showing coverage and amplification risks
View access requirements ↗View lesson outline
- Joins and matching keys · Verified account
- Wide and long data formats · Verified account
- Reconciliation and duplicate amplification · Verified account
05Free · verified account
Building repeatable data pipelines
Make an explicit snapshot workflow reproducible and design safe reruns and incremental rules.
- A staged extract–transform–validate–publish workflow
- A reproducible run manifest and failure log
- An incremental design with late-update and deletion rules
View access requirements ↗View lesson outline
- Extract–transform–load steps · Verified account
- Validation rules and run logging · Verified account
- Reruns and incremental processing · Verified account
06Free · verified account
Data preparation portfolio project
Deliver a reproducible preparation workflow and an evidence-led handover using all three sources.
- An implemented snapshot pipeline and source contract
- A tested reconciliation and failure matrix
- A handover with limitations and an independent extension
View access requirements ↗View lesson outline
- Multiple imperfect sources: define the project · Verified account
- Implement a tested processing workflow · Verified account
- Document outputs and hand over the work · Verified account