Deloitte Data Analyst Interview Questions
The questions to prepare for a Deloitte Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
DeloitteExplain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.
DeloitteCombine customer transactions and optional notes using INNER JOIN, LEFT JOIN, aggregation, and conditional spend bands.
Supernova TechnologyDeloitteAnalyze weekly service delivery performance by team using joins, a CTE, date aggregation, and KPI calculations.
Deloitte
ReputationIdentify major online experiment pitfalls and explain how they can bias results in a streaming product A/B test.
DeloitteDetermine sample size and power for a customer survey or experiment, including MDE, guardrails, and a disciplined decision rule.
DeloitteSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Walk through a past project using hypothesis testing and regression to turn data into a decision.
DeloitteBreak down a product sales decline into traffic, conversion, pricing, mix, and channel drivers to identify the root cause.
DeloitteAssess whether campaign-driven conversions turn into retained, valuable users instead of short-lived acquisition spikes.
DeloitteDesign an ETL pipeline to process 10TB of data daily from multiple sources into a data warehouse with strict data quality checks.
Deloitte