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 1 of 3
Second highest order per customer
Rank orders per customer and return each customer's second largest order.
Live SQL · Windows · PostgreSQL · 12 min · Medium
SQL & Data Modeling · Original Uplift question
Sample size for a 2% lift
Compute the per-arm sample size for a conversion test.
Calculation · Design · 8 min · Medium
Experimentation & A/B Testing · Original Uplift question
Should we launch an annual plan?
Structure an ambiguous pricing question.
Written case · Structure · 18 min · Medium
Analytics Case & Communication · Original Uplift question
Decompose weekly active teams
Break a north-star metric into multiplicative drivers.
Written case · Metrics · 18 min · Medium
Product Analytics & Metrics · Original Uplift question
What a 95% interval actually says
Distinguish the frequentist claim from the common misreading.
Quick check · Intervals · 6 min · Medium
Statistics & Inference · Original Uplift question
Reading a flattening retention curve
Interpret a curve that flattens above zero.
Quick check · Retention · Amplitude · 6 min · Medium
Product Analytics & Metrics · Original Uplift question
Success metrics for an in-app AI assistant
Define the metrics that decide whether an AI assistant ships.
Written case · Metrics · 15 min · Medium
Product Management · Original Uplift question
Metrics to judge a support agent rollout
Choose the scoreboard for an AI support agent.
Written case · Product metrics · 15 min · Medium
AI Agents & Automation · Original Uplift question
They want to ship despite a null result
Your A/B test came back flat (no significant effect).
Written case · Stakeholder management · 15 min · Medium
Analytics Case & Communication · Company-context scenario
Explain a p-value to a non-technical exec
A VP asks 'what does p = 0.03 actually mean?' Explain it correctly in plain language, and state clearly what it does NOT mean.
Written case · Communicating stats · 8 min · Medium
Statistics & Inference · Company-context scenario
Which attribution model over-credits early touchpoints
A customer sees a Facebook ad (first touch), later clicks a Google search ad, then converts after an email.
Quick check · Attribution · 6 min · Medium
Digital & Marketing Analytics · Company-context scenario
Running total of daily revenue
From the orders table, return each order_date with that day's revenue and a cumulative running total of revenue through that date, ordered by date.
Live SQL · Windows · PostgreSQL · 10 min · Medium
SQL & Data Modeling · Original Uplift question
Offline vs online evaluation
You're shipping an AI support agent.
Quick check · Evaluation · 6 min · Medium
AI Agents & Automation · Company-context scenario
Reddit traffic is down 5%
Reddit's traffic went down 5%.
Written case · Diagnosis · 18 min · Medium
Product Analytics & Metrics · Reported interview question
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
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
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
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
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
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