Dataford
Top 22
Prep plan
Updated weekly · Last refresh Aug 30

Weber Shandwick Data Analyst Interview Questions

The questions to prepare for a Weber Shandwick Data 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
Investigating Website Traffic SpikesMedium

Tests diagnostic thinking and troubleshooting for anomalous web analytics data.

Diagnosisanomaly detectionWeber Shandwick
Structure Brand Sentiment AnalysisMedium

Tests your approach to sentiment analysis design, segmentation, and actionable insights.

Sentiment AnalysisDiagnosisWeber Shandwick
Social Campaign Engagement MetricsEasy

Tests your understanding of engagement metrics and how to operationalize them for reporting.

campaign performancesocial mediaEngagement MetricsWeber Shandwick
Measuring PR Campaign SuccessMedium

Tests KPI selection and measurement design for integrated PR campaigns.

campaign performancekpi hierarchyWeber Shandwick
2
Behavioral & Leadership15 questions · ~120 min
Solving An Ambiguous Analytics ProblemMedium

Tests ownership and stakeholder management in ambiguous analytics work, with emphasis on structuring messy problems into data-driven decisions.

Problem SolvingOwnershipWeber Shandwick
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~24 min
Advanced Excel for Data CleaningMedium

Tests practical Excel skills for cleaning and structuring messy client data for campaign analytics.

JoinsData WranglingExcelWeber Shandwick
Earned, Owned, Paid Media AnalysisMedium

Tests your ability to map media types to appropriate metrics and analytical approaches.

competitive landscapeUse CasesWeber Shandwick
Merging Media Reports AccuratelyMedium

Tests data validation and reconciliation when combining cross-platform performance datasets.

Data WranglingReconciliationdata integrityWeber Shandwick

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 Decision Impact by RegionEasy
Practice
Practice drill

Use joins, CASE WHEN, and date filtering to compare outcome rates before and after a decision.

Data WranglingDiagnosisAggregationsHarbourVest Partners
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
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
The finish line: interview-readyComplete all 22 questions plus 3 hands-on drills to finish this plan.