Data Analyst interview questions

Describe a time your analysis contradicted what a stakeholder wanted to hear. What did you do?

From the Google guide · Practice it in a mock interview · Draft my answer from my resume

Two dashboards disagree about the same number. How do you find out which one is right?

From the Google guide · Practice it in a mock interview · Draft my answer from my resume

Tell me about a time your analysis changed a decision. What was the result?

From the Amazon guide · Practice it in a mock interview · Draft my answer from my resume

Describe a time you had to deliver an analysis with incomplete data. What did you do?

From the Amazon guide · Practice it in a mock interview · Draft my answer from my resume

Tell me about a disagreement with a stakeholder over what the data showed.

From the Amazon guide · Practice it in a mock interview · Draft my answer from my resume

Tell me about an analysis that contradicted what a team wanted to hear and what you did with it.

From the Meta guide · Practice it in a mock interview · Draft my answer from my resume

Two dashboards disagree about the same metric. How do you find out which one is right?

From the Meta guide · Practice it in a mock interview · Draft my answer from my resume

Tell me about a time a stakeholder asked for a number that did not answer their real question.

From the Microsoft guide · Practice it in a mock interview · Draft my answer from my resume

Tell me about an analysis that a stakeholder disagreed with and what you did next.

From the NVIDIA guide · Practice it in a mock interview · Draft my answer from my resume

Tell me about an analysis that contradicted what a team wanted to hear and what you did with it.

From the LinkedIn guide · Practice it in a mock interview · Draft my answer from my resume

Two dashboards disagree about the same metric. How do you find out which is right?

From the LinkedIn guide · Practice it in a mock interview · Draft my answer from my resume

Why do you want to work on this team's problems specifically?

From the Apple guide · Practice it in a mock interview · Draft my answer from my resume

Tell me about an analysis that contradicted what a team wanted to hear and what you did with it.

From the Apple guide · Practice it in a mock interview · Draft my answer from my resume

Two dashboards disagree about the same metric. How do you find out which is right?

From the Apple guide · Practice it in a mock interview · Draft my answer from my resume

Tell me about an analysis a manager disagreed with and what you did next.

From the Tesla guide · Practice it in a mock interview · Draft my answer from my resume

Two reports disagree about the same production number. How do you reconcile them?

From the Tesla guide · Practice it in a mock interview · Draft my answer from my resume

Why do you want to work on this team's problems?

From the Tesla guide · Practice it in a mock interview · Draft my answer from my resume

Tell me about an analysis a stakeholder disagreed with and what you did next.

From the Stripe guide · Practice it in a mock interview · Draft my answer from my resume

Tell me about an analysis a stakeholder disagreed with and what you did next.

From the Intel guide · Practice it in a mock interview · Draft my answer from my resume

Two reports disagree about the same number. How do you reconcile them?

From the Intel guide · Practice it in a mock interview · Draft my answer from my resume

Tell me about an analysis that changed a decision.

Practice it in a mock interview · Draft my answer from my resume

Describe a time your number turned out to be wrong. What happened next?

Practice it in a mock interview · Draft my answer from my resume

How did you handle a stakeholder who wanted a different answer than the data gave?

Practice it in a mock interview · Draft my answer from my resume

Write a query that returns each customer's most recent purchase and explain how you would test it.

From the Google guide · Practice it in a mock interview · Draft my answer from my resume

Write a query that returns each customer's first and most recent order and the days between them.

From the Amazon guide · Practice it in a mock interview · Draft my answer from my resume

Write a query that returns the share of users who returned within a week of their first session.

From the Meta guide · Practice it in a mock interview · Draft my answer from my resume

Write a query that returns the top product by revenue in each region and explain how you would check it.

From the Microsoft guide · Practice it in a mock interview · Draft my answer from my resume

Write a query that returns each customer's most recent order and the number of days since the one before it.

From the NVIDIA guide · Practice it in a mock interview · Draft my answer from my resume

Write a query that returns the share of new members who return within a week and explain how you would validate it.

From the LinkedIn guide · Practice it in a mock interview · Draft my answer from my resume

Write a query that returns the share of users who returned within a week of first use and explain how you would validate it.

From the Apple guide · Practice it in a mock interview · Draft my answer from my resume

Write a query that returns each vehicle's most recent service visit and the days since the previous one.

From the Tesla guide · Practice it in a mock interview · Draft my answer from my resume

Write a query that returns each merchant's first successful charge and the days since the previous attempt, then extend it to exclude refunds.

From the Stripe guide · Practice it in a mock interview · Draft my answer from my resume

Write a query that returns each unit's most recent test result and the number of retests before it.

From the Intel guide · Practice it in a mock interview · Draft my answer from my resume

Which function would you use to combine two tables on a shared key, and what breaks when keys do not match?

Practice it in a mock interview · Draft my answer from my resume

Daily active users dropped sharply last week. How would you investigate before reporting it?

From the Google guide · Practice it in a mock interview · Draft my answer from my resume

How would you define a success metric for a new search feature, and what could make it misleading?

From the Google guide · Practice it in a mock interview · Draft my answer from my resume

Which of three requested analyses would you do first, and how would you explain the choice?

From the Google guide · Practice it in a mock interview · Draft my answer from my resume

Conversion dropped after a site change. How would you investigate before reporting a cause?

From the Amazon guide · Practice it in a mock interview · Draft my answer from my resume

How would you define a metric for whether a new feature is working, and what could make it misleading?

From the Amazon guide · Practice it in a mock interview · Draft my answer from my resume

Daily active users fell sharply in one country last week. How would you investigate before reporting it?

From the Meta guide · Practice it in a mock interview · Draft my answer from my resume

How would you define a success metric for a new messaging feature, and what could make it misleading?

From the Meta guide · Practice it in a mock interview · Draft my answer from my resume

Which of three requested analyses would you run first, and how would you explain the choice?

From the Meta guide · Practice it in a mock interview · Draft my answer from my resume

Weekly active users fell while sign-ups rose. Walk me through how you would investigate.

From the Microsoft guide · Practice it in a mock interview · Draft my answer from my resume

How would you define a metric for whether a new feature is being adopted, and what could make it misleading?

From the Microsoft guide · Practice it in a mock interview · Draft my answer from my resume

Two teams report different totals for the same metric. How do you reconcile them?

From the Microsoft guide · Practice it in a mock interview · Draft my answer from my resume

Which of several requested analyses would you do first, and how would you explain that to the people waiting?

From the Microsoft guide · Practice it in a mock interview · Draft my answer from my resume

A weekly usage metric dropped in one product line. How would you investigate before reporting a cause?

From the NVIDIA guide · Practice it in a mock interview · Draft my answer from my resume

How would you define a success metric for a new developer tool, and what could make it misleading?

From the NVIDIA guide · Practice it in a mock interview · Draft my answer from my resume

Two teams report different totals for the same metric. How do you reconcile them?

From the NVIDIA guide · Practice it in a mock interview · Draft my answer from my resume

Which of three requested analyses would you run first, and how would you explain the choice to the people waiting?

From the NVIDIA guide · Practice it in a mock interview · Draft my answer from my resume

Weekly active members fell in one region while sign-ups rose. How would you investigate before reporting?

From the LinkedIn guide · Practice it in a mock interview · Draft my answer from my resume

How would you define a success metric for a new messaging feature, and what could make it misleading?

From the LinkedIn guide · Practice it in a mock interview · Draft my answer from my resume

Which of three requested analyses would you run first, and how would you explain that choice?

From the LinkedIn guide · Practice it in a mock interview · Draft my answer from my resume

Engagement with a feature dropped after a release. How would you investigate before reporting a cause?

From the Apple guide · Practice it in a mock interview · Draft my answer from my resume

How would you define a success metric for a new feature, and what could make it misleading?

From the Apple guide · Practice it in a mock interview · Draft my answer from my resume

A delivery metric dropped in one region last week. How would you investigate before reporting a cause?

From the Tesla guide · Practice it in a mock interview · Draft my answer from my resume

How would you define a metric for whether a new service process is working, and what could make it misleading?

From the Tesla guide · Practice it in a mock interview · Draft my answer from my resume

Payment volume from one merchant segment dropped last week. How would you investigate before reporting a cause?

From the Stripe guide · Practice it in a mock interview · Draft my answer from my resume

How would you define a metric for whether a new checkout feature is working, and what could make it misleading?

From the Stripe guide · Practice it in a mock interview · Draft my answer from my resume

This dataset has something wrong in it. Find it before you answer the question.

From the Stripe guide · Practice it in a mock interview · Draft my answer from my resume

Which of three requested analyses would you run first, and how would you explain the choice?

From the Stripe guide · Practice it in a mock interview · Draft my answer from my resume

A yield metric dropped on one production line last week. How would you investigate before reporting a cause?

From the Intel guide · Practice it in a mock interview · Draft my answer from my resume

How would you define a metric for whether a new internal tool is being adopted, and what could make it misleading?

From the Intel guide · Practice it in a mock interview · Draft my answer from my resume

Which of three requested analyses would you do first, and how would you explain the choice?

From the Intel guide · Practice it in a mock interview · Draft my answer from my resume

What is the difference between an inner join and a left join, and when does the choice change your row count?

Practice it in a mock interview · Draft my answer from my resume

What does HAVING do that WHERE cannot?

Practice it in a mock interview · Draft my answer from my resume

How do NULL values affect a COUNT, a join, and an average?

Practice it in a mock interview · Draft my answer from my resume

Explain p-value to someone who has not studied statistics.

Practice it in a mock interview · Draft my answer from my resume

What is the difference between correlation and causation in a case you have seen?

Practice it in a mock interview · Draft my answer from my resume

When would you use median instead of mean?

Practice it in a mock interview · Draft my answer from my resume

What is a confidence interval telling you?

Practice it in a mock interview · Draft my answer from my resume

How would you check whether an A/B test result is trustworthy?

Practice it in a mock interview · Draft my answer from my resume

What is selection bias, and how might it appear in our data?

Practice it in a mock interview · Draft my answer from my resume

Signups are up but active users are flat. How do you investigate?

Practice it in a mock interview · Draft my answer from my resume

How would you measure whether a new feature is successful?

Practice it in a mock interview · Draft my answer from my resume

Which metric would you put on the executive dashboard, and what would you leave off?

Practice it in a mock interview · Draft my answer from my resume

How would you tell whether a marketing channel is actually working?

Practice it in a mock interview · Draft my answer from my resume

A stakeholder wants a number by end of day and the data is incomplete. What do you deliver?

Practice it in a mock interview · Draft my answer from my resume

How would you define an active user for this product?

Practice it in a mock interview · Draft my answer from my resume

Build a pivot that shows revenue by region and month. What do you check first?

Practice it in a mock interview · Draft my answer from my resume

Which chart would you use for a distribution, and which for a trend?

Practice it in a mock interview · Draft my answer from my resume

You have eight categories and one dominates. How do you present that honestly?

Practice it in a mock interview · Draft my answer from my resume