Dataford
Dataford
Top 21
Prep plan
Updated weekly · Last refresh Oct 17

Oliver Wyman Data Analyst Interview Questions

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

21questions
~3htotal time
Track your progressSign up free to work through all 21 questions and resume where you left off.
Start practicing free →
1
Statistics & ProbabilityStart here. 3 questions · ~25 min
Probability and Financial MathHard

Build a probability-based financial model using discounted cash flows, expected loss, variance, and simulation.

financial calculationsprobabilityrisk modelingOliver Wyman
Unseen Interest Rate ProblemMedium

Explain how you would solve and validate an unfamiliar interest-rate calculation during a case or analysis.

compound returnsfinancial calculationssensitivity analysisOliver Wyman
More Statistics & Probability questions with a free account
2
Metrics3 questions · ~25 min
KPIs for Reporting EfficiencyHard

Prioritize and define KPIs that measure the speed, reliability, quality, and business usefulness of Oliver Wyman reporting.

KPIsoperational metricsefficiencyOliver Wyman
Analyzing Concert Market in ChinaHard

Build a metric framework to size, segment, compare, and assess growth opportunities in China's concert market.

analyticsmarket analysismarket shareOliver Wyman
More Metrics questions with a free account
3
Behavioral & Leadership11 questions · ~92 min
More Behavioral & Leadership questions with a free account
4
More topics4 questions · ~34 min
Choosing Restaurant Expansion OptionsMedium

Evaluate restaurant expansion options by customer demand, economics, operational fit, and risk.

Decision MakingFeature Prioritizationproduct decisionOliver Wyman
Troubleshooting Production SQLMedium

Tests debugging skills and operational thinking for SQL in real systems.

production environmentsqlTroubleshootingOliver Wyman
Building a Dashboard From ScratchMedium

Tests end-to-end data preparation workflow for reliable dashboard creation.

data preparationdata sourcingOliver Wyman
Tableau Consistency Across ProjectsMedium

Tests Tableau best practices for scalable, consistent dashboard delivery.

data visualizationProject ManagementOliver Wyman

Sign up to see every question

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

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Analyze Customer Purchase Trends with Window FunctionsEasy
Practice
Practice drill

Calculate the monthly spending trends for customers using window functions and joins.

The Home DepotAvisoHewlett Packard Enterprise
SQL and Programming Interview MixMedium
Practice
Practice drill

Approach a mixed interview round while summarizing completed activity with a CTE, aggregation, and left join.

JoinsCTEssqlWise
SQL and Python FundamentalsMedium
Practice
Practice drill

Join two tables and derive palindrome, reversed-substring, and character-frequency results with PostgreSQL.

pandasJoinsData ManipulationHsbc
The finish line: interview-readyComplete all 21 questions plus 3 hands-on drills to finish this plan.