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
157 questions · page 6 of 7
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
Join each invoice to the plan in effect
ProEach plan_history row starts a new plan period for an account and remains effective until the next change.
Live SQL · Modeling · PostgreSQL · 22 min · Hard
SQL & Data Modeling · Original Uplift question
Ads or People You May Know?
ProA Facebook feed slot can show either an additional ad or a People You May Know recommendation.
Written case · Prioritization · 18 min · Medium
Product Management · Reported at Meta
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
Does marketplace audio chat improve outcomes?
ProA marketplace adds optional audio chat between buyers and sellers.
Written case · Metrics · 18 min · Medium
Product Analytics & Metrics · Reported at Meta
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
Expected cost of an agent routing policy
ProAn agent handles 10,000 tasks per month.
Calculation · Product metrics · 12 min · Medium
AI Agents & Automation · Reported interview question
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
Rolling seven-day cancellation rate
ProFor every calendar date from the first through last order date, compute the trailing seven-calendar-day cancellation rate: canceled orders divided by all orders in that date and the prior six dates.
Live SQL · Windows · PostgreSQL · 22 min · Hard
SQL & Data Modeling · Original Uplift question
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
Choose between a prop and an eVar
Stakeholders want to know which internal search term a shopper used before an order placed several pages later.
Quick check · Adobe analytics · Adobe Analytics · 5 min · Easy
Digital & Marketing Analytics · Original Uplift question
Model a share action in your event taxonomy
Sharing can go to five destinations and the team is deciding how to instrument it.
Quick check · Tooling · Amplitude / Mixpanel · 5 min · Easy
Product Analytics & Metrics · Original Uplift question
Respond to a request to raise velocity 20%
A director asks the team to raise story-point velocity by 20% next quarter.
Quick check · Tooling · Jira · 5 min · Easy
Product Management · Original Uplift question
Fix three different active-customer numbers
ProSales, finance, and product each report a different active-customer count from the same warehouse.
Quick check · Tooling · Looker / Tableau / Power BI · 6 min · Medium
Product Management · Original Uplift question
Read two funnel numbers for the same funnel
ProCheckout conversion reads 22% with a one-day window and 34% with a seven-day window.
Quick check · Tooling · Amplitude / Mixpanel · 6 min · Medium
Product Analytics & Metrics · Original Uplift 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
Pick the right segment container
ProYou need people who viewed a product page and also ordered at some point in the window, not necessarily in the same visit.
Quick check · Adobe analytics · Adobe Analytics · 7 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
Rebuild an executive dashboard nobody reads
The weekly executive dashboard has 24 charts and no readers.
Written case · Tooling · Looker / Tableau / Power BI · 15 min · Medium
Product Management · Original Uplift question