CareerTalkLab / Grain First

2 Live · 71 In Development

Grain First — Data Analytics

Practical measurement, denominator hygiene, and bottleneck analysis for data and software careers. Every unit progresses from Level 1 (Modelled) and Level 2 (Supported Practice) to live cohort cold-transfer (L3) and peer teaching (L4).

EVD-01 · LIVE NOWM1 · Track 1

Grain, Rows & Silent Exclusions: What Does One Row Represent?

Audit a 12-row Driving Test booking log (`B01`–`B12` across candidates `C01`–`C08`), reconcile attempt-level vs. candidate-level pass rates, and earn Level 1 & Level 2 attainment. Also paired with Business English C1-EXEC-EVD-01.

EVD-02 · LIVE NOWM1 · Track 1

Measurement Levels & Valid Summaries: What Summaries Can You Trust?

Classify Nominal, Ordinal, Interval, and Ratio columns on a 15-row branch Feedback export (RSP-01–RSP-15), catch nominal code traps, and resolve the North vs. South rating rank flip for Level 1 & Level 2 attainment.

M0

Track 0 · Orientation & Analytical Framing

4 units

Establish workspace setup, question framing, and analytical workflow habits before touching raw tables.

ORI-01FoundationIn Development

The Decision Contract

Can state what question an analysis answers, who acts on it, and what changes as a result

ORI-02FoundationIn Development

Isolated Analysis Environments

Can build an isolated, reproducible analysis environment from nothing

ORI-03FoundationIn Development

Version Control for Analysis

Can version an analysis: branch, commit, diff, revert, and recover a deleted file

ORI-04FoundationIn Development

Zero-Question Reproducibility

Can publish a repository a stranger can clone and reproduce without asking questions

M1

Track 1 · Evidence, Grain & Denominators

9 units

Identify table grain, distinguish event rows from entity counts, and audit silent denominator exclusions.

EVD-01FoundationLive L1 & L2

Unit of Analysis & Row Grain

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

L0 · Not Started
EVD-02FoundationLive L1 & L2

Measurement Levels & Valid Summaries

Can classify variables by measurement level and say which summaries are legitimate for each

L0 · Not Started
EVD-03FoundationIn Development

Distributions, Spread & Skew

Can describe a distribution by centre, spread and shape, and say when the mean misleads

EVD-04FoundationIn Development

Fair Denominators & Rates

Can choose a denominator that makes a comparison fair, and convert counts to rates

EVD-05FoundationIn Development

Sampling Frames & Unrepresented Populations

Can identify how a sample was drawn and name the populations it does not represent

EVD-06FoundationIn Development

Signal vs. Routine Variation

Can distinguish variation from change, and say how much movement is unremarkable

EVD-07FoundationIn Development

What p-Values & Intervals Claim

Can state what a p-value and an interval estimate do and do not claim

EVD-08FoundationIn Development

Confounding & Simpson's Paradox

Can detect confounding and demonstrate a Simpson's-paradox reversal in real data

EVD-09FoundationIn Development

Survivorship, Selection & Measurement Bias

Can audit an analysis for survivorship, selection and measurement bias

M1

Track 2 · Spreadsheets & Tabular Reconciliation

6 units

Build auditable spreadsheet checks, pivot reconciliations, and explicit grain keys without silent row loss.

SHT-01FoundationIn Development

Raw Sheet Profiling

Can profile a raw sheet: row count, types, missingness, duplicates, impossible values

Prerequisites:EVD-01 L3EVD-04 L3
SHT-02FoundationIn Development

Non-Destructive Cleaning & Audit Trail

Can clean without destroying the original, leaving a documented transformation trail

SHT-03FoundationIn Development

Cross-Sheet Matching & Row Accounting

Can match records across two sheets and account for unmatched, excluded and multiplied rows

SHT-04FoundationIn Development

Grain Aggregation & Source Reconciliation

Can aggregate to any grain and reconcile the total back to the source

SHT-05FoundationIn Development

Separated Inputs & Formula Models

Can build a calculation model whose inputs are visibly separated from its formulas

SHT-06FoundationIn Development

Question-Driven Chart Selection

Can select a chart form from the question being asked rather than the data's shape

M2

Track 3 · Relational Grain & SQL

11 units

Prevent join fan-out, write grain-preserving aggregations, and verify row-count invariants in SQL.

SQL-01Working AnalystIn Development

Single-Table Filtering & Row Prediction

Can filter, sort and limit a single table and predict the row count before running it

Prerequisites:SHT-03 L3SHT-04 L3
SQL-02Working AnalystIn Development

GROUP BY & Result-Set Grain

Can aggregate with GROUP BY and state the grain of the result set

SQL-03Working AnalystIn Development

Primary Key Discovery & Uniqueness Proofs

Can identify the primary key of an unfamiliar table and prove its uniqueness

SQL-04Working AnalystIn Development

Join Mechanics & Row Fate Prediction

Can predict which rows each join type keeps, drops and duplicates, before running it

SQL-05Working AnalystIn Development

Detecting & Repairing Join Fan-Out

Can detect and repair join fan-out that silently inflates a sum

SQL-06Working AnalystIn Development

Filtering Aggregates: HAVING vs. WHERE

Can filter on aggregates and articulate why WHERE cannot do it

SQL-07Working AnalystIn Development

Readable Multi-Step Queries with CTEs

Can compose a multi-step query with CTEs that another analyst can read unaided

SQL-08Working AnalystIn Development

Window Functions & Period-over-Period Analysis

Can rank, offset and window over partitions to answer period-over-period questions

SQL-09Working AnalystIn Development

Conditional Logic & Defensible Bucketing

Can branch logic with CASE and bucket a continuous variable defensibly

SQL-10Working AnalystIn Development

Pre-Delivery Query Validation Checks

Can validate a result with row-count, total and spot checks before anyone else sees it

SQL-11Working AnalystIn Development

Undocumented Schema Exploration & Data Dictionaries

Can explore an undocumented schema and produce a data dictionary for the tables in scope

M2

Track 4 · Analytical Data Modeling

7 units

Design clean fact and dimension grains, snapshotting rules, and metric definitions that survive scale.

MOD-01Working AnalystIn Development

Reading & Reconstructing ER Diagrams

Can read an entity-relationship diagram, and reconstruct one from an undocumented database

Prerequisites:EVD-06 L3SQL-05 L3
MOD-02Working AnalystIn Development

Normalising Flat Files into Entities

Can decompose a flat file into entities and relationships, and say what that buys

MOD-03Working AnalystIn Development

Facts, Dimensions & One-Sentence Fact Grain

Can distinguish facts from dimensions and declare the grain of a fact table in one sentence

MOD-04Working AnalystIn Development

Slowly Changing Attributes & Historical State

Can explain how history is preserved when an attribute changes, and what breaks when it isn't

MOD-05Working AnalystIn Development

End-to-End Lineage & Pipeline Failure Points

Can trace the path data takes from source to report and name where it can break

MOD-06Working AnalystIn Development

Unambiguous Metric Specifications

Can define a metric precisely enough that two analysts compute it identically

MOD-07Working AnalystIn Development

Loud-Failing Data Assumption Tests

Can write data tests that fail loudly when an assumption stops holding

M3

Track 5 · Python for Reproducible Analysis

10 units

Automate validation, cohort checks, and reproducible notebooks over messy operational datasets.

PYA-01Working AnalystIn Development

Scripts vs. Notebooks as Analysis Containers

Can run an analysis as a script and as a notebook, and say when each is the right container

Prerequisites:SQL-08 L3SQL-10 L3
PYA-02Working AnalystIn Development

Dataset Loading, Profiling & Shape Reconciliation

Can load and profile a dataset and reconcile its shape against what was expected

PYA-03Working AnalystIn Development

Dataframe Selection, Filtering & SQL Equivalents

Can select, filter and derive columns, naming the SQL equivalent of each operation

PYA-04Working AnalystIn Development

Grouped Aggregation & Source Total Verification

Can group and aggregate to a declared grain and verify totals against the source

PYA-05Working AnalystIn Development

Dataframe Joins & Fan-Out Prevention

Can join dataframes and catch the same fan-out failures learned in SQL-05

Prerequisites:SQL-05 L3
PYA-06Working AnalystIn Development

Reshaping Long vs. Wide Form

Can reshape between long and wide form and say which the analysis actually needs

PYA-07Working AnalystIn Development

Temporal Alignment, Resampling & Timezones

Can parse, align and resample dates, and survive timezones and period boundaries

PYA-08Working AnalystIn Development

Statistical Computation & Substantive Interpretation

Can compute the Track 1 statistics in code and interpret the output, not merely produce it

Prerequisites:EVD-03 L3
PYA-09Working AnalystIn Development

Descriptive Linear Models & Scope Limits

Can fit and read a linear model as description, and state what it cannot support

PYA-10Working AnalystIn Development

Clean-Machine Reproducible Packaging

Can package an analysis so a colleague reproduces it on a clean machine

M3

Track 6 · Executive Analytical Communication

8 units

Translate reconciled numbers into decision memos that state grain, uncertainty, and next owner action.

COM-01Independent PractitionerIn Development

Comparison-Driven Visual Encoding

Can select an encoding from the comparison the question demands

Prerequisites:MOD-03 L3MOD-06 L3
COM-02Independent PractitionerIn Development

Preattentive Attributes & Visual Hierarchy

Can use preattentive attributes to direct attention to the finding, not decorate around it

COM-03Independent PractitionerIn Development

Honest Axes, Scales & Annotations

Can design an axis, scale and annotation set that cannot mislead a hurried reader

COM-04Independent PractitionerIn Development

Exploratory Dashboards vs. Explanatory Narratives

Can build an exploratory dashboard and keep it distinct from an explanatory narrative

COM-05Independent PractitionerIn Development

The Five-Part Analysis Memo

Can write an analysis memo: question, method, finding, caveat, recommendation

COM-06Independent PractitionerIn Development

Decision-Preserving Caveats & Limitations

Can state a finding's limitations without dissolving the recommendation

COM-07Independent PractitionerIn Development

Non-Technical Stakeholder Briefing & Defence

Can present to a non-technical stakeholder and hold up under the challenge questions

COM-08Independent PractitionerIn Development

Cross-Tool BI Rebuild & Reconciliation

Can rebuild one prior analysis in a second BI tool and account for what changed

M4

Track 7 · AI-Assisted & Agentic Analytics

6 units

Audit LLM-generated SQL/Python against ground-truth grain invariants and build reliable verification harnesses.

AIA-01Independent PractitionerIn Development

Schema- & Grain-Grounded Model Briefing

Can brief a model with schema, grain and constraints so its first draft is worth reading

Prerequisites:PYA-04 L3PYA-08 L3
AIA-02Independent PractitionerIn Development

Diagnosing AI Analytical Failure Modes

Can recognise the standard failure modes: invented joins, wrong grain, silent filtering, confident bad statistics

AIA-03Independent PractitionerIn Development

Verifying Generated SQL by Independent Recomputation

Can verify generated SQL by independent recomputation rather than by reading it

AIA-04Independent PractitionerIn Development

Rewrite vs. Repair Judgement

Can judge when generated code is faster to rewrite than to repair

AIA-05Independent PractitionerIn Development

AI Generation & Verification Audit Trails

Can keep an audit trail of what was generated and how each part was checked

AIA-06Independent PractitionerIn Development

Setting Hard Boundaries on Model Delegation

Can name the steps in an analysis where a model should not be used at all

M4

Track 8 · End-to-End Capstone

5 units

Deliver a complete, peer-defended analytical investigation from raw operational tables to executive action.

CAP-01Independent PractitionerIn Development

Stakeholder-Backed Domain Question Sourcing

Can source a question from a domain you know, with a named person who wants the answer

Prerequisites:EVD-09 L3COM-05 L3
CAP-02Independent PractitionerIn Development

Wild Data Acquisition & Gap Documentation

Can acquire and document data of unknown quality, including what could not be obtained

CAP-03Independent PractitionerIn Development

End-to-End Modelling, Analysis & Gate Validation

Can model, analyse and validate end to end against the Track 3–5 gates

CAP-04Independent PractitionerIn Development

Workflow-Native Stakeholder Delivery

Can deliver the finding in the form the stakeholder actually uses

CAP-05Independent PractitionerIn Development

Adversarial Analytical Defence

Can defend the analysis under adversarial review without retreating from it

M1–M4

Parallel Track · Professional Transfer & Portfolio

7 units

Turn completed analytical units into public artifacts, interview walkthroughs, and peer teaching sessions.

PRO-01ProfessionalIn Development

The 90-Second Project Write-Up

Can write a project up so a reader grasps question, method and finding in 90 seconds

PRO-02ProfessionalIn Development

Decision-Indexed Portfolio Curation

Can maintain a portfolio where every item names the decision it informed

PRO-03ProfessionalIn Development

Targeted Outreach & Answerable Asks

Can write targeted outreach with a specific, answerable ask and document respectful follow-through

PRO-04ProfessionalIn Development

Unrehearsed Technical Project Walkthrough

Can hold a technical conversation about a project you did not rehearse for

PRO-05ProfessionalIn Development

Live Narrated SQL Problem Solving

Can solve a live SQL problem while narrating your reasoning aloud

PRO-06ProfessionalIn Development

Ambiguous Case Interview to Recommendation

Can work a case interview from ambiguous prompt to defensible recommendation

PRO-07ProfessionalIn Development

Range- & Walk-Away-Grounded Offer Negotiation

Can negotiate an offer with a stated range and a walk-away number