Centre for Applied Data Analytics Research Interview Questions
The questions to prepare for Centre for Applied Data Analytics Research interviews, across all roles. Questions from real interview reports rank first. Updated daily.
Compare RANK, DENSE_RANK, and ROW_NUMBER by applying each to ordered employee scores.
Calculate monthly user totals, running totals, and time-based rankings with PostgreSQL window functions.
Explain how to detect, classify, and safely handle missing values in PostgreSQL production datasets.
Calculate each user's 7-day activity average and rank users within their cohort using PostgreSQL window functions.
Owner
TredenceIdentify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.
Define a success metric for a new feature that captures real user value, not just raw usage.
Explain statistical significance, p-values, practical importance, and uncertainty to a non-technical stakeholder.
Explain how to optimize near-term product outcomes without sacrificing long-term user trust, retention, and value.
Explain statistical significance, p-values, uncertainty, and practical importance to a non-technical audience.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.