Top 46
Prep plan
Updated weekly · Last refresh Sep 22

Commonwealth Bank of Australia Data Analyst Interview Questions

The questions to prepare for a Commonwealth Bank of Australia Data Analyst interview. Questions from real interview reports rank first. Updated daily.

46questions
~7htotal time
Track your progressSign up free to work through all 46 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 15 questions + 1 drill · ~138 min
Write Rolling Three-Month Averages SQLMedium
Practice

Use monthly aggregation, a calendar series, and window functions to calculate three-month customer transaction averages.

sql queryData AnalysisAggregationsCommonwealth Bank of Australia
Calculate Monthly Sales Growth by Product CategoryMedium
Practice

Calculate month-over-month sales growth for each product category using JOINs and window functions.

JoinsAggregationsCommonwealth Bank of Australia
Cleaning Data for Dashboard TablesMedium

Explain how to use SQL data wrangling, joins, CTEs, CASE logic, and date handling to turn messy source data into dashboard-ready tables.

JoinsData WranglingAggregationsCommonwealth Bank of Australia
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
More SQL & Data Manipulation questions with a free account
2
Product Sense3 questions · ~26 min
Using Data to Find OpportunityMedium

Explain how you used product data to uncover an unmet user need and turn it into a prioritized product opportunity.

User ResearchUser NeedsProduct VisionCommonwealth Bank of Australia
Why Data Analytics at CBAEasy

Tests motivation and alignment with Commonwealth Bank of Australia's data and banking mission.

User NeedsValue PropositionProduct VisionCommonwealth Bank of Australia
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
3
Metrics7 questions · ~60 min
Diagnose a Metric Drop After LaunchMedium

Investigate why a key KPI moved the wrong way after a product change and separate signal from noise.

Lagging IndicatorsLeading IndicatorsDiagnosisCommonwealth Bank of Australia
Analyzing Customer Churn PatternsMedium

Tests your analytical approach to identifying churn drivers and actionable retention opportunities.

Data AnalysisCommonwealth Bank of Australia
Branch Traffic InsightsMedium

Assesses your ability to derive actionable insights from location and customer traffic data.

Commonwealth Bank of Australia
More Metrics questions with a free account
4
Behavioral & Leadership21 questions · ~179 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 46 questions plus 1 hands-on drill to finish this plan.