Search & explore

• Level L05
• T10
• 18 min read

Run a data pipeline that many people rely on: keep every run's input, code and output under one run ID, watch that it ran and that its data still look like last month's, approve before anything is published, and trace any number in a board pack or paper back to its source rows, even after you've left.

Matching textT10-L05 · Data & analysis · Level 5 Operator · 17-minute read, plus 4 hours of doing Keep a Data Pipeline Right for Years, and Trace Any Published Number to Its Source A green run

• Level L04
• T10
• 20 min read

Move a rerunnable analysis from copied files to a live database: a read-only account that sees one view, quality checks that stop the run before any output, only the fields the task needs (and fewer still for any AI model), a schedule that can't overlap, and a last good result that stays when a check fails.

Matching textT10-L04 · Data & analysis · Level 4 Integrator · 18-minute read, plus 4 hours of doing Connect Your Analysis to a Live System, and Stop Bad Data Before It Reaches Anyone The report was

• Level L03
• T10
• 20 min read

Turn a monthly analysis into a pipeline anyone in the group can rerun: a script, settings per run, a pinned Python environment, a fingerprint for every input, recorded analyst decisions, a sample with hand-checked answers and a README. Done when a colleague reruns it on a fresh copy and gets your numbers.

Matching textT10-L03 · Data & analysis · Level 3 Builder · 17-minute read, plus 3 hours of doing Build an Analysis Your Colleague Can Rerun and Get the Same Numbers The figure nobody could rebuild Clara'

• youtube

Ask Claude to summarise and analyse spreadsheet data. Excel add-in rather than file upload; independent recount/reconciliation not established; use synthetic copy.

Matching textT10-L01: See spreadsheet questions handled through Claude's Excel add-in in this Anthropic-sponsored tutorial. It uses a different interface from the book: work on a made-up copy, then independently…

• youtube

Record cleaning transformations and refresh folder imports. Not unit-conversion rules, row accounting or handover.

Matching textT10-L02: Learn to turn messy exports into repeatable Power Query steps and refresh files from a folder. Add the book's unit rules and row checks before sharing the workbook.

• youtube

Reproduce Python environments with locks and sync. Does not validate analysis choices, exclusions or numeric results.

Matching textT10-L03: Learn how uv manages project dependencies, lockfiles and environments. This 2025 tutorial complements the book's reproducible setup; keep its separate checks for inputs, analyst decisions…