Top 15
Prep plan
Updated weekly · Last refresh Oct 17

Collinson Data Analyst Interview Questions

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

15questions
~2htotal time
Track your progressSign up free to work through all 15 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 7 questions + 3 drills · ~86 min
Validating Data Before ReportingEasy

Explain how to validate SQL data before reporting, including null checks, duplicates, outliers, and aggregation reconciliation.

JoinsData WranglingQualityCollinson
Handling Missing and Dirty SQL DataMedium

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

Data WranglingCase WhenQualityCollinson
Challenges Building Tableau DashboardsMedium

Assesses practical dashboard design skills and problem-solving for Tableau reporting.

Collinson
Case Study With Real DataHard

Evaluates ability to analyze real data and generate actionable alternative solutions.

case studyCollinson
Finding Drop-Off DriversHard

Tests your ability to derive actionable insights from data using rigorous analysis.

Data Analysisuser engagementCollinson
Analyzing Nursing Data with SQLHard
Practice
Practice drill

Analyze CMS nursing staffing records by facility, handling missing data and classifying facilities against a staffing benchmark.

JoinsData Analysiscase studyClipboard Health
Writing a Complex SQL QueryMedium
Practice
Practice drill

Write and explain a query that summarizes analyst query performance by dataset and ranks analysts by success rate.

JoinsData Analysiscomplex queriesAutodeskPCS Global TechGro Intelligence
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
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership6 questions · ~48 min
Handling Critical Feedback on AnalysisEasy

Tests how you receive and act on feedback about your analysis, including communication, stakeholder management, and self-awareness.

CommunicationOwnershipDealing With AmbiguityCollinson
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~16 min
Revamping Customer PropositionMedium

Assesses product sense and analytical thinking for improving customer propositions at Collinson.

experienceCollinson
Predicting Churn and LoyaltyMedium

Tests your modeling choices for churn and loyalty prediction in a customer behavior context.

Collinson

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 15 questions plus 3 hands-on drills to finish this plan.