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 2 of 4
Estimate daily rideshare trips in Chicago
Estimate the number of rideshare trips (Uber + Lyft) taken in the city of Chicago on a typical weekday.
Written case · Estimation · 15 min · Medium
Product Management · Company-context scenario
What the Central Limit Theorem lets you do
Why does the Central Limit Theorem matter for A/B testing, where the underlying metric (e.g.
Quick check · Foundations · 6 min · Easy
Statistics & Inference · Company-context scenario
Big week-1 lift that fades to zero
A redesigned button shows +8% engagement in week 1, but by week 4 treatment and control are indistinguishable.
Quick check · Readout · 5 min · Easy
Experimentation & A/B Testing · Company-context scenario
ROAS looks great, is the campaign profitable
A campaign spent $10,000 and drove $40,000 in revenue (ROAS = 4).
Calculation · Campaigns · 6 min · Medium
Digital & Marketing Analytics · Company-context scenario
Success metrics for Facebook Marketplace
You just launched a feature in Facebook Marketplace.
Written case · Metrics · 15 min · Medium
Product Management · Company-context scenario
Month-over-month revenue growth
Return each month, its revenue, and the month-over-month growth as a percentage rounded to one decimal.
Live SQL · Windows · PostgreSQL · 10 min · Medium
SQL & Data Modeling · Original Uplift question
'Can you pull engagement for me?'
A PM Slacks you: 'Can you pull engagement numbers for me?' with no other context.
Written case · Structure · 10 min · Easy
Analytics Case & Communication · Original Uplift question
Measure the success of YouTube Shorts
How would you measure the success of YouTube Shorts?
Written case · Measuring impact · 15 min · Medium
Product Analytics & Metrics · Reported interview question
Sample size for a 1-point conversion lift
Baseline conversion is 10%.
Calculation · Design · 8 min · Medium
Experimentation & A/B Testing · Original Uplift question
Type I vs Type II error trade-off
A medical screening test is being tuned.
Quick check · Intervals · 5 min · Easy
Statistics & Inference · Company-context scenario
Measure the success of Snap Map
How would you measure the success of Snap Map (the map showing friends' locations and activity)?
Written case · Measuring impact · 15 min · Medium
Product Analytics & Metrics · Reported interview question
Is the LTV:CAC healthy
A SaaS product has customer lifetime value (LTV) of $900 and customer acquisition cost (CAC) of $300.
Calculation · Unit economics · 5 min · Easy
Digital & Marketing Analytics · Company-context scenario
Spotting the vanity metric
A growth team celebrates that 'total registered users crossed 10 million.' Why might a PM push back on using this as the headline success metric?
Quick check · Metrics · 5 min · Easy
Product Management · Company-context scenario
Top 3 products per category by revenue
Return the top 3 products by total revenue within each category.
Live SQL · Windows · PostgreSQL · 12 min · Medium
SQL & Data Modeling · Original Uplift question
The returning-planes problem
In WWII, analysts studied bullet holes on planes that RETURNED from missions and proposed armoring the most-hit areas.
Quick check · Bias · 5 min · Easy
Statistics & Inference · Company-context scenario
What goes in the first line of a readout
You're writing a results email to executives about an experiment.
Quick check · Writeup · 5 min · Easy
Analytics Case & Communication · Company-context scenario
Which success metric reflects the user's experience
An agent solves 70% of tasks on the first attempt and 90% within three attempts.
Quick check · Product metrics · 6 min · Easy
AI Agents & Automation · Company-context scenario
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
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
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
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
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