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
84 questions · page 3 of 4
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 the health of a Facebook Group
You own analytics for Facebook Groups.
Written case · Metrics · 18 min · Medium
Product Analytics & Metrics · Reported at Meta
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
Test a new shoppable-ad ranking model
Meta has a new ranking model for shoppable-feed ads.
Written case · Design · 20 min · Medium
Experimentation & A/B Testing · Reported at Meta
Positive predictive value of a screening test
A condition affects 1% of a population.
Calculation · Probability puzzles · 10 min · Medium
Statistics & Inference · Reported interview question
Choose the right approval boundary
A finance agent can read invoices, prepare payments, and submit them to the bank.
Quick check · Product metrics · 7 min · Easy
AI Agents & Automation · Reported interview question
Choose Dashers for two new cities
DoorDash is launching in dense New York City and lower-density Charlotte.
Written case · Structure · 18 min · Medium
Analytics Case & Communication · Reported at DoorDash
Spot a novelty effect in a VR interface test
A new VR interface lifts daily use by 18% in days 1–3, 7% in days 4–7, and 0% in days 8–21.
Quick check · Readout · 7 min · Easy
Experimentation & A/B Testing · Reported at Meta
Expected cost of a rider coupon
Lyft gives a $5 coupon to 20,000 riders.
Calculation · Campaigns · 8 min · Easy
Digital & Marketing Analytics · Reported at Lyft
Measure Facebook Save
What metrics would you use to measure the success of Facebook's Save feature?
Written case · Metrics · 15 min · Medium
Product Management · Reported at Meta
False-positive risk across four variants
You compare four independent treatment variants with one control.
Calculation · Design · 10 min · Medium
Experimentation & A/B Testing · Reported interview question
Respond when a stakeholder wants a predetermined answer
A senior stakeholder says, 'We already know the campaign worked.
Written case · Writeup · 10 min · Easy
Analytics Case & Communication · Reported interview question
Choose the honest activation metric
An onboarding change raises the percentage of signups completing setup from 40% to 60%, but the number of users completing the product's core action within seven days is unchanged and D28 retention is unchanged.
Quick check · Retention · 6 min · Easy
Product Analytics & Metrics · Reported interview question
Control four confirmatory tests
A product experiment has four equally important confirmatory metrics.
Quick check · Intervals · 7 min · Easy
Statistics & Inference · Reported interview question