📈

Data Analyst Interview Questions

SQL, metrics, visualization, and communication

Practice the questions that separate good analysts from great ones. From SQL fundamentals to stakeholder communication—with tips for each.

Questions

SQL

What's the difference between UNION and UNION ALL?

easy

Write a query to calculate month-over-month growth.

medium

Explain window functions with an example.

medium

How would you find duplicate records in a table?

easy

Write a query to find the top 3 products by revenue in each category.

medium

What's a CTE and when would you use one?

easy

How do you optimize a slow-running query?

medium

Metrics & Analysis

How would you define and measure user engagement?

medium

Revenue dropped 10% this month. How would you investigate?

hard

What metrics would you track for a subscription business?

medium

How do you choose between multiple metrics that conflict?

medium

How would you measure the success of a new feature?

medium

What's the difference between correlation and causation?

easy

Data Visualization

When would you use a bar chart vs. a line chart?

easy

How do you present data to non-technical stakeholders?

medium

Walk me through how you'd create a dashboard for executives.

medium

What makes a good data visualization?

easy

Excel & Tools

What's the difference between VLOOKUP and INDEX/MATCH?

easy

How would you create a pivot table to analyze sales data?

easy

What's your experience with BI tools?

easy

How do you ensure data quality in your analyses?

medium

Behavioral

Tell me about a time your analysis changed a business decision.

medium

Describe a time when you found an error in your analysis.

medium

How do you prioritize when you have multiple analysis requests?

medium

Tell me about a time you had to explain complex data to someone non-technical.

medium

How do you handle a stakeholder who disagrees with your analysis?

medium

Practice with Real Feedback

Record yourself answering these questions and get AI-powered feedback on your delivery.

Data Analyst Interview Questions

SQL

What's the difference between UNION and UNION ALL?

Write a query to calculate month-over-month growth.

Explain window functions with an example.

How would you find duplicate records in a table?

Write a query to find the top 3 products by revenue in each category.

What's a CTE and when would you use one?

How do you optimize a slow-running query?

Metrics & Analysis

How would you define and measure user engagement?

Revenue dropped 10% this month. How would you investigate?

What metrics would you track for a subscription business?

How do you choose between multiple metrics that conflict?

How would you measure the success of a new feature?

What's the difference between correlation and causation?

Data Visualization

When would you use a bar chart vs. a line chart?

How do you present data to non-technical stakeholders?

Walk me through how you'd create a dashboard for executives.

What makes a good data visualization?

Excel & Tools

What's the difference between VLOOKUP and INDEX/MATCH?

How would you create a pivot table to analyze sales data?

What's your experience with BI tools?

How do you ensure data quality in your analyses?

Behavioral

Tell me about a time your analysis changed a business decision.

Describe a time when you found an error in your analysis.

How do you prioritize when you have multiple analysis requests?

Tell me about a time you had to explain complex data to someone non-technical.

How do you handle a stakeholder who disagrees with your analysis?

More Interview Questions

Practice with Real Feedback