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 (2)
Branches
Access
Free onlyQuestion type
Type to find a company, then pick it from the list below.
Tool
52 questions · page 2 of 3
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
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
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
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 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
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
Explain channel counts that do not add up
Channel rows for unique visitors sum to more than the report total for the same period.
Quick check · Adobe analytics · Adobe Analytics · 6 min · Medium
Digital & Marketing Analytics · Original Uplift question
Write the instrumentation plan for a new feature
A saved-searches feature ships in three weeks and has no tracking yet.
Written case · Tooling · Amplitude / Mixpanel · 15 min · Medium
Product Analytics & Metrics · Original Uplift question