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

Centre for Applied Data Analytics Research Data Scientist Interview Questions

The questions to prepare for a Centre for Applied Data Analytics Research Data Scientist interview. Questions from real interview reports rank first. Updated daily.

12questions
~2htotal time
Track your progressSign up free to work through all 12 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 1 drill · ~42 min
SQL Window FunctionsHard
Practice

Calculate monthly user totals, running totals, and time-based rankings with PostgreSQL window functions.

Window FunctionsDate FunctionsData ManipulationCCentre for Applied Data Analytics Research
SQL Ranking FunctionsMedium
Practice

Compare RANK, DENSE_RANK, and ROW_NUMBER by applying each to ordered employee scores.

Data ManipulationRankingdatabase queryingCCentre for Applied Data Analytics Research
Handling Missing Values in ProductionMedium

Explain how to detect, classify, and safely handle missing values in PostgreSQL production datasets.

missing valuesdata cleaningproduction environmentCCentre for Applied Data Analytics Research
SQL Window Functions for Rolling MetricsHard
Practice
Practice drill

Calculate each user's 7-day activity average and rank users within their cohort using PostgreSQL window functions.

Window FunctionsDate FunctionsData ManipulationMMarketCastOwnerTredence
2
Behavioral & Leadership4 questions · ~43 min
More Behavioral & Leadership questions with a free account
3
More topics5 questions · ~53 min
Explaining Statistical SignificanceMedium

Explain statistical significance, p-values, uncertainty, and practical importance to a non-technical audience.

Hypothesis TestingCommunicationStatistical SignificanceCCentre for Applied Data Analytics Research
Balance Short-Term and Long-Term ValueHard

Explain how to optimize near-term product outcomes without sacrificing long-term user trust, retention, and value.

product metricsTrade-offsFeature PrioritizationCCentre for Applied Data Analytics Research
Common Pitfalls in Experiment ResultsHard

Identify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.

PeekingNovelty EffectSample Ratio MismatchCCentre for Applied Data Analytics Research
Explain Statistical SignificanceMedium

Explain statistical significance, p-values, practical importance, and uncertainty to a non-technical stakeholder.

Hypothesis TestingCommunicationStatistical SignificanceCCentre for Applied Data Analytics Research
Define Metrics for New FeaturesMedium

Define a success metric for a new feature that captures real user value, not just raw usage.

MetricsFeature Prioritizationuser valueCCentre for Applied Data Analytics Research

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 12 questions plus 1 hands-on drill to finish this plan.