Dataford
Top 50
Topic roadmap
Updated weekly · Last refresh Sep 13

Top 50 Data Analysis Interview Questions

The most frequently asked Data Analysis questions across all roles and companies, ranked by real interview frequency. Updated daily.

50questions
~17htotal time
155companies covered
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 46 questions · ~938 min
SQL Window Functions Moving AverageMedium
Practice
Recently asked

Calculate a three-day moving average of active-client revenue using aggregation and SQL window functions.

Window FunctionsData AnalysissqlAAreteSShyena Tech YarnsAATB Financial
7-Day Rolling Average ExportsMedium
Practice
Recently asked

Calculate a 7-day rolling average of Adobe Acrobat document exports using a window function.

Data AnalysisAggregationsAdobeAbbottOOura Ring
Running Average With Window FunctionsEasy
Practice
Recently asked

Calculate each Hinge user's 30-day rolling average of daily interactions using CTEs and window functions.

Window FunctionsData AnalysissqlHingeAAlight SolutionsTTikTok USDS JV
SQL Retention Rate QueryMedium
Practice

Calculate Disney+ January cohort retention in February using a CTE, LEFT JOIN, date filters, and distinct user counts.

sql queryData AnalysisDDisney Entertainment & SportsTuroIntuit
Top Users by Recent Transaction VolumeMedium
Practice
Recently asked

Find the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.

Data Analysisquery optimizationsqlTTier 1 BankRevolutChime
SQL Window Functions for Rolling MetricsMedium
Practice

Calculate Snapmint's 30-day rolling average of daily loan defaults using aggregation and window functions.

Data AnalysisAggregationsSSnapmintFlowKoch
Using SQL Window FunctionsMedium
Practice
Recently asked

Calculate three-day rolling passenger entry averages for TfL stations using aggregation and window functions.

Window FunctionsData AnalysissqlTransport for LondonThe Trade DeskMercari
Top Products by CategoryEasy
Practice

Use joins, aggregation, and ROW_NUMBER to find the top three Chewy products in each category for the prior quarter.

sales metricssql queryData AnalysisChewyStaples IndiaEnova International
More SQL & Data Manipulation questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
2
Coding4 questions · ~82 min
More Coding questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.