Data Analyst Interview Practice: Take-Home Tasks, SQL-Style Questions, Metric Definitions, Quick A/B Reads & Sanity Checks
Practise the tasks analyst interviews really ask for: joins and group-bys in a sheet, defining metrics precisely, median vs mean traps, quick experiment reads, cohort tables and spotting numbers that cannot be right, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you practise interview-style data analyst tasks in a spreadsheet, with every cell checked. You answer warm-up questions on percentage points versus percent and share of growth, then solve SQL-style questions: a left join with XLOOKUP and IFNA, orders per customer and revenue per region. You define active users and conversion in different ways, compare mean, median and the 90th percentile of skewed basket values, and read an A/B test with lift in points and a fictional minimum-detectable-change table. You build a cohort retention grid with COUNTIFS and EDATE, hunt planted errors in a messy export and finish with a timed take-home case.
Lessons
- Warm-Up: Clarifying the Question, Points vs Percent and Share-of-Total Traps Pro
- SQL-Style Questions: Joins with XLOOKUP, Unmatched Rows and GROUP BY with SUMIFS Pro
- Metric Definitions: Active Users, Conversion and Why the Denominator Decides Pro
- Distribution Questions: Mean vs Median vs p90 and the Effect of One Outlier Pro
- Quick A/B Read: Conversion per Variant, Lift in Points and "Is It Worth Shipping?" Pro
- Cohort Retention: Months Since Signup, the Cohort Grid and Pooled vs Average Rates Pro
- Sanity Checks: Duplicated Rows, Impossible Rates and Totals That Don't Add Up Pro
- Capstone: A Timed Take-Home – Net Revenue, Refund Rate, Revenue by Channel and One Chart Pro