Dataford
Top 18
Prep plan
Updated weekly · Last refresh Aug 30
D

dentsu Data Analyst Interview Questions

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

18questions
~2htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 3 drills · ~62 min
SQL Query OptimizationMedium

Tests your approach to diagnosing and improving SQL performance.

Performance Tuningsqlddentsu
Handling Missing and Dirty SQL DataMedium

Explain how to profile, clean, and standardize missing or dirty data before analysis.

Data WranglingCase WhenQualityddentsu
Power Query vs DAXMedium

Tests your understanding of Power BI modeling and transformation using Power Query and DAX.

Data Analysispower biddentsu
SQL, Python, and Group DiscussionMedium

Evaluates practical analytics skills and collaboration in a structured setting.

Communicationtechnical skillsddentsu
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
Top Users by Recent Transaction VolumeMedium
Practice
Practice drill

Find the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.

Data Analysisquery optimizationsqlTTier 1 BankRevolutChime
Normalize Messy CRM Contact DataHard
Practice
Practice drill

Clean inconsistent CRM contacts by joining source tables, standardizing values, and flagging bad records.

Data WranglingCase WhenQualityAlphaSense
2
Behavioral & Leadership12 questions · ~96 min
Translating Technical Features for ExecutivesMedium

Tests executive communication: turning technical product detail into strategic business value for senior non-technical buyers.

value sellingCommunicationexecutive presenceddentsu
Prioritizing Competing DeadlinesEasy

Tests prioritization under pressure, including trade-off judgment, stakeholder communication, and ownership of outcomes.

OwnershipDealing With AmbiguityPrioritizationddentsu
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~16 min
Trend Analysis and ForecastingMedium

Tests your ability to select and apply statistical methods for forecasting and trend insights.

Forecastingddentsu
Engagement and Retention MetricsMedium

Evaluates metrics thinking and operational execution for engagement and retention.

ddentsu

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 18 questions plus 3 hands-on drills to finish this plan.