Top 50 Data Analyst Interview Questions
The 50 most important questions to prepare for Data Analyst interviews. Questions from real interview reports rank first. Updated weekly.
Calculate month-over-month sales growth for each product category using JOINs and window functions.
Wayfair
Fanatics
REVOLVECalculate the monthly spending trends for customers using window functions and joins.
The Home Depot
Hewlett Packard Enterprise
ConvoyAggregate monthly sales totals by product category using JOINs, GROUP BY, and date formatting.
Walgreens
Rev
LatentView AnalyticsUse GROUP BY and SUM to rank the top 10 customers by total revenue from a single sales table.
Mastek
Sage
Thornburg InvestmentCompute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
Meta
Acumen
CorningCompute a 7-day rolling average of daily revenue per user using aggregation and a sliding window.
MetaFind two indices whose values sum to a target using a hash table in O(n) time.
PayU
Barclays
FrontierUse a hash map frequency count to return the index of the first unique element in an array.
Eli Lilly andSign up to see every question
Create a free account to unlock this list and practice real interview questions.