Dataford
Dataford
Top 6
Prep plan
Updated weekly · Last refresh Nov 6
C

CPKC Data Analyst Interview Questions

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

6questions
~1htotal time
Track your progressSign up free to work through all 6 questions and resume where you left off.
Start practicing free →
1
Behavioral & LeadershipStart here. 3 questions · ~24 min
Conflict and Team Member ResolutionEasy

Tests conflict resolution, respectful communication, accountability, and the ability to restore productive teamwork.

Conflict ResolutionteamworkaccountabilityCCPKC
Explain Findings to Non-Technical StakeholdersMedium

Tests analytical communication, audience awareness, stakeholder influence, and ownership of business outcomes.

analytical skillsaudience analysisStakeholder ManagementCCPKC
Handling Challenging Workplace ProblemsEasy

Tests ownership, structured problem solving, prioritization, and learning from outcomes.

challengesadaptabilityaccountabilityCCPKC
2
More topics3 questions · ~24 min
Star vs Snowflake for Meta AnalyticsEasy

Explain star and snowflake schemas, their tradeoffs, and when to use each in Meta-scale analytics systems.

CCPKC
Visualize Metrics to Show TrendsEasy

Choose visuals that make trend direction, comparisons, and KPI drivers easy to understand at a glance.

KPIsLeading IndicatorsDiagnosisCCPKC
Star vs Snowflake for Sales AnalyticsMedium

Compare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.

JoinsData WranglingGroup ByCCPKC

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
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
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 WranglingWaymoCruise
SQL Basics for Data AnalysisEasy
Practice
Practice drill

Demonstrate how SQL supports analysis by filtering records and summarizing positive measures by category.

JoinsData WranglingGroup ByEPAM SystemsWarner Bros.
The finish line: interview-readyComplete all 6 questions plus 3 hands-on drills to finish this plan.