Top 50 Data Scientist Interview Questions
The 50 most important questions to prepare for Data Scientist interviews. Questions from real interview reports rank first. Updated daily.
Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
Meta
Spotify
Meta ITCalculate a three-day moving average of active-client revenue using aggregation and SQL window functions.
Demonstrate window functions by ranking active employees by salary within each department.
Johnson & Johnson
CRIF
RegionsUse SQL window functions to rank regions by average 2024 yield within each country.
Ernst & Young
KBR
Maximus TechCalculate three-day rolling average sales by region using aggregation, joins, and PostgreSQL window functions.
AAreteSSweetwaterRRichemontCalculate the monthly spending trends for customers using window functions and joins.
The Home Depot
Aviso
Hewlett Packard EnterpriseSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Replace missing sales fields with defined defaults and return a consistently ordered dataset.
University of MinnesotaThe Home Depot
NationwideCalculate month-over-month sales growth for each product category using JOINs and window functions.
Wayfair
REVOLVE
Fanatics