Top 50
Prep plan
Updated weekly · Last refresh Oct 17

Deloitte Data Analyst Interview Questions

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

50questions
~8htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 18 questions · ~173 min
Select Date in SQLEasy
Practice

Retrieve activity records for one calendar date while returning the related customer details.

Date FunctionsJoinsdata extractionDeloitte
Explain SQL Join TypesEasy

Explain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.

JoinsData WranglingGroup ByDeloitte
More SQL & Data Manipulation questions with a free account
2
Metrics5 questions · ~48 min
Real-World Data Analysis ProposalHard

Analyze a real-world dataset, identify meaningful metric trends, and turn findings into prioritized business recommendations.

analyticsKPIactionable insightsDeloitte
Diagnose Product Sales DeclineMedium
Recently asked

Break down a product sales decline into traffic, conversion, pricing, mix, and channel drivers to identify the root cause.

Funnel AnalysisKPIsDiagnosisDeloitte
More Metrics questions with a free account

Sign up to see every question

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

Get my prep plan
3
Statistics & Probability4 questions · ~38 min
Statistical Project WalkthroughMedium
Recently asked

Walk through a past project using hypothesis testing and regression to turn data into a decision.

RegressionHypothesis TestingStatistical SignificanceDeloitte
More Statistics & Probability questions with a free account
4
A/B Testing & Experimentation4 questions · ~38 min
Power Analysis for Survey ExperimentHard
Recently asked

Determine sample size and power for a customer survey or experiment, including MDE, guardrails, and a disciplined decision rule.

MDEPower AnalysisSample SizeDeloitte
Primary vs Guardrail MetricsEasy
Recently asked

Explain how a primary metric differs from a guardrail metric and how both are used in A/B test decisions.

ExperimentationGuardrail MetricsA/B TestingDeloitte
More A/B Testing & Experimentation questions with a free account
5
Behavioral & Leadership17 questions · ~163 min
More Behavioral & Leadership questions with a free account
6
More topics2 questions · ~19 min
Design an ETL Pipeline for Large DatasetsMedium
Recently asked

Design an ETL pipeline to process 10TB of data daily from multiple sources into a data warehouse with strict data quality checks.

InfrastructureETLData ModelingDeloitte
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.