Top 50
Prep plan
Updated weekly · Last refresh Oct 17

PwC Data Analyst Interview Questions

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

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
Product SenseStart here. 7 questions · ~56 min
2
A/B Testing & Experimentation5 questions · ~40 min
Design Experiment for Product ChangeHard
Recently asked

Design an end-to-end A/B test for a new product change, including metrics, MDE, power, randomization, and launch decision rules.

ExperimentationGuardrail MetricsA/B TestingPwC
Network Interference in Collaboration TestMedium
Recently asked

Explain when network interference threatens an A/B test, how it biases estimates, and how to redesign the experiment safely.

Network InterferenceExperimentationA/B TestingPwC
More A/B Testing & Experimentation 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
3
Pipelines7 questions · ~56 min
Python for ETL Pipeline TasksEasy
Recently asked

Discuss Python scripting experience for ETL, orchestration, and data quality tasks in data pipelines.

InfrastructureToolsETLPwC
More Pipelines questions with a free account
4
SQL & Data Manipulation4 questions + 3 drills · ~62 min
Handling Missing Data in SQLEasy
Recently asked

Explain how to identify, assess, and handle missing values in SQL using NULL checks, COALESCE, and validation logic.

Data WranglingCase WhenQualityPwC
Analyzing Large Datasets with SQLEasy
Recently asked

Explain practical SQL methods for analyzing large datasets, including filtering, aggregation, sampling, and performance-aware query design.

JoinsData WranglingAggregationsPwC
Self-Joins for HierarchiesMedium
Practice
Recently asked
Practice drill

Use a self-join to display each employee alongside their manager and department, including top-level and unmatched managers.

data relationshipsJoinsData WranglingPwC
Detect Changed Records in SQLMedium
Practice
Recently asked
Practice drill

Compare two table snapshots to return added, deleted, and modified records with null-safe value comparisons.

JoinsData Wranglingdata migrationPwC
SQL Performance for JoinsMedium
Practice
Recently asked
Practice drill

Optimize a PostgreSQL query that joins customer, order, and item data while calculating aggregated order revenue.

database optimizationJoinsAggregationsKikoffOraclePwC
More SQL & Data Manipulation questions with a free account
5
Metrics5 questions · ~40 min
Measuring Recommendation SuccessMedium
Recently asked

Assesses how you define success criteria and evaluate impact of analytics decisions.

Lagging IndicatorsKPIsLeading IndicatorsPwC
More Metrics questions with a free account
6
Behavioral & Leadership21 questions · ~168 min
More Behavioral & Leadership questions with a free account
7
More topics1 question · ~8 min
Supervised vs Unsupervised LearningMedium
Recently asked

Compare how labeled and unlabeled data drive supervised and unsupervised machine-learning tasks.

Stakeholder ManagementCommunicationtechnical fundamentalsPwC
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.