Analytics — Interview questions
A/B Testing
p-value, error types, power, MDE, confidence intervals, and choosing the right criterion.
19 questions
BI and Visualization
Chart choice, misleading encodings, dashboard design and adoption, and aggregation traps in BI tools.
9 questions
Causal Inference
Measuring causation without an A/B — DiD, synthetic control, matching, IV, RDD, and the evidence hierarchy.
10 questions
Data Engineering
Storage architectures, ETL versus ELT, data layering, and change data capture.
16 questions
Experiment Design
Beyond a vanilla A/B — SRM, CUPED, sequential and switchback designs, clusters, interference, and ramps.
16 questions
Funnel Analysis
Funnel modelling, step versus end-to-end conversion, windows, multi-entry, and drop-off diagnosis.
8 questions
Hypothesis Testing
Hypotheses, power, test choice, multiple comparisons, and Bayesian versus frequentist readouts.
12 questions
Marketing Analytics
Attribution models and windows, ad auctions, and incremental-value promotion.
16 questions
Metric Design
North-star metrics, metric trees, guardrails, counter-metrics, proxies, and Goodhart's law.
11 questions
Metric Root Cause
The "why did X drop 20%" case family — artifact versus real, slicing order, mix shift, and external shocks.
15 questions
Pandas
DataFrame grouping, merging, filtering, and conditional aggregation tasks.
20 questions
Probability Puzzles
Live probability tasks — Bayes, dice, binomial, Poisson, and coupon-collector reasoning.
12 questions
Product Analytics
Metric design and selection, unit economics, prioritization, and structured investigation.
16 questions
Python Coding
Algorithmic and data-handling tasks an analyst solves in plain Python.
18 questions
Retention and Cohorts
Retention definitions and curves, cohorts, churn, stickiness, activation, and survival analysis.
13 questions
SQL Analytics Patterns
Recurring analyst SQL shapes — sessionization, gaps-and-islands, retention, cohorts, and funnels.
11 questions
SQL Performance
EXPLAIN plans, indexes, sargable predicates, fan-out cost, columnar storage, and join strategies.
10 questions
SQL Practice
Hands-on SQL for analysts — aggregation, grouping, and the HAVING filter.
15 questions
SQL Window Functions
Ranking, partitioned frames, LAG/LEAD, NTILE, running totals, and moving averages in SQL.
12 questions
Stakeholder Communication
Communicating results — null results, pushback, prioritization, experiment ethics, and data privacy.
7 questions
Statistics
Central tendency, distribution shape, the central limit theorem, and Simpson's paradox.
18 questions
Unit Economics
LTV, CAC, payback, ARPU/ARPPU/AOV, contribution margin, and net revenue retention.
10 questions
