Data Analyst Interview Questions and Answers (2026 Guide)
You have the certificate and a few projects, and then the interview email lands. The panic sets in. Which questions will they ask? Will they hand you a SQL query on the spot? Is your Excel good enough? Most candidates lose the offer not because they lack skill, but because they walk in unprepared for how the questions are framed.
This guide fixes that. Below are the data analyst interview questions that come up most often across product companies, IT firms, and startups, grouped by skill, with short answers you can actually use. Work through them and you will know what to expect, where you are weak, and how to talk about your work like an analyst who already has the job.
Most data analyst interviews run across three to five rounds. Knowing the shape of each round tells you what to prepare and stops surprises.
- Screening call. Recruiter checks your resume, tools, notice period, and expectations. Keep answers tight.
- Technical round. Live SQL and Excel questions, sometimes Python. This is where most candidates get filtered.
- Take-home or case study. A dataset or a business problem to analyse and present. They judge your thinking, not just the answer.
- Behavioural round. How you handle stakeholders, deadlines, and mistakes. Structure matters here.
- Final or panel round. A mix of the above with the hiring manager or team lead.
The bulk of the technical weight sits on SQL, so start there.
SQL Interview Questions for Data Analysts
SQL is the single most tested skill in a data analyst interview. Expect questions from basic filtering to window functions. These cover the range.
Basic SQL Questions
1. What is the difference between WHERE and HAVING?
WHERE filters individual rows before grouping. HAVING filters groups after aggregation, so you use it with GROUP BY and functions like COUNT or SUM.
2. Explain the main types of JOIN.
INNER JOIN returns rows that match in both tables. LEFT JOIN returns every row from the left table plus matches from the right. RIGHT JOIN does the reverse. FULL OUTER JOIN returns everything from both, with NULLs where there is no match.
3. What is the difference between UNION and UNION ALL?
UNION combines results and removes duplicate rows. UNION ALL keeps every row, duplicates included, and runs faster because it skips the de-duplication step.
4. How do DELETE, TRUNCATE, and DROP differ?
DELETE removes selected rows and can be rolled back. TRUNCATE clears all rows quickly and resets the table. DROP removes the entire table, structure and all.
Intermediate and Advanced SQL Questions
5. How do you find the second highest salary in a table?
Use a window function with DENSE_RANK, or a subquery: SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees).
6. What is a window function?
A window function runs a calculation across a set of rows tied to the current row, without collapsing them into one. Common ones are ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, and running totals with SUM() OVER().
7. How do you find duplicate records in a table?
Group by the columns that define a duplicate and filter the groups: GROUP BY name, email HAVING COUNT(*) > 1.
8. What is the difference between RANK, DENSE_RANK, and ROW_NUMBER?
ROW_NUMBER gives every row a unique number. RANK leaves gaps after ties, so two first places jump to rank three. DENSE_RANK ranks ties equally with no gap.
9. What is a CTE and when do you use it?
A Common Table Expression is a temporary named result set defined with WITH. It makes long queries readable and supports recursive logic like org hierarchies.
10. What is the difference between a primary key and a foreign key?
A primary key uniquely identifies each row and cannot be NULL. A foreign key points to a primary key in another table to link the two and protect data integrity.
Struggling to write queries under pressure? The Data Analytics course at GrowthIntelliLabs drills real SQL on live datasets and includes mock technical rounds. Explore the Data Analytics course or book a free demo.
Excel Interview Questions
Even data-heavy roles test Excel, because it is where quick analysis and stakeholder reports still live.
11. What is the difference between VLOOKUP, INDEX-MATCH, and XLOOKUP?
VLOOKUP searches left to right only and breaks when columns move. INDEX-MATCH looks in any direction and survives column changes. XLOOKUP replaces both with cleaner syntax and a built-in value for no match.
12. What is a pivot table used for?
A pivot table summarises large datasets into grouped counts, sums, and averages with no formulas, and lets you drag rows and columns to spot patterns fast.
13. What is the difference between COUNT, COUNTA, and COUNTIF?
COUNT counts cells with numbers. COUNTA counts all non-empty cells. COUNTIF counts cells that meet one condition.
14. How do you remove duplicate values in Excel?
Use Data, then Remove Duplicates for a one-time clean, or the UNIQUE function when you want a live list that updates.
Python and Pandas Interview Questions
Product and analytics-led companies increasingly expect basic Python. You do not need to be an engineer, but you do need Pandas.
15. What is the difference between loc and iloc in Pandas?
loc selects data by label, such as a column name or index value. iloc selects by integer position, like the third row.
16. How do you handle missing values in Pandas?
Find them with isnull(). Then drop them with dropna(), or fill them with fillna() using the mean, median, mode, or a fixed value, depending on the column.
17. What is the difference between merge, join, and concat?
merge combines DataFrames on key columns, like a SQL join. join combines on the index. concat stacks DataFrames on top of each other or side by side.
18. What is a list comprehension?
A compact way to build a list in one line, for example [x * 2 for x in numbers if x > 0]. It is faster to write and read than a full loop.
Statistics and Probability Interview Questions
Statistics questions separate people who run tools from people who understand data. Get the fundamentals right.
19. When do you use the mean, median, or mode?
Use the mean for symmetric data. Use the median when outliers skew the data, such as salary or house price. Use the mode for the most common category.
20. What is a p-value?
The p-value is the probability of seeing your result, or one more extreme, if the null hypothesis were true. A value below 0.05 usually counts as statistically significant.
21. What is the difference between a Type I and a Type II error?
A Type I error is a false positive, where you reject a true null hypothesis. A Type II error is a false negative, where you fail to reject a false null hypothesis.
22. What is the difference between correlation and causation?
Correlation means two variables move together. Causation means one causes the other. A strong correlation never proves cause on its own.
23. What is the Central Limit Theorem?
As sample size grows, the distribution of sample means approaches a normal curve, whatever the shape of the population. It is why so many statistical tests work.
Data Visualization Interview Questions (Power BI and Tableau)
Dashboards are how your work reaches decision-makers, so expect questions on tools and on judgement.
24. When do you use a bar chart versus a line chart?
Use a bar chart to compare values across categories. Use a line chart to show a trend over time.
25. What makes a good dashboard?
One clear purpose, the key metric placed first, little clutter, consistent colours, and enough context that each number means something to the viewer.
26. What is the difference between a measure and a dimension?
A dimension is a category you group by, such as region or month. A measure is a number you aggregate, such as revenue or order count.
Behavioural and Situational Interview Questions
These decide whether the team wants to work with you. Answer with the STAR method: Situation, Task, Action, Result.
27. Tell me about a time you found an insight in data.
Pick one real example. Name the business problem, what you did, and the metric you moved. End with the number, not the method.
28. How do you explain technical findings to non-technical stakeholders?
Lead with the decision or number they care about, skip the technical steps, show one clear visual, and tie the finding to money or time saved.
29. Three people want reports from you at once. How do you prioritise?
Rank by business impact and deadline, confirm the real scope of each request, and communicate timelines early so nobody is left guessing.
30. Describe a time your analysis was wrong.
Show that you caught the error, owned it, and fixed the process so it would not happen again. Honesty here reads as maturity.
Case Study and Analytical Thinking Questions
Case questions have no single right answer. Interviewers want to hear a structured approach out loud.
31. Sales dropped 20 percent last quarter. How would you investigate?
First rule out data errors. Then segment by region, product, channel, and time to find where the drop sits. Compare against seasonality and outside factors. Isolate the main driver, then quantify its impact.
32. How would you measure the success of a new product feature?
Define the goal, choose one primary metric, set a baseline, run an A/B test if possible, and watch guardrail metrics so a win in one place is not a loss somewhere else.
Data Analyst Interview Questions for Freshers
With no work history, freshers get judged on fundamentals, learning ability, and projects. Expect these.
33. Why do you want to become a data analyst?
Connect a genuine interest in problem-solving with the field. Mention a project or a course that hooked you, and where you want to grow.
34. Which tools have you learned so far?
Name what you can actually use: SQL, Excel, Python or R, and one BI tool such as Power BI or Tableau. Do not list tools you have only heard of.
35. Walk me through a project you have built.
Cover the problem, the data source, how you cleaned it, your analysis, the insight, and one thing you would improve next time. This single answer can carry a fresher interview.
Common Mistakes to Avoid
These are the errors that cost strong candidates the offer.
- Memorising answers. Interviewers change one number and the memorised answer falls apart. Understand the concept instead.
- Giving only the technical answer. A query with no business point misses what the role is about. Always link back to the decision.
- Showing up with no projects. Two or three real projects beat any certificate. Build them before you apply.
- Overcomplicating simple SQL. If a straight GROUP BY solves it, do not reach for a nested subquery to look clever.
- Not asking questions in case rounds. Jumping straight to an answer signals weak thinking. Clarify scope first.
- Burying the insight. If the interviewer has to dig for your point, you failed the communication test. Say it first.
- Skipping mock interviews. Nerves, not knowledge, sink most people. Practise out loud before the real thing.
Your Data Analyst Interview Prep Checklist
Run through this before any interview. If you can tick every box, you are ready.
- SQL: joins, aggregations, subqueries, window functions, and finding duplicates
- Excel: lookups, pivot tables, and conditional functions
- One language: comfortable with Python and Pandas, or R
- One BI tool: a working dashboard in Power BI or Tableau
- Statistics: mean vs median, p-value, hypothesis testing, and correlation vs causation
- Portfolio: two or three finished projects you can explain end to end
- STAR stories: three behavioural examples ready to tell
- Research: the company, the role, and the tools they list in the job post
Mock interview: at least one full practice run out loud
Frequently Asked Questions
Start with SQL, since it carries the most weight, then Excel, statistics, and one BI tool. Build two or three portfolio projects, prepare STAR stories for behavioural questions, and finish with a full mock interview out loud. Four to six weeks of focused practice is enough for most freshers.
The most common ones test SQL joins and window functions, Excel lookups and pivot tables, the difference between correlation and causation, and a case study such as investigating a drop in sales. Behavioural questions on stakeholder communication come up in almost every interview.
SQL is the core skill and clears most first rounds, but it is rarely enough on its own. You also need Excel, a grasp of statistics, and one visualisation tool. Employers hire people who can query data and then explain what it means.
With daily practice, most freshers need four to six weeks to cover SQL, Excel, statistics, and a BI tool, plus time to build projects. Experienced candidates switching roles usually need two to three weeks of revision and mock interviews.
Yes, most include live SQL, and many now add basic Python or Pandas. You are not expected to code like a software engineer, but you must query, clean, and analyse data without hand-holding.
Freshers should focus on strong fundamentals and real projects. Master SQL and Excel first, learn to explain your project clearly, and prepare for questions on why you chose data analytics and how you learn new tools.
Final Thoughts
A data analyst interview is not a memory test. It checks whether you can pull the right data, read it correctly, and explain it to someone who will act on it. Work through the questions above, find your weak spots, and close them one by one. The candidates who get offers are the ones who practised talking through their thinking, not just the ones who knew the answers.
If you want structure instead of scattered YouTube videos, that is exactly what a guided programme gives you. The Data Analytics course at GrowthIntelliLabs in Hyderabad covers SQL, Python, Power BI, statistics, and full interview preparation with real datasets and one-on-one mock rounds, so you walk in ready.