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.
Calculate a three-day moving average of active-client revenue using aggregation and SQL window functions.
Calculate each Hinge user's 30-day rolling average of daily interactions using CTEs and window functions.
HingeCCatalyst Operations & AnalyticsAAlight SolutionsCalculate a 7-day rolling average of Adobe Acrobat document exports using a window function.
Abbott
AdobeOOura RingFind the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.
ChimeCalculate Snapmint's 30-day rolling average of daily loan defaults using aggregation and window functions.
FlowKKreditBeeSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Calculate Disney+ January cohort retention in February using a CTE, LEFT JOIN, date filters, and distinct user counts.
Turo
IntuitWrite and explain a query that summarizes analyst query performance by dataset and ranks analysts by success rate.
Autodesk
PCS Global Tech
Gro IntelligenceIdentify the five most active users in each category using aggregation and row numbering.
Nestl S.ACCity of HopeEEulidia