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

Amazon DSP Business Analyst Interview Questions

The questions to prepare for a Amazon DSP Business Analyst interview. Questions from real interview reports rank first. Updated daily.

20questions
~3htotal time
Track your progressSign up free to work through all 20 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 3 drills · ~62 min
Cleaning Weekly Performance Report DataEasy
Recently asked

Explain how to clean nulls, blanks, duplicates, and invalid values before building a weekly SQL performance report.

Data WranglingETLQualityAmazon DSP
VLOOKUP vs INDEX MATCH in SQLMedium
Recently asked

Explain VLOOKUP vs INDEX/MATCH and how lookup design maps to SQL joins and key matching.

JoinsData WranglingAggregationsAmazon DSP
Click-Through Rate Per CampaignMedium
Practice
Recently asked
Practice drill

Calculate click-through rate per campaign using a join and conditional aggregations.

null handlingJoinssql queryAmazon DSP
Find Duplicate Records in SQLEasy
Practice
Recently asked
Practice drill

Use GROUP BY and HAVING to find duplicate patient records in a Johns Hopkins Medicine dataset.

Data WranglingGroup ByHavingEmersonCareDxSberbank
Compute Category Sales by LocationMedium
Practice
Recently asked
Practice drill

Calculate sales value by item category and location using pricing validity and a specified date range.

Date FunctionsJoinssqlAmazon AdvertisingAAmazon Kuiper Manufacturing EnterprisesAmazon DSP
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership10 questions · ~80 min
More Behavioral & Leadership questions with a free account
3
More topics6 questions · ~48 min
Root Cause of Engagement DropMedium
Recently asked

Evaluates structured root-cause analysis using data and operational context.

root cause analysisuser engagementAmazon DSP
Weather Impact on Delivery DelaysHard
Recently asked

Tests applying statistical methods to quantify whether weather drives delivery delays for Amazon DSP operations.

RegressionHypothesis TestingStatistical SignificanceAmazon DSP
Optimal Vans for a New StationHard
Recently asked

Tests capacity planning and quantitative reasoning to determine vehicle needs for Amazon DSP station launches.

Estimationcapacity planningMarket SizingAmazon DSP
Capacity Model for Holiday SurgeHard
Recently asked

Tests designing capacity models to ensure Amazon DSP network readiness under extreme demand growth.

Risk Assessmentcapacity planningResource AllocationAmazon DSP
Analyze Driver Turnover Root CausesMedium
Recently asked

Tests using operational and financial data to diagnose and address driver turnover issues for Amazon DSP partners.

root causeBusiness AcumenCustomer ObsessionAmazon DSP
Metrics to Reduce Cost Per DeliveryMedium
Recently asked

Tests selecting and prioritizing metrics to drive cost reduction in Amazon DSP delivery operations.

cost to qualityKPIDiagnosisAmazon DSP

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