Cheat sheet · Beginner · 5 min
Analysis checklist cheat sheet
The steps between a question and a defensible answer. 4 sections, 13 entries.
- Define
- Profile
- Compute
Entries 13
Lab · Intermediate · 40 min
Lab: The wrong number
Find why two reports disagree on the same metric.
- Finance says 1,420 active subscribers; product says 1,388. Both are right by their own definitions and nobody has written them down.
Tasks 3
Project · Intermediate · 6h
Project: A defended analysis of a real question
Take a real business question end to end: definition, profile, query with reconciliation, chart, one-page write-up, and a review by a sceptic.
- Choose a question someone in your business actually asks. Write the metric definition and get it agreed. Profile the data and write notes. Build the query with a reconciliation check. Produce one chart with the finding as its title and a caveat beneath. Write the one-page analysis and have a sceptical colleague review it; record their questions and revise.
- Milestone 1: Define and profile
- Milestone 2: Compute and chart
Learning path · Intermediate · 6h
Analysis you can defend
From a business question to a chart with a caveat, with definitions, checks and a write-up that survives scrutiny.
- Answer business questions from data with defined metrics, reconciled queries, honest charts and a one-page write-up.
- Skills: Turning questions into metric definitions, Profiling and cleaning data, SQL and spreadsheet aggregation, Chart choice and annotation, Writing up with caveats
Time 6h

Instant delivery after paymentLicence stated on every productRe-download anytime from My LibrarySecure checkout — Polar or FungiesNew products every week

Products GamingNew Subscriptions Deals Membership Licensing

Search

Analysis checklist cheat sheet

Lab: The wrong number

Project: A defended analysis of a real question

Analysis you can defend