// the analytics roadmap

One sheet. Every topic. In order.

Eight steps, sequenced by what actually builds on what. Work through them top to bottom, or jump to wherever you’re stuck.

⏱ 12 to 16 weeks · full path
📚 53 · topics
✅ 0/53 · completed
Sign in to track your progress and build a streak.Get started free →
02

Intermediate SQL — Window functions & case logic

Where most candidates fall off in real interviews. This is where you stop being a beginner.

medium2–3 weeks
ROW_NUMBER, RANK, DENSE_RANKread →LAG, LEAD, FIRST_VALUEread →Running totals & moving averagesread →Frame clauses: ROWS vs RANGEread →CASE as a conditional aggregateread →Pivot & unpivot patternsread →
NTILE and percentiles in SQLsoon
Gaps and islands, solvedsoon
Deduplicating with ROW_NUMBERsoon
6 / 9 articles availableStart reading →
03

Query Optimisation

The interview question they ask after you write the query. EXPLAIN plans, indexes, the cost of joins.

medium1–2 weeks
Reading an EXPLAIN planread →When indexes help vs hurtread →Predicate pushdown intuitionread →Nested loop vs hash joinread →Partitioning strategiesread →Materialised views in the wildread →
Covering indexes explainedsoon
Why your CTE might be slowsoon
Reading a query plan under loadsoon
6 / 9 articles availableStart reading →
04

Product Analytics & Metrics

Defining DAU, retention, engagement, and the hundred ways teams get them wrong.

medium2 weeks
The North Star metric, honestlyread →DAU / MAU / stickinessread →Retention curves & cohort tablesread →Funnel decompositionread →Event tracking schemasread →Quick-commerce specific metricsread →
Sessionization in SQLsoon
Building a metrics layersoon
Attribution models, plainlysoon
6 / 9 articles availableStart reading →
05

Experimentation & A/B Testing

Sample sizes, p-values, MDE, and the political reality of shipping an experiment.

hard2 weeks
Hypothesis design without the math jargonread →Sample size & MDE calculatorsread →P-values: what they actually meanread →Novelty effects & primacy effectsread →Reading an experiment readoutread →When NOT to A/B testread →
Sequential testing and peekingsoon
CUPED and variance reductionsoon
Guardrail metrics that mattersoon
6 / 9 articles availableStart reading →
06

Business & Product Thinking

Unit economics, LTV/CAC, marketplace dynamics, and the case-interview muscle.

medium2 weeks
Unit economics from first principlesread →LTV, CAC, payback periodread →Marketplace 2-sided dynamicsread →Subscription & churn mathread →Pricing & price elasticityread →Dark-store / quick-commerce opsread →
Contribution margin for analystssoon
Cohort economics over timesoon
Forecasting without fancy modelssoon
6 / 9 articles availableStart reading →
07

Dashboards & Storytelling

Where the math ends and the influence begins. The skill that makes you promotable.

easy1 week
Signal vs. ink: the Tufte ruleread →Dashboard hierarchy of attentionread →Choosing the right chart typeread →The 1-line summary ruleread →Writing executive readoutsread →When to push back on a metric askread →
The metric treesoon
Annotating charts like a prosoon
6 / 8 articles availableStart reading →
08

Interview Prep — the final mile

Resume, SQL screen, product round, case round, behavioural. End-to-end.

hard2 weeks
Resume that gets shortlistedread →50 SQL screening patternsread →Product sense frameworkread →Business case structureread →Behavioural: STAR done wellread →Salary negotiation playbookread →
The take-home data challengesoon
SQL interview speed drillssoon
Case interview: metrics deep-divesoon
6 / 9 articles availableStart reading →