Back to Grain First
FoundationGrain First · Analytical25 minsPaired C1 Executive Unit →

Unit of Analysis & Row Grain

Can state the unit of analysis and what exactly one row represents in an unfamiliar table.

EVD-01FoundationGrain First · Analytical

Can-Do: Can state the unit of analysis and what exactly one row represents in an unfamiliar table

L0 · Not Started
Preview mode — all interactive exercises work right away. Sign in free to record Level 1 & Level 2 attainment.Create free account

Before writing a single COUNT, AVG, or percentage, an analyst must separate two distinct questions:

  1. Table row grain: What real-world event or record produces exactly one row in the source table?
  2. Question unit of analysis: Which entity and eligible population does the decision-maker's question actually ask about?

When row grain (booking_id) and question grain (candidate_id or attended tests) diverge, dividing by COUNT(*) silently answers the wrong question.

Worked Example (Level 1 — Modelled): Driving Test bookings (2026-09-01 to 2026-09-04)

Inspect all 12 rows (B01–B12) across 8 distinct candidates (C01–C08). Four candidates (C01, C03, C05, C07) appear twice.

booking_idcandidate_idbooking_datecentrestatus
B01C012026-09-01NorthFail
B02C022026-09-01CentralPass
B03C032026-09-01NorthCancelled
B04C012026-09-03NorthPass
B05C042026-09-02SouthNo-show
B06C052026-09-02CentralFail
B07C032026-09-03NorthPass
B08C062026-09-02SouthPass
B09C052026-09-04CentralFail
B10C082026-09-03CentralCancelled
B11C072026-09-02SouthFail
B12C072026-09-04SouthPass
Level 1 Check · Modelled

What does exactly one row represent in this `bookings` extract?

Level 1 Check · Modelled

Denominator 1 — All booking slots: 5 Pass rows out of 12 total bookings equals %%.

Hint: Compute 5 ÷ 12 × 100 = 41.67% (accepts 41.67 or 41.7).

Level 1 Check · Modelled

Denominator 2 — Attended tests only (excluding B03, B10 Cancelled and B05 No-show): 5 passes out of 9 attended tests equals %%.

Hint: Compute 5 ÷ 9 × 100 = 55.56% (accepts 55.56 or 55.6).

Level 1 Check · Modelled

Denominator 3 — Distinct booked candidates: 5 candidates with a recorded pass (C01, C02, C03, C06, C07) out of 8 booked candidates equals %%.

Hint: Compute 5 ÷ 8 × 100 = 62.5%.


Supported Practice (Level 2): Planted-Mismatch & Null-Item Claim Audit

Audit each colleague claim below against the bookings extract. Remember Errorless Craft: accept sound claims (supported null items) without inventing flaws, and flag numerator/denominator grain mismatches accurately.

Level 2 Check · Supported Practice

Claim 1: "55.56% of bookings ended in a pass: 5 divided by 9."

Level 2 Check · Supported Practice

Claim 2: "41.67% of tests taken ended in a pass: 5 divided by 12."

Level 2 Check · Supported Practice

Claim 3: "50.0% of candidates who attended passed their first attended test recorded in this extract: 3 divided by 6."

Level 2 Check · Supported Practice

Claim 4: "62.5% of candidates with a booking have a recorded pass in this extract: 5 divided by 8."

Level 2 Check · Supported Practice

Boundary Check: Why can this 4-day extract (`2026-09-01` to `2026-09-04`) NOT answer "What is our lifetime first-attempt pass rate for all enrolled learners?"

Competency Progression

Unit Attainment Checkpoint

L0 · Not Started
Level 1 · Modelled0 / 4 checks

Complete the guided echo & noticing checks inline above to establish accurate muscle memory with full scaffolding.

Level 2 · Supported0 / 5 checks

Apply the target patterns across structured distractors and data scenarios. Earning Level 2 unlocks 1-on-1 session booking.

Levels 3 & 4 · Live & TaughtComing Soon

Independent cold-transfer verification (Level 3) and peer-teaching sign-off (Level 4) are rolling out via live Discord cohorts and Conversation Groups.