Top 22
Prep plan
Updated weekly · Last refresh Aug 30

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 weekly.

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
Normalize Customer Addresses by RegionHard
Practice
Practice drill

Standardize inconsistent addresses using joins, CTEs, and CASE logic to map each record to a normalized region.

data cleaningData WranglingExcelTelus Digital
Excel Live AssessmentMedium
Practice
Practice drill

Use joins, CASE logic, and aggregation to recreate an Excel-style lookup and pivot report.

PivotData ManipulationExcelAmazon Web Services
Monthly Fusion Team Adoption SummaryMedium
Practice
Practice drill

Use joins, a CTE, CASE, and date functions to summarize monthly Autodesk Fusion team activity and paid-seat adoption.

Data ManipulationExcelFinancial AnalysisAutodesk
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
Desk Research for Healthcare Campaign TopicsMedium

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

Market TrendsCompetitive AnalysisWeber Shandwick
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

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.