# 35+ Data Analyst Interview Questions & Answers (2026 Guide)

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/blog/top-data-analyst-interview-questions
Source observed: 2026-11-05T00:08:46.696Z
Last checked: 2026-11-05T00:08:46.696+00:00
Indexed: 2026-11-06T19:43:42.779+00:00

---

# 35+ Data Analyst Interview Questions & Answers (2026 Guide)

We created this guide to help candidates prepare for data analyst interviews. Our focus is the combination of SQL fluency, structured analytical thinking, statistics literacy, and the ability to turn data into a clear recommendation. The questions are drawn from interviews at Meta, Google, Amazon, Uber, and other companies.

Our guide was written by [Celine Liu](https://www.aced.io/coach/Celine-Liu?ref=exponent-blog.ghost.io), Uber's former Global Analytics Lead. She has conducted more than 100 interviews across analytics, operations, and strategic roles. Browse more [verified data analyst interview experiences](https://www.aced.io/experiences?role=data-analyst&ref=exponent-blog.ghost.io).

## The five question categories

1. [SQL and coding questions](https://www.aced.io/blog/top-data-analyst-interview-questions#sql-and-coding-questions)
2. [Data analysis and business case questions](https://www.aced.io/blog/top-data-analyst-interview-questions#data-analysis-and-business-case-questions)
3. [Behavioral questions](https://www.aced.io/blog/top-data-analyst-interview-questions#behavioral-questions)
4. [Statistics and experimentation questions](https://www.aced.io/blog/top-data-analyst-interview-questions#statistics-and-experimentation-questions)
5. [Excel and visualization questions](https://www.aced.io/blog/top-data-analyst-interview-questions#excel-and-visualization-questions)

Browse the full [data analyst question bank](https://www.aced.io/questions?role=data-analyst&ref=exponent-blog.ghost.io).

## Top data analyst interview questions

1. Write a query to find employees who earn more than their manager. [See 76 answers](https://www.aced.io/questions/3960/employee-earnings?ref=exponent-blog.ghost.io).
2. Facebook's daily post views have dropped 10%. How would you investigate? [See 6 answers](https://www.aced.io/questions/4352/investigate-sudden-viewer-drop?ref=exponent-blog.ghost.io).
3. Tell me about a time you made a mistake. [See 107 answers](https://www.aced.io/questions/240/mistake?ref=exponent-blog.ghost.io).
4. Find the number of users who called three or more people last week. [See 13 answers](https://www.aced.io/questions/4167/count-users-calls-last-week?ref=exponent-blog.ghost.io).
5. What is the market size for driverless cars in 2025? [See 18 answers](https://www.aced.io/questions/866/market-size-driverless-cars-2025?ref=exponent-blog.ghost.io).
6. Tell me about a time the business problem was not clearly defined. [See 5 answers](https://www.aced.io/questions/5266/handling-vague-business-problems?ref=exponent-blog.ghost.io).
7. Find the top three posts by likes where likes are at least 100. [See 47 answers](https://www.aced.io/questions/3049/instagram-likes?ref=exponent-blog.ghost.io).
8. Tell me about yourself. [See 126 answers](https://www.aced.io/questions/104/tell-me-about-yourself?ref=exponent-blog.ghost.io).
9. Find the top salaries in each department. [See 35 answers](https://www.aced.io/questions/3045/top-salaries-by-department?ref=exponent-blog.ghost.io).
10. How would you convey insights and methods to a nontechnical audience? [See answers](https://www.aced.io/questions/5521/convey-insights-and-methods-to-non-technical-audience?ref=exponent-blog.ghost.io).

## SQL and coding questions

SQL is the most-tested data analyst skill. Interviews can cover JOINs, GROUP BY and aggregations, window functions, common table expressions, query debugging, NULL handling, duplicates, date gaps, and production readability. Common prompts include:

1. **Find employees who earn more than their manager.** [76 community answers](https://www.aced.io/questions/3960/employee-earnings?ref=exponent-blog.ghost.io). Asked at multiple companies; IDE question; medium difficulty.
2. **Find users who called at least three people in the last week.** [13 community answers](https://www.aced.io/questions/4167/count-users-calls-last-week?ref=exponent-blog.ghost.io). Asked at Meta.
3. **Find the top three users by number of posts with at least 100 likes.** [47 community answers](https://www.aced.io/questions/3049/instagram-likes?ref=exponent-blog.ghost.io). IDE question; medium difficulty.
4. **Find the top salaries in each department.** [35 community answers](https://www.aced.io/questions/3045/top-salaries-by-department?ref=exponent-blog.ghost.io). Asked at Tesla; IDE question; hard difficulty.
5. **Calculate monthly post success rate by user type.** [36 community answers](https://www.aced.io/questions/3955/monthly-post-success-analysis?ref=exponent-blog.ghost.io). Asked at LinkedIn; IDE question; easy difficulty.
6. **Find the top three employees by salary.** [68 community answers](https://www.aced.io/questions/3044/top-earning-employees?ref=exponent-blog.ghost.io). IDE question; easy difficulty.
7. **Explain stored procedures, when to use them, and how they differ from functions.** [4 community answers](https://www.aced.io/questions/3980/sql-stored-procedures?ref=exponent-blog.ghost.io).
8. Explain the difference between `WHERE` and `HAVING`.
9. Calculate a rolling seven-day average of daily active users.
10. Deduplicate a table with no unique key.

### Sample answer: employees who earn more than their manager

This is sample SQL from a community answer:

```sql
SELECT e.firstname AS firstname, m.salary AS manager_salary
FROM employees e
JOIN employees m ON e.manager_id = m.id
WHERE e.salary > m.salary;
```

This is a self-join: the `employees` table references itself through `manager_id`. Explain the table relationship and join logic before writing the query.

### Sample answer: rolling seven-day DAU average

```sql
SELECT date, dau,
       AVG(dau) OVER (
         ORDER BY date
         ROWS BETWEEN 6 PRECEDING AND CURRENT ROW
       ) AS rolling_7d_avg
FROM daily_metrics;
```

`ROWS BETWEEN 6 PRECEDING AND CURRENT ROW` includes seven rows, including today. If dates have gaps, the calculation silently uses fewer calendar days. Flag the issue and suggest filling date gaps first or using a `RANGE`-based window.

### SQL interview tips

- Talk before typing. Explain that you are going to break the problem down.
- Ask clarifying questions about the time range, revenue definition, duplicates, and other assumptions.
- Check NULLs, duplicates, and date gaps.
- Connect the query output to its business meaning, not only its syntax.

Practice with our [data analyst SQL question bank](https://www.aced.io/questions?role=data-analyst&type=sql&filterBy=codeEditor&ref=exponent-blog.ghost.io).

## Data analysis and business case questions

These questions test whether you can structure an ambiguous problem and reach a clear recommendation. The interview evaluates your reasoning rather than one predetermined answer.

11. Investigate a sudden 10% drop in Facebook daily post views. [6 community answers](https://www.aced.io/questions/4352/investigate-sudden-viewer-drop?ref=exponent-blog.ghost.io). Asked at Meta.
12. Estimate the 2025 market size for driverless cars. [18 community answers](https://www.aced.io/questions/866/market-size-driverless-cars-2025?ref=exponent-blog.ghost.io). Asked at Google.
13. Convey insights and methods to a nontechnical audience. [Answers](https://www.aced.io/questions/5521/convey-insights-and-methods-to-non-technical-audience?ref=exponent-blog.ghost.io). Asked at IBM.
14. Investigate a 25% sales decline last month.
15. Choose metrics for evaluating a new feature launch.
16. Reconcile dashboard numbers that do not match finance's report.
17. Use cohort analysis to identify retention issues.

### Sample answer: 10% drop in Facebook daily post views

A strong approach is to:

- Define how daily post views are calculated.
- Rule out data and tracking problems.
- Isolate the issue by time period, geography, and platform, including iOS, Android, and web.
- Check correlated funnel metrics such as DAU, time spent or scrolls, likes, and comments.
- Consider external factors such as competitors and major events.
- Consider internal factors such as a product launch or feature change.

This structure distinguishes fewer users from fewer views per user and systematically separates possible causes.

### Sample answer: driverless-car market sizing

Start by clarifying scope: US or global, consumer or commercial, and whether the technology is assumed to be production-ready by 2025. Then state assumptions explicitly and build the estimate from population to driving-age adults, car ownership, replacement rate, and willingness to pay an autonomous-vehicle premium.

### Business-case tips

Use our PACE framework:

- **Plan:** Ask clarifying questions and scope the time range, metric, and business context.
- **Analyze:** Use funnel analysis, cohort breakdowns, and segmentation; work from broad to narrow.
- **Construct:** Synthesize one or two clear insights and lead with the “so what.”
- **Execute:** Recommend specific next steps tied to impact and feasibility.

Segment by region, product, channel, and cohort before diagnosing a root cause. Practice with our [data analyst question bank](https://www.aced.io/questions?role=data-analyst&ref=exponent-blog.ghost.io).

## Behavioral questions

Behavioral interviews evaluate communication, cross-functional collaboration, ownership, and learning from mistakes.

18. **Tell me about a time you made a mistake.** [107 community answers](https://www.aced.io/questions/240/mistake?ref=exponent-blog.ghost.io). Asked at Airbnb, Amazon, American Express, and 12+ more companies.
19. **Tell me about yourself.** [126 community answers](https://www.aced.io/questions/104/tell-me-about-yourself?ref=exponent-blog.ghost.io). Asked at Accenture, Amazon, Airbnb, and 33+ more companies.
20. **Tell me about a time you solved a complex problem.** [28 community answers](https://www.aced.io/questions/107/tell-me-about-time-solved-complex-problem?ref=exponent-blog.ghost.io). Asked at Amazon, GitHub, and 7+ more companies.
21. **Tell me about a time the business problem was unclear.** [5 community answers](https://www.aced.io/questions/5266/handling-vague-business-problems?ref=exponent-blog.ghost.io). Asked at Anthropic and Uber.
22. **Tell me about a decision you made under substantial uncertainty.** [2 community answers](https://www.aced.io/questions/5265/making-a-decision-with-a-lot-of-uncertainty?ref=exponent-blog.ghost.io). Asked at Tinder.
23. **How do you prioritize tasks?** [70 community answers](https://www.aced.io/questions/228/how-prioritize-features?ref=exponent-blog.ghost.io). Asked at Accenture, Adobe, Amazon, and 13+ more companies.
24. **How would you learn an unfamiliar task?** [2 community answers](https://www.aced.io/questions/5046/approach-learning-unfamiliar-task?ref=exponent-blog.ghost.io). Asked at Apple.
25. **Tell me about your past projects.** [4 community answers](https://www.aced.io/questions/4229/past-projects?ref=exponent-blog.ghost.io). Asked at Accenture, Amazon, and 17+ more companies.

### Sample behavioral answer

This is sample data adapted from community answers:

> Early in my career, I built a churn model that predicted high-risk users based on login frequency. The model looked great on paper, but when we acted on it, the intervention did not move retention. I investigated and found correlation without causation: users were not churning because they stopped logging in; they stopped logging in because they had already decided to leave. Failed transactions and support tickets were better leading indicators. I learned to validate assumptions with a small test before scaling and to examine the causal story behind the data.

The example demonstrates vulnerability, a specific technical mistake, reflection, and a concrete change in behavior.

### Behavioral interview tips

Use STAR:

- **Situation:** Set context briefly.
- **Task:** Explain your responsibility.
- **Action:** Describe what you did; spend most of the answer here.
- **Result:** Quantify the impact when possible.

Prepare five to seven adaptable experiences, know your resume in detail, own mistakes, and explain what you learned and now do differently. Our [behavioral interview framework](https://www.aced.io/courses/data-analytics-behavioral/star-framework?ref=exponent-blog.ghost.io) provides additional practice.

## Statistics and experimentation questions

You need working knowledge of hypothesis testing, confidence intervals, and A/B testing, particularly for product analytics roles.

26. Interpret a p-value of 0.04 in an A/B test and decide whether to ship.
27. Determine the required sample size for an experiment.
28. Distinguish Type I and Type II errors and discuss which is worse.
29. Handle an improved metric when a novelty effect is suspected.
30. Choose between a t-test and a chi-squared test.

### Sample answer: A/B test with p-value 0.04

A p-value of 0.04 means there is a 4% probability of seeing a difference at least this large if there were no real effect, so it meets the conventional 0.05 threshold. That alone is not enough to ship. Check effect size, confidence interval, practical value, engineering cost, test duration, planned sample size, metric trends over time, novelty effects, and the segments that matter.

Statistical significance is necessary but not sufficient for a business decision. Review our [statistics and experimentation module](https://www.aced.io/courses/data-analytics/data-analytics-technical/how-statistics-and-experimentation-are-tested?ref=exponent-blog.ghost.io).

## Excel and visualization questions

Spreadsheets are the second most-tested skill after SQL. Visualization questions assess chart selection, audience-aware design, and the ability to defend design choices.

31. Choose INDEX-MATCH or VLOOKUP for a situation.
32. Build a pivot table summarizing customer data by region and product.
33. Redesign a cluttered executive dashboard.
34. Select a chart for user retention over 12 months.
35. Visualize A/B-test results for a nontechnical stakeholder.

### Sample answer: INDEX-MATCH versus VLOOKUP

INDEX-MATCH can look up values to the left of the key column, continues to reference columns directly when columns are inserted or deleted, and can be faster on large datasets. VLOOKUP remains suitable for a quick, simple, one-off analysis. Choose based on context. Build these skills with our [Excel and Google Sheets module](https://www.aced.io/courses/data-analytics/data-analytics-technical/essential-excel-and-google-sheets-skills?ref=exponent-blog.ghost.io).

## Data analyst interview frameworks

### PACE framework for business cases

| Step | What to do |
|---|---|
| P — Plan | Ask clarifying questions. Scope the time range, metric, and business context. |
| A — Analyze | Use funnel analysis, cohort breakdowns, and segmentation. Work from broad to narrow. |
| C — Construct | Synthesize one or two clear insights. Lead with the “so what,” not the methodology. |
| E — Execute | Recommend specific next steps tied to business impact and feasibility. |

Learn the [PACE framework](https://www.aced.io/courses/data-analytics/analytical-problem-solving/pace-framework?ref=exponent-blog.ghost.io).

### STAR framework for behavioral questions

| Step | What to do |
|---|---|
| S — Situation | Set context briefly in one or two sentences. |
| T — Task | Explain your specific responsibility. |
| A — Action | Describe what you did; this should be most of the answer. |
| R — Result | Quantify the impact when possible. |

## Practice resources

- [Practice data analyst questions](https://www.aced.io/questions?role=data-analyst&ref=exponent-blog.ghost.io): browse 123 questions from interviews at Meta, Google, Amazon, and other companies, with community answers.
- [Take the data analytics interview course](https://www.aced.io/courses/data-analytics?ref=exponent-blog.ghost.io): structured preparation for SQL, business cases, take-home studies, and behavioral rounds.
- [Start a mock interview](https://www.aced.io/practice?ref=exponent-blog.ghost.io): timed practice with peers or coaches who provide feedback.

## FAQ

### How long does a data analyst interview loop take?

Most loops take two to four weeks from recruiter screen to final decision. Expect four to five rounds: recruiter call, technical SQL screen, business case, hiring manager interview, and behavioral round. Some companies, including Uber and Shopify, add a take-home case study. See our [data analyst interview prep guide](https://www.aced.io/blog/data-analyst-interview-guide?ref=exponent-blog.ghost.io).

### What SQL topics are tested most?

JOINs, GROUP BY aggregations, window functions such as RANK, ROW_NUMBER, and LAG/LEAD, subqueries, and CTEs cover most questions. Senior candidates should also expect query optimization, NULL handling, and production readability. Use our [SQL question bank](https://www.aced.io/questions?role=data-analyst&type=sql&filterBy=codeEditor&ref=exponent-blog.ghost.io).

### Do I need Python?

Only when the job description lists it. Then expect basic pandas, including groupby operations, dataframe merging, and simple data cleaning. SQL is tested broadly; Python is role-dependent.

### How do analyst and data scientist interviews differ?

Data analyst interviews emphasize SQL, business-case reasoning, dashboards, and communication. Data science interviews go deeper into statistics, machine learning, experimental design, and usually Python or R. SQL and A/B testing overlap.

### How should I prepare for a take-home case study?

Treat it as a work deliverable. State assumptions, link formulas to source data rather than pasting raw values, lead with insights, and prepare a five-minute executive summary. Use our [take-home case study module](https://www.aced.io/courses/data-analytics/data-analytics-take-home-case-studies/take-home-case-study-walkthrough?ref=exponent-blog.ghost.io).

## More ways to prepare

- [Browse data analyst interview questions](https://www.aced.io/questions?role=data-analyst&src=blog)
- [Book time with a Data Analyst coach](https://www.aced.io/coaching?role=data-analyst): mock interviews, career coaching, and resume review. [Browse coaches](https://www.aced.io/coaching?role=data-analyst&src=blog).
- [Create a free Aced account](https://www.aced.io/signup?src=blog). Aced, formerly Exponent, provides interview guides, insider tips, and courses.

### Related courses

- [Data Analyst Interview Prep Course](https://www.aced.io/courses/data-analytics) — six courses and 1,000 students. Covers product, marketing, and business analyst interviews, take-home case studies, technical and dashboarding skills, and strategies from interviewers at technology companies and startups. [Course image](https://images.ctfassets.net/x78yjrjc11pq/72OTqij57b2TklhaD2vrdV/be0dae6242904970d1696e5a4d858e18/AdobeStock_1357126576.jpeg?w=800&h=800)
- [Behavioral Questions for Data Analysts](https://www.aced.io/courses/data-analytics-behavioral) — 13 lessons and 100 students. Covers interviewer expectations, STAR, the Triangle Method, story banks, and expert examples.

### Related blog posts

- [What is a Data Analyst? Role and Career Insights](https://www.aced.io/blog/what-is-a-data-analyst)
- [Data Analyst Interview Prep (2026 Guide)](https://www.aced.io/blog/data-analyst-interview-guide)
- [Data Analyst Resume Guide and Templates](https://www.aced.io/blog/data-analyst-resume)
- [Data Scientist vs. Data Analyst: Key Differences and Career Insights](https://www.aced.io/blog/data-scientist-vs-data-analyst)

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fblog%2Ftop-data-analyst-interview-questions&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fblog%2Ftop-data-analyst-interview-questions). Opening a form does not execute a tool.