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 (1)
Branches
Access
Free onlyQuestion type
Type to find a company, then pick it from the list below.
Tool
96 questions · page 3 of 4
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
Two children, at least one boy
ProA family has two children.
Calculation · Probability puzzles · 6 min · Medium
Statistics & Inference · 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
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
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
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
Measure the health of a Facebook Group
You own analytics for Facebook Groups.
Written case · Metrics · 18 min · Medium
Product Analytics & Metrics · Reported at Meta
Improve Google Maps for daily commuters
ProHow would you improve Google Maps for daily commuters?
Written case · Product sense · 20 min · Medium
Product Management · Reported at Google
Explain a p-value without misleading
An engineer asks: 'The experiment's p-value is 0.03.
Written case · Writeup · 12 min · Medium
Analytics Case & Communication · Reported at Amazon
Longest monthly activity streak
For each user, return the length of their longest streak of consecutive calendar months with at least one activity.
Live SQL · Windows · PostgreSQL · 18 min · Medium
SQL & Data Modeling · Original Uplift question
Design an AI travel-itinerary assistant
As the product manager at Booking.com, design a generative-AI assistant that creates personalized travel itineraries using destination, activity, and accommodation preferences.
Written case · Product metrics · 20 min · Medium
AI Agents & Automation · Reported at Booking.com
Is 550 heads in 1,000 flips suspicious?
A coin is flipped 1,000 times and lands heads 550 times.
Calculation · Intervals · 10 min · Medium
Statistics & Inference · Reported at D. E. Shaw
Measure an email campaign's success
Airbnb sends a destination-inspiration email to eligible travelers.
Written case · Campaigns · 16 min · Medium
Digital & Marketing Analytics · Reported at Airbnb
Evaluate engagement of new users
A consumer app acquired 100,000 new users last month.
Written case · Retention · 16 min · Medium
Product Analytics & Metrics · Reported interview question
Inference with severely skewed revenue
Customer revenue is zero for many users and has a very long right tail.
Written case · Regression · 15 min · Medium
Statistics & Inference · Reported interview question
Week-one retention by signup cohort
Group users by Monday-starting signup week.
Live SQL · Funnels · PostgreSQL · 20 min · Medium
SQL & Data Modeling · Original Uplift question
Write the decision from a failed experiment
ProA six-week onboarding experiment estimated +0.3 percentage points on activation with a 95% confidence interval of -0.4 to +1.0 points.
Written case · Writeup · 15 min · Medium
Analytics Case & Communication · Reported interview question