Top 39

Prep plan

Updated weekly · Last refresh Oct 17

Boston Consulting Group Data Analyst Interview Questions

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

39questions

~6htotal time

Track your progressSign up free to work through all 39 questions and resume where you left off.

Start practicing free →

SQL & Data ManipulationStart here. 5 questions + 1 drill · ~53 min

SQL Nth Highest Salary QueryEasy

Practice

Find the third-highest distinct employee salary using PostgreSQL DISTINCT, ORDER BY, LIMIT, and OFFSET.

sql queryRankingsalary

Boston Consulting Group

SQL Top 10 Products by SalesEasy

Practice

Aggregate completed SMX product sales and return the top 10 products by units sold.

RankingGroup ByAggregations

Boston Consulting Group

Top Customers by Region VolumeMedium

Practice

Practice drill

Find the top 3 customers in each region by transaction volume using joins, aggregation, and window ranking.

Window FunctionsJoinsRanking

JPMorganChase

Silicon Valley Bank

Banco Santander

More SQL & Data Manipulation questions with a free account

Product Sense3 questions · ~26 min

Data Driven Business RecommendationEasy

Explain how you used data analysis to make a business recommendation and drive a clear product decision.

User ResearchUser NeedsUse Cases

Boston Consulting Group

More Product Sense 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

Pipelines7 questions · ~60 min

Handling Missing Data in PipelinesMedium

Approach for handling missing data in an ML data pipeline, including validation, imputation, and safe downstream consumption.

InfrastructureETLBatch Processing

Boston Consulting Group

Clean and Preprocess Multi-CSV DataHard

Evaluates pipeline design for data cleaning, feature preprocessing, and supervised model training.

data cleaningFeature Engineeringmodeling

Boston Consulting Group

More Pipelines questions with a free account

Metrics4 questions · ~34 min

Build a Marketing KPI DashboardMedium

Design a dashboard that connects campaign activity, funnel conversion, and acquisition efficiency to business outcomes.

North Star MetricKPIsLeading Indicators

Boston Consulting Group

More Metrics questions with a free account

Behavioral & Leadership17 questions · ~146 min

More Behavioral & Leadership questions with a free account