Take-home round
The round nobody lets you practise
Every analyst interview has a case round: several questions, one shared dataset, each step building on the one before. Nowhere else practises it — the bank runs one question at a time. Start with the free one.
Your First Week as an Analyst
The unglamorous first hour of every real analyst job: count it, date-range it, find what's missing, find what's duplicated, then answer the one question your manager actually asked.
5 stepsAirAsia — Route Profitability
A unit-economics take-home: join bookings and flight costs without fanning out, normalize profit per kilometre, and name the one route to cut.
5 stepsFoodpanda — Checkout Drop-off
A funnel take-home: pivot event rows into per-platform stage counts with conditional aggregation, then find the one step in checkout that's actually broken.
5 stepsGrab — Driver Supply Gap
A marketplace take-home: join ride requests against driver shifts, build an hourly supply-vs-demand ratio, and name the one city ops should staff first.
5 stepsMaybank — Fraud Triage
A self-join take-home: build a velocity check for card-testing fraud, then separate real fraud from a look-alike false positive before deciding who to escalate.
5 stepsShopee — Cohort Retention
The take-home every analyst interview has: monthly signup cohorts, a retention curve, and one anomalous month to explain.
4 stepsNew cases added regularly — check back for more.