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 1 of 7
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
Signup to purchase funnel
ProBuild a three-step funnel from an events table with conversion rates.
Live SQL · Funnels · PostgreSQL · 18 min · Hard
SQL & Data Modeling · Original Uplift question
Ordering an executive readout
Choose the right first line for a results email.
Quick check · Writeup · 5 min · Easy
Analytics Case & Communication · 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
Why peeking inflates false positives
Explain the statistical cost of checking results daily.
Quick check · Readout · 5 min · Easy
Experimentation & A/B Testing · Original Uplift question
Effect of halving the MDE
Reason about the sample size / MDE relationship.
Calculation · Intervals · 5 min · Easy
Statistics & Inference · Original Uplift question
Signups dropped 18% overnight
ProRun a segment-first root cause investigation.
Written case · Diagnosis · 20 min · Hard
Product Analytics & Metrics · Original Uplift question
A confounded coupon coefficient
ProExplain a positive coefficient that cannot be causal.
Written case · Regression · Python · 15 min · Medium
Statistics & Inference · Original Uplift question
Design metrics for a checkout redesign
ProChoose primary, secondary and guardrail metrics and defend them.
Written case · Guardrails · 20 min · Medium
Experimentation & A/B Testing · Original Uplift question
Write the flat-result readout
ProDraft the actual paragraph, not the outline.
Written case · Writeup · 15 min · Hard
Analytics Case & Communication · Original Uplift question
Choosing the fact table grain
Pick the right grain for an order-line fact table.
Quick check · Modeling · dbt · 6 min · Easy
SQL & Data Modeling · Original Uplift question
Ranking four features with RICE
Order a backlog using reach, impact, confidence and effort.
Quick check · Prioritization · 7 min · Easy
Product Management · 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
Diagnose stalled team activation
ProWalk a project-management tool activation cliff end to end.
Written case · Product sense · 20 min · Medium
Product Management · Original Uplift question
Net revenue retention from monthly MRR
Compute NRR from expansion, contraction and churn.
Calculation · Metrics · 6 min · Easy
Product Management · Original Uplift question
Why last-click flatters brand search
Identify the bias in last-click attribution.
Quick check · Attribution · 5 min · Easy
Digital & Marketing Analytics · Original Uplift question
Blended ROAS from spend and revenue
Compute blended return on ad spend.
Calculation · Campaigns · 5 min · Easy
Digital & Marketing Analytics · Original Uplift question
Cost per acquisition by channel
ProAggregate campaign spend into per-channel CPA and rank it.
Live SQL · Campaigns · PostgreSQL · 15 min · Medium
Digital & Marketing Analytics · Original Uplift question
Incrementality test for brand search spend
ProProve whether brand search ads add sales or harvest them.
Written case · Site · 20 min · Medium
Digital & Marketing Analytics · Original Uplift question
Catching agent regressions before release
Prevent shipped updates from breaking tasks that used to work.
Quick check · Evaluation · 6 min · Easy
AI Agents & Automation · Original Uplift question