Top 40
Company roadmap
Updated weekly · Last refresh Oct 17

Analytica Interview Questions

The questions to prepare for Analytica interviews, across all roles. Questions from real interview reports rank first. Updated daily.

40questions
~5htotal time
Track your progressSign up free to work through all 40 questions and resume where you left off.
Start practicing free →
1
A/B Testing & ExperimentationStart here. 5 questions · ~40 min
Common Pitfalls in Experiment ResultsHard

Identify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.

PeekingNovelty EffectSample Ratio MismatchAnalytica
Network Interference in Collaboration TestMedium

Explain when network interference threatens an A/B test, how it biases estimates, and how to redesign the experiment safely.

Network InterferenceExperimentationA/B TestingAnalytica
More A/B Testing & Experimentation questions with a free account
2
Product Sense4 questions · ~32 min
Define Feature Success MetricsMedium

Framework for choosing a feature's primary success metric and guardrails before launch.

MetricsFeature PrioritizationProduct VisionAnalytica
More Product Sense questions with a free account
3
Pipelines3 questions · ~24 min
CI CD for Data PipelinesMedium

Set up CI CD and automated testing for data pipelines so changes ship faster with fewer production issues.

ToolsOrchestrationQualityAnalytica
More Pipelines questions with a free account
4
SQL & Data Manipulation6 questions + 3 drills · ~78 min
Sales Reporting Star Schema DesignMedium

Design a sales reporting data model with correct keys and relationships for fast revenue and margin reporting.

JoinsAggregationsData ModelingAnalytica
Window Functions for User BehaviorMedium

Evaluates your use of SQL window functions to compute time-based user behavior features and metrics.

Window FunctionsLag/LeadRunning TotalsAnalytica
SQL Window Functions for TrendsMedium
Practice
Practice drill

Rank Delta Air Lines routes by monthly revenue using joins, aggregation, and a window function.

Window FunctionsLag/LeadJoinsDelta Air Lines
Using SQL Window FunctionsMedium
Practice
Practice drill

Use aggregation and a window function to rank active players by completed purchase spend, including players with no qualifying purchases.

Window FunctionsLag/LeadJoinsScopely
SQL Rolling 4-Week Regional PerformanceHard
Practice
Practice drill

Join Medzed orders and staffing data to calculate weekly regional performance and trailing four-week averages.

Window FunctionsLag/LeadJoinsMedzed
More SQL & Data Manipulation questions with a free account
5
Behavioral & Leadership20 questions · ~160 min
More Behavioral & Leadership questions with a free account
6
More topics2 questions · ~16 min
First Checks for Metric DropsEasy

Outline the first checks to diagnose a sudden drop in a core product metric, starting with data quality, scope, and decomposition.

Lagging IndicatorsLeading IndicatorsDiagnosisAnalytica
Apply Statistical SignificanceMedium

Evaluates your understanding of statistical significance and how you use it to support conclusions.

Data AnalysisStatistical SignificanceAnalytica

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 40 questions plus 3 hands-on drills to finish this plan.