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 1 of 4
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
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
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
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
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
Cost per resolved ticket for an AI agent
Compute unit economics for an AI support agent.
Calculation · Product metrics · 5 min · Easy
AI Agents & Automation · 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