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

Activision Blizzard Business Analyst Interview Questions

The questions to prepare for a Activision Blizzard Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

21questions
~3htotal time
Track your progressSign up free to work through all 21 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 3 questions · ~24 min
Investigate User Engagement DeclineMedium

Investigate a 15% engagement decline by decomposing the metric, isolating root causes, and proposing actions.

RetentionDiagnosisEngagement MetricsActivision Blizzard
Detecting Virtual Economy InflationHard

Tests your ability to define and interpret economy health metrics and detect inflation signals.

Diagnosiskpi hierarchyActivision Blizzard
More Metrics questions with a free account
2
Statistics & Probability3 questions · ~24 min
Applying Math to Player BehaviorMedium

Tests your statistical reasoning and ability to translate concepts into player analytics.

probabilitymodelingActivision Blizzard
A/B Test for Event ImpactHard

Tests your experimental design skills and ability to connect test metrics to business outcomes.

RetentionConversion RateA/B TestingActivision Blizzard
More Statistics & Probability questions with a free account
3
Behavioral & Leadership10 questions · ~80 min
More Behavioral & Leadership questions with a free account
4
More topics5 questions · ~40 min
Balance Monetization and Rider ExperienceEasy

A framework for deciding how to grow revenue without damaging the core user experience in a marketplace product.

User NeedsValue PropositionPain PointsActivision Blizzard
Building Accurate Excel ModelsMedium

Tests your ability to build reliable analytical models and validate calculations in Excel.

Data WranglingExceldata integrityActivision Blizzard
Go-to-Market Business CaseMedium

Assesses your strategic thinking around launch planning, positioning, and expected business impact.

Activision Blizzard
SQL for Top Spending PlayersMedium

Tests SQL proficiency for cohorting, time windows, and percentile-based segmentation.

Date FunctionsRankingsqlActivision Blizzard
More questions with a free account

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
Identify Funnel Bottlenecks in OnboardingHard
Practice
Practice drill

Use joins, CTEs, and aggregations to find the weakest step in an onboarding funnel and estimate lost conversions.

Funnel AnalysissqlDiagnosisAtlassianRevolut
SQL for MoM RetentionHard
Practice
Practice drill

Calculate cohort month-over-month retention for Thumbtack service professionals using CTEs, date truncation, joins, and aggregation.

Window FunctionsDate FunctionsRetentionThumbtack
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
The finish line: interview-readyComplete all 21 questions plus 3 hands-on drills to finish this plan.