All books
Compare the outcome you want, then open a book. Filter by level and track.
Progress is saved in this browser only.
5 books
Data & analysis5
- T10-L01Ask a Spreadsheet a Question and Check Which Rows It UsedThree 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.
- T10-L02Clean a Messy Export Once, So Your Team Can Refresh ItA 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.
- T10-L03Build an Analysis Your Colleague Can Rerun and Get the Same NumbersA 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.
- T10-L04Connect Your Analysis to a Live System, and Stop Bad Data Before It Reaches AnyoneA 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.
- T10-L05Keep a Data Pipeline Right for Years, and Trace Any Published Number to Its SourceA 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.