Top 33
Prep plan
Updated weekly · Last refresh Oct 17

XYZ Data Analyst Interview Questions

The questions to prepare for a XYZ Data Analyst interview. Questions from real interview reports rank first. Updated daily.

33questions
~5htotal time
Track your progressSign up free to work through all 33 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions · ~83 min
Top Products by Sales RevenueEasy
Practice

Find the top 10 products by total sales revenue using joins, aggregation, and a CTE.

RankingGroup ByAggregationsXYZ
7-Day Rolling Active UsersMedium
Practice

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsXYZ
Understanding Common Table Expressions (CTEs)Medium

Explain what CTEs are and their advantages in SQL queries.

CTEsXYZ
More SQL & Data Manipulation questions with a free account
2
Metrics4 questions · ~37 min
Diagnose Conversion Drop Post LaunchMedium

Diagnose why conversion fell from 4.8% to 3.1% after a launch by breaking the metric across funnel steps, cohorts, and segments.

Funnel AnalysisConversion RateDiagnosisXYZ
Diagnose Client Engagement DropMedium

Diagnose a sharp decline in client engagement and break it down into cohorts, funnel steps, and likely business drivers.

Leading IndicatorsDiagnosisEngagement MetricsXYZ
More Metrics questions with a free account
3
Behavioral & Leadership17 questions · ~157 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~28 min
Discovery UI Metrics and GuardrailsMedium

Define primary and guardrail metrics for a discovery UI test, with power, MDE, and a pre-registered analysis plan.

ExperimentationGuardrail MetricsA/B TestingXYZ
Correlation vs Causation in AnalysisEasy

Explain why two metrics moving together does not prove that one causes the other, and how to assess causality more carefully.

RegressionCorrelationCausal InferenceXYZ
Outlier Detection and ImpactMedium

Tests your ability to detect anomalies and quantify how they affect conclusions or models.

RegressionCorrelationVarianceXYZ

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 33 questions to finish this plan.