Dataford
Top 16
Prep plan
Updated weekly · Last refresh Aug 30

McKinsey & Data Analyst Interview Questions

The questions to prepare for a McKinsey & Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

16questions
~2htotal time
Track your progressSign up free to work through all 16 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 3 drills · ~56 min
Handling Missing and Skewed DataMedium

Explain how to handle NULLs, skewed values, and outliers when preparing an analysis dataset using SQL.

Data Qualitynull handlingData WranglingMcKinsey &
Optimizing Large Transaction Table JoinsHard

Explain how to tune a slow PostgreSQL query that joins several large transaction tables using indexes, join strategy, and partitioning.

JoinsperformancesqlMcKinsey &
Customer Transaction Running TotalsEasy
Practice
Recently asked
Practice drill

Calculate each customer's cumulative transaction amount over time using a CTE and window function.

Window FunctionsDate FunctionsRunning TotalsBanco SantanderAnzBank Of Tokyo-Mitsubishi UFJ
Top Customers SQL QueryEasy
Practice
Practice drill

Aggregate customer sales volume and return Pyramid Consulting's top 10 customers in descending order.

RankingGroup ByAggregationsPyramid ConsultingBNYCambia Health Solutions
Top Departments by Average SalaryMedium
Practice
Recently asked
Practice drill

Use JOIN, GROUP BY, and HAVING to find the top three departments by average salary with at least five employees.

Group ByHavingAggregationsPaylocityBooz Allen HamiltonNashville Staffing
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership6 questions · ~51 min
More Behavioral & Leadership questions with a free account
3
More topics7 questions · ~60 min
Modeling Supply Chain Delay DistributionsMedium

Identify likely delay distributions and explain how to model skew, zeros, negatives, seasonality, and extreme disruptions in shipment delays.

DistributionsmodelingTime SeriesMcKinsey &
Prioritize Data for Market EntryMedium

Prioritize the most useful data sources to assess competitors before entering a new market.

User Researchmarket entrycompetitive landscapeMcKinsey &
Design Test for Product LaunchMedium

Design an A/B test for a new digital product launch with clear metrics, power, guardrails, and a defensible ship decision.

experiment designGuardrail Metricsprimary metricsMcKinsey &
Diagnosing Profit DeclinesHard

Tests structured root-cause analysis using transaction metrics and segmentation.

Diagnosisprofit marginsMcKinsey &
Automating Daily Sales Data PipelinesMedium

Tests pipeline design choices for reliability, automation, and maintainable data ingestion.

ETLBatch ProcessingAutomationMcKinsey &
Correlation Versus Causation ExplanationMedium

Explain why correlation measures association, while causation requires evidence that changing one variable changes the other.

CorrelationCausal InferenceCommunicationMcKinsey &
More 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
The finish line: interview-readyComplete all 16 questions plus 3 hands-on drills to finish this plan.