Join grain and fan-out
The single most common source of wrong numbers in analytics: joining a one-row-per-order table to a many-rows-per-order table and then summing a column that has been duplicated.
We mark it against a checklist you can read first
What counts as knowing this
Join three tables at the correct grain and prove the totals were not inflated by fan-out
A check for this one skill
Up to 2 questions on this skill alone, marked against the bar beside this. It stops as soon as the answer is clear. No account, and your answers are not kept.
You'll need these first
Helpful, but not required
What it unlocks
Start on SQL & Data Analysis
Every skill above, ordered by what depends on what, with the projects above that as the evidence you actually did it. We work out where you already are first, so the path skips what you can do.
Start this path