Top 22
Prep plan
Updated weekly · Last refresh Oct 17

Weber Shandwick Business Analyst Interview Questions

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

22questions
~3htotal time
Track your progressSign up free to work through all 22 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 4 questions · ~32 min
Measure Marketing Campaign SuccessEasy

Define campaign success using business KPIs, funnel conversion, acquisition cost, and leading indicators tied to outcomes.

Funnel AnalysisKPIsLeading IndicatorsWeber Shandwick
Using Data to Make DecisionsMedium

Evaluates your data-driven decision-making and the impact of your insights.

data-driven decisionsinsightsWeber Shandwick
Excel Model for Multi-Channel ROIMedium

Tests your modeling approach for ROI measurement across channels and your ability to build usable outputs.

roicampaign performanceExcelWeber Shandwick
More Metrics questions with a free account
2
SQL & Data Manipulation3 questions + 3 drills · ~54 min
Cleaning a Messy Excel DatasetMedium

Tests your data cleaning workflow and ability to prepare messy client data for analysis.

Data WranglingExceldata integrityWeber Shandwick
Ensuring Data Integrity in Shared TrackingMedium

Tests your controls for preventing errors, version issues, and inconsistent updates in shared datasets.

collaborationExceldata integrityWeber Shandwick
Lookup-Based Data ReconciliationHard
Practice
Practice drill

Reconcile two financial sources by matching transaction keys and identifying amount, currency, date, and missing-record discrepancies.

Joinsfinancial dataData AnalysisAMD
Excel QuestionMedium
Practice
Practice drill

Reproduce an Excel customer sales summary with joins, aggregation, null handling, and spending classification.

JoinsData AnalysisExcelCATERPILLAR
Reconcile Datasets with LookupMedium
Practice
Practice drill

Identify amount discrepancies between two datasets, including missing values, using a shared record key.

null handlingJoinsData WranglingHilton Grand Vacations
More SQL & Data Manipulation questions with a free account
3
Behavioral & Leadership12 questions · ~96 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~24 min
Identifying Outliers in DataMedium

Assesses your statistical thinking and practical approach to spotting anomalies in business data.

Weber Shandwick
Using Social Listening for InfluencersMedium

Tests your strategy for turning social listening signals into actionable influencer targeting.

User SegmentsWeber Shandwick
Desk Research for Healthcare Campaign TopicsMedium

Tests your research process for identifying high-impact topics and themes for campaign planning.

Market TrendsCompetitive AnalysisWeber Shandwick

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