Back to Categories

Data Analyst Interview Questions

57 questions to help you prepare for your next interview.

DAU (Daily Active Users)

Average Order Value (AOV)

Calculating Percentages

Categorizing Data with CASE

Categorizing Data with CASE

Identifying Customer Churn

Handling NULLs with COALESCE

Cohort Retention Analysis

Correlation Function (CORR)

Refactoring with CTEs

Refactoring with CTEs

Multi-Dimensional Analysis with CUBE

Cumulative Distribution (CUME_DIST)

Ranking without Gaps (DENSE_RANK)

DENSE_RANK() vs RANK()

Extracting Date Parts

Extracting Date Parts

EXISTS Operator

Identify Duplicate Names

Finding the First Value (FIRST_VALUE)

FULL OUTER JOIN Basics

Funnel Analysis

Filtering Groups with HAVING

Filtering Groups with HAVING

Identify Duplicate Names

Joining Multiple Tables

LAG() for Comparisons

Accessing Previous Rows (LAG)

Finding the Last Value (LAST_VALUE)

LEAD() Function

Predicting Next Rows (LEAD)

Finding Missing Data (LEFT JOIN)

Market Basket Analysis (Self Join)

Calculating Median (PERCENTILE_CONT)

Calculating the Median

Calculating Moving Averages

NTILE() Function

Segmenting Data (NTILE)

Calculating Percentage of Total

Relative Ranking (PERCENT_RANK)

Monthly Revenue Reports

Generating Subtotals with ROLLUP

ROW_NUMBER() for Top N per Group

Calculating Running Totals

String Aggregation (GROUP_CONCAT)

Time to Next Order

Top N Rows per Group

Combining Results with UNION

Combining Results with UNION

YoY Revenue Growth