Data & analysis

Books matched to this capability.

5books in this track

L01 · User

Who is affectedOnly you
T10-L01

Ask a Spreadsheet a Question and Check Which Rows It Used

Upload a table to a chat assistant, get an answer without writing a formula, and check it: ask which rows it counted, recount one group in your spreadsheet, and catch the three silent failures of dropped rows, numbers read as text and filters you never asked for.

Outcome: Three answers from your own table, each with the assistant's row accounting and your own recount of one group; it passes when every source row is accounted for and each recount matches or explains the difference.

User14 minLast edited: Sep 23, 2026

L02 · Power user

Who is affectedYour team sees a bad document or a wrong figure
T10-L02

Clean a Messy Export Once, So Your Team Can Refresh It

Turn a monthly export with a broken header, mixed units and placeholders into a clean table a colleague can refresh without you. Let an assistant find the problems, agree the rules with the person who owns the data, and let Excel's Power Query apply them the same way every month, with checks that show every row.

Outcome: A shared workbook that cleans the export with recorded steps, plus its rules sheet and check block, refreshed on a second month's file by a colleague; it passes when rows in equal clean rows plus flagged rows plus removed duplicates, and the colleague explains one flagged row from the workbook alone.

Power user17 minLast edited: Sep 23, 2026

L03 · Builder

Who is affectedColleagues depend on something you built
T10-L03

Build an Analysis Your Colleague Can Rerun and Get the Same Numbers

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.

Outcome: A Git repository with the analysis script, settings per month, a lockfile, a sample with a hand-checked expected summary, a check script and a README; it passes when a colleague clones it on their own computer, the check prints PASS, and their rerun of one real month gives a summary identical to yours.

Builder20 minLast edited: Sep 23, 2026

L04 · Integrator

Who is affectedCompany or lab systems and real data are in the loop
T10-L04

Connect Your Analysis to a Live System, and Stop Bad Data Before It Reaches Anyone

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.

Outcome: A scheduled pipeline reading a live source through a read-only account; it passes when a deliberately corrupted copy of the source makes the run stop with a clear message and leaves the last accepted output unchanged, a write attempt with the pipeline's account is refused, the data owner and IT have signed the field list, and a colleague can rerun a stopped week from the run sheet.

Integrator20 minLast edited: Sep 23, 2026

L05 · Operator

Who is affectedWork stops when it breaks, and it must survive you leaving
T10-L05

Keep a Data Pipeline Right for Years, and Trace Any Published Number to Its Source

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.

Outcome: A written trace of one number that was published from the pipeline, from where it appears back to the source rows, which passes when every step names its run ID, fingerprint and person, the missed-run alert and the drift check have each fired once in a test, and a colleague repeats the trace from the runbook alone and reaches the same rows.

Operator18 minLast edited: Sep 23, 2026