8 branches of analytics, product and AI interview questions

Build a three-step funnel from an events table with conversion rates.

Live SQL · Funnels · PostgreSQL · 18 min · Hard

SQL & Data Modeling · Original Uplift question

Run a segment-first root cause investigation.

Written case · Diagnosis · 20 min · Hard

Product Analytics & Metrics · Original Uplift question

Draft the actual paragraph, not the outline.

Written case · Writeup · 15 min · Hard

Analytics Case & Communication · Original Uplift question

You want to test a new driver incentive at Uber.

Written case · Interference marketplaces · 20 min · Hard

Experimentation & A/B Testing · Company-context scenario

From an events table, for each calendar date return the number of DISTINCT users active in the trailing 7 days (that date and the 6 days before it).

Live SQL · Windows · PostgreSQL · 15 min · Hard

SQL & Data Modeling · Original Uplift question

Your paid social campaigns report a 4x ROAS from the ad platform's attribution.

Written case · Attribution · 20 min · Hard

Digital & Marketing Analytics · Company-context scenario

A disease affects 1% of a population.

Calculation · Bayesian reasoning · 10 min · Hard

Statistics & Inference · Company-context scenario

Each row is one calendar day a user logged in (no duplicates).

Live SQL · Gaps islands · PostgreSQL · 18 min · Hard

SQL & Data Modeling · Original Uplift question

Assign a session id to each event per user, starting a new session whenever the gap since the user's previous event exceeds 30 minutes.

Live SQL · Sessionization · PostgreSQL · 18 min · Hard

SQL & Data Modeling · Original Uplift question

Estimate how much new storage (in terabytes or petabytes) YouTube needs per day just for newly uploaded video.

Written case · Estimation · 15 min · Hard

Product Management · Company-context scenario

At the start of the Covid-19 pandemic, Microsoft expected Skype daily active users to rise.

Written case · Diagnosis · 18 min · Hard

Product Analytics & Metrics · Reported interview question

Leadership wants to raise the subscription price by $2/month.

Written case · Experiment design for pms · 20 min · Hard

Product Management · Company-context scenario

For each signup date cohort, return the cohort size and the Day-7 retention rate: the share of users who were active exactly 7 days after signup.

Live SQL · Cohort retention · PostgreSQL · 18 min · Hard

SQL & Data Modeling · Original Uplift question

Your experiments are underpowered and you can't get more users.

Quick check · Design · 7 min · Hard

Experimentation & A/B Testing · Company-context scenario

Propose a single north-star metric for Spotify and decompose it into a metric tree.

Written case · Metrics · 20 min · Hard

Product Analytics & Metrics · Original Uplift question

Uber is considering a surge-pricing policy that changes marketplace conditions for every driver and rider in a zone.

Written case · Design · 25 min · Hard

Experimentation & A/B Testing · Reported at Uber

You are designing a research workflow that must search sources, extract evidence, draft a report, and verify citations.

Written case · Evaluation · 20 min · Hard

AI Agents & Automation · Reported interview question

Create sessions separately for each user.

Live SQL · Funnels · PostgreSQL · 25 min · Hard

SQL & Data Modeling · Original Uplift question

Let X and Y be independent Uniform(0,1) random variables.

Calculation · Probability puzzles · 15 min · Hard

Statistics & Inference · Reported at Google

Uber Eats stakeholders want to judge a new discount by comparing customers who redeem it with customers who do not.

Written case · Structure · 22 min · Hard

Analytics Case & Communication · Reported at Uber

A new Amazon search feature improves an offline relevance metric by 10% but adds two seconds to result-page load time.

Written case · Prioritization · 20 min · Hard

Product Management · Reported at Amazon

A nominal 50/50 Meta messaging experiment reports 520,000 control users and 480,000 treatment users.

Written case · Readout · 20 min · Hard

Experimentation & A/B Testing · Reported at Meta

A customer sees a paid-social ad, later searches the brand, clicks a paid-search ad, and buys.

Written case · Attribution · 22 min · Hard

Digital & Marketing Analytics · Reported interview question

Meta's mobile app suddenly shows higher bounce rate and lower session duration.

Written case · Diagnosis · 22 min · Hard

Product Analytics & Metrics · Reported at Meta