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
96 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
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
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
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
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
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
Demo-day agent, churning users
ProDiagnose why a high-scoring agent loses real users.
Written case · Evaluation · Python · 20 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
Facebook third-party login down 2% WoW
ProFacebook third-party login (using your FB account to sign into other apps) is declining 2% week over week.
Written case · Diagnosis · 18 min · Medium
Product Analytics & Metrics · Reported interview question
Risks of using an LLM to grade your agent
ProYour team uses a strong LLM to automatically grade your agent's outputs ('LLM-as-judge') at scale.
Written case · Evaluation · 15 min · Medium
AI Agents & Automation · Company-context scenario
How would you improve Google Maps?
ProHow would you improve Google Maps?
Written case · Product sense · 20 min · Medium
Product Management · Reported interview question