XYZ Data Analyst Interview Questions
The questions to prepare for a XYZ Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
XYZFind the top 10 products by total sales revenue using joins, aggregation, and a CTE.
XYZExplain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.
XYZUse PostgreSQL window functions to calculate user running spend and rank users by total spend within each signup cohort.
Deloitte
NewMarket
DrwSet a clear north star, supporting KPIs, leading indicators, and guardrails for a new product feature.
XYZDiagnose a sharp decline in client engagement and break it down into cohorts, funnel steps, and likely business drivers.
XYZDefine primary and guardrail metrics for a discovery UI test, with power, MDE, and a pre-registered analysis plan.
XYZExplain why two metrics moving together does not prove that one causes the other, and how to assess causality more carefully.
XYZTests your ability to detect anomalies and quantify how they affect conclusions or models.
XYZSign up to see every question
Create a free account to unlock this list and practice real interview questions.