Top 47
Prep plan
Updated weekly · Last refresh Aug 30

The Boston Consulting Group Data Analyst Interview Questions

The questions to prepare for a The Boston Consulting Group Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

47questions
~6htotal time
Track your progressSign up free to work through all 47 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 2 drills · ~70 min
Rolling 30-Day Active UsersHard
Practice
Recently asked

Calculate daily rolling 30-day active users from a BCG event log using CTEs, date intervals, and distinct aggregation.

Window FunctionsDate FunctionsRunning TotalsThe Boston Consulting Group
DAX Year-to-Date Sales MeasureMedium
Recently asked

Tests DAX filter context control to ensure correct business metrics in Power BI at The Boston Consulting Group.

daxCase WhenAggregationsThe Boston Consulting Group
SQL Segments Revenue GrowthHard
Recently asked

Tests your ability to write robust SQL for time-based growth metrics with missing data.

Case WhensqlAggregationsThe Boston Consulting Group
Top Daily Rides by VehicleMedium
Practice
Practice drill

Rank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.

Window FunctionsJoinsData WranglingWaymo
SQL Window Functions Moving AverageMedium
Practice
Practice drill

Calculate a three-day moving average of active-client revenue using aggregation and SQL window functions.

Window FunctionsData AnalysissqlAAreteMITREGlassdoor
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership37 questions · ~305 min
Resume Walkthrough With ImpactEasy

Tests whether you can tell a clear, relevant career story and connect prior data science work to business impact.

CommunicationOwnershipThe Boston Consulting Group
More Behavioral & Leadership questions with a free account
3
More topics4 questions · ~33 min
A/B Test and Sample SizeHard
Recently asked

Tests experimental design and statistical reasoning for pricing decisions.

experiment designStatistical SignificanceSample SizeThe Boston Consulting Group
Power BI Direct Query ModelingHard
Recently asked

Tests Power BI modeling strategy and performance troubleshooting for large-scale client dashboards at The Boston Consulting Group.

performancepower biData ModelingThe Boston Consulting Group
Prove or Disprove CausalityHard
Recently asked

Tests your understanding of causal inference and how you validate marketing-retention relationships.

experiment designCorrelationCausal InferenceThe Boston Consulting Group
Clean Unstructured CSVs in PythonMedium
Recently asked

Tests Python data wrangling, missing-data handling, and pipeline reliability for client-ready datasets at The Boston Consulting Group.

Data Qualitydata integrationData WranglingThe Boston Consulting Group

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