Catalog
8 branches of analytics, product and AI interview questions
Explore eight skill tracks, called branches, filterable by subtopic, company, tool and difficulty. SQL questions run against sample tables, choice and numeric answers are checked instantly, and written cases are scored against evaluation criteria.
Filters
157 questions · page 4 of 7
Metrics after a user follows a new page
What metrics would you track after a user follows a new page on LinkedIn, and why?
Written case · Metrics for pms · 12 min · Medium
Product Analytics & Metrics · Reported interview question
Bias-variance trade-off
ProA model has near-perfect training accuracy but poor test accuracy.
Quick check · Modeling intuition · 6 min · Medium
Statistics & Inference · Company-context scenario
Wins in every segment, loses overall
ProYour treatment beats control in BOTH the mobile segment and the desktop segment, yet loses when you pool all users together.
Quick check · Readout · 6 min · Medium
Experimentation & A/B Testing · Company-context scenario
Is this campaign's traffic real
ProA display campaign suddenly shows a huge spike in clicks and traffic but flat conversions.
Written case · Campaigns · 15 min · Medium
Digital & Marketing Analytics · Company-context scenario
Estimate daily storage for YouTube uploads
ProEstimate how much new storage (in terabytes or petabytes) YouTube needs per day just for newly uploaded video.
Written case · Estimation · 15 min · Hard
Product Management · Company-context scenario
A 50/50 split that came out 52/48
You designed a 50/50 experiment.
Quick check · Data quality · 6 min · Medium
Experimentation & A/B Testing · Company-context scenario
Keep only the latest record per listing
The snapshots table has multiple rows per listing.
Live SQL · Deduplication · PostgreSQL · 10 min · Medium
SQL & Data Modeling · Original Uplift question
Skype DAU fell 4% when it should have risen
ProAt the start of the Covid-19 pandemic, Microsoft expected Skype daily active users to rise.
Written case · Diagnosis · 18 min · Hard
Product Analytics & Metrics · Reported interview question
Two children, at least one boy
ProA family has two children.
Calculation · Probability puzzles · 6 min · Medium
Statistics & Inference · Company-context scenario
How would you test a price increase?
ProLeadership wants to raise the subscription price by $2/month.
Written case · Experiment design for pms · 20 min · Hard
Product Management · Company-context scenario
Metrics for the success of an Instagram ad
What metrics would you use to measure the success of an Instagram ad?
Written case · Measuring impact · 12 min · Medium
Product Analytics & Metrics · Reported interview question
Day-7 retention by signup cohort
ProFor each signup date cohort, return the cohort size and the Day-7 retention rate: the share of users who were active exactly 7 days after signup.
Live SQL · Cohort retention · PostgreSQL · 18 min · Hard
SQL & Data Modeling · Original Uplift question
When the mean misleads
You report 'average revenue per user = $50' but leadership is confused because almost no one spends near $50.
Quick check · Descriptive stats · 5 min · Easy
Statistics & Inference · Company-context scenario
Choose the OEC for a homepage change
ProYou're testing a new homepage row on Netflix.
Written case · Guardrails · 15 min · Medium
Experimentation & A/B Testing · Company-context scenario
Median order value per segment
Return the median order amount for each customer segment.
Live SQL · Aggregation · PostgreSQL · 8 min · Medium
SQL & Data Modeling · Original Uplift question
A retention curve that smiles
Your retention curve declines for the first few months, then ticks upward again later (a 'smile' shape).
Quick check · Retention · 6 min · Medium
Product Analytics & Metrics · Original Uplift question
What CUPED buys you
ProYour experiments are underpowered and you can't get more users.
Quick check · Design · 7 min · Hard
Experimentation & A/B Testing · Company-context scenario
Which test for which data
ProYou're comparing two groups.
Quick check · Hypothesis testing · 6 min · Medium
Statistics & Inference · Company-context scenario
A PM wants to ship the moment p < 0.05
A PM watches the experiment dashboard daily and wants to ship as soon as it crosses p < 0.05.
Written case · Readout · 12 min · Medium
Experimentation & A/B Testing · Company-context scenario
Choose a north-star metric for Spotify
ProPropose a single north-star metric for Spotify and decompose it into a metric tree.
Written case · Metrics · 20 min · Hard
Product Analytics & Metrics · Original Uplift question
Users who viewed then purchased the same item
Count the distinct users who VIEWED a product and later PURCHASED that same product (purchase time strictly after the view).
Live SQL · Self joins · PostgreSQL · 12 min · Medium
SQL & Data Modeling · Original Uplift question
Pivot monthly revenue into columns
Return one row per category with three columns of revenue: Jan, Feb, and Mar 2026.
Live SQL · Pivoting · PostgreSQL · 10 min · Medium
SQL & Data Modeling · Original Uplift question
Which change needs a Type 2 dimension
You maintain a customer dimension.
Quick check · Modeling · 6 min · Medium
SQL & Data Modeling · Original Uplift question
Measure an Instagram subway campaign
ProInstagram plans a display campaign in New York City subway stations.
Written case · Attribution · 18 min · Medium
Digital & Marketing Analytics · Reported at Meta