Dataford
Dataford
Top 4
Prep plan
Updated weekly · Last refresh Oct 17
C

CPP Investments | Investissements RPC Business Intelligence Analyst Interview Questions

The questions to prepare for a CPP Investments | Investissements RPC Business Intelligence Analyst interview. Questions from real interview reports rank first. Updated daily.

4questions
~1htotal time
Track your progressSign up free to work through all 4 questions and resume where you left off.
Start practicing free →
1
Behavioral & LeadershipStart here. 3 questions · ~24 min
Using Data for DecisionsMedium

Tests data-driven judgment, stakeholder influence, prioritization, and ownership of business outcomes.

Leadershipaccountabilityanalytical mindsetCCPP Investments | Investissements RPC
Prioritizing Competing Data RequestsMedium

Tests prioritization under pressure in a data engineering context, including stakeholder management, trade-off decisions, and ownership of outcomes.

Decision MakingStakeholder ManagementPrioritizationCCPP Investments | Investissements RPC
Explaining Analysis to Non-Technical StakeholdersEasy

Tests communication of complex data to non-technical stakeholders, including clarity, stakeholder management, and actionable storytelling.

Influence Without AuthorityStakeholder ManagementCommunicationCCPP Investments | Investissements RPC
2
More topics1 question · ~8 min
Handling Missing and Dirty SQL DataMedium

Explain how to profile, clean, and standardize missing or dirty data before analysis.

Data WranglingCase WhenQualityCCPP Investments | Investissements RPC

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
Handling 30% Missing Critical DataMedium
Practice
Practice drill

Audit critical-field completeness by application source and report missing-entry percentages.

missing valuesdata accuracyData WranglingAmerican Credit Acceptance
Normalize Messy CRM Contact DataHard
Practice
Practice drill

Clean inconsistent CRM contacts by joining source tables, standardizing values, and flagging bad records.

Data WranglingCase WhenQualityAlphaSense
Handle Inconsistent Formatting Across SourcesMedium
Practice
Practice drill

Clean inconsistent names, regions, and currency values from a single source-records table.

data cleaningData Wranglinginconsistent dataWorld Wide Technology
The finish line: interview-readyComplete all 4 questions plus 3 hands-on drills to finish this plan.