Data Analyst Interview Questions Asked in India (2026)

Data Analyst Interview Questions Asked in India (2026)

Data analyst interview questions in India typically cover practical skills such as Excel, SQL, data visualisation, analytical thinking and business problem-solving. The exact questions depend on the company and role. If you are a fresher, prepare to explain core concepts, solve small problems and discuss your projects clearly, not just memorise definitions.

1. What Excel questions should data analyst freshers prepare for?

Excel questions often test whether you can clean data, summarise information and find patterns. Practise common formulas, Pivot Tables, lookups and ways to handle missing or duplicate records.

Q1. What is the difference between VLOOKUP and XLOOKUP?

Sample answer: VLOOKUP searches for a value in the first column of a range and returns a value from another column. XLOOKUP offers more flexible lookup and return ranges and can search in either direction.

Q2. How would you find duplicate records in Excel?

Sample answer: I would use Conditional Formatting to highlight duplicates or use a formula such as COUNTIF to identify repeated values. Before removing anything, I would confirm which columns define a duplicate and check whether the repeated records are valid.

Q3. What is a Pivot Table used for?

Sample answer: A Pivot Table summarises data without requiring a separate formula for every group. I could use one to compare sales by region, product category or month.


2. What SQL interview questions should you practise?

SQL is an important skill for working with data stored in relational databases. Freshers should understand filtering, aggregation, joins, subqueries and window functions, and be ready to explain why they chose a particular query.

Q4. What is the difference between WHERE and HAVING?

Sample answer: WHERE filters individual rows before grouping. HAVING filters groups after aggregation.

SELECT department, COUNT(*) AS employee_count
FROM employees
WHERE status = 'Active'
GROUP BY departmentHAVING COUNT(*) > 5;

This query counts active employees in each department and returns departments with more than five active employees.

Q5. What is the difference between INNER JOIN and LEFT JOIN?

Sample answer: INNER JOIN returns rows with matching values in both tables. LEFT JOIN returns every row from the left table, along with matching rows from the right; unmatched right-side values appear as NULL.

Q6. How would you find duplicate customer IDs?

Sample answer:

SELECT customer_id, COUNT(*) AS record_count
FROM customers
GROUP BY customer_id
HAVING COUNT(*) > 1;

This identifies customer IDs appearing more than once. I would then check whether the duplicates represent data errors or legitimate multiple records.


3. What Power BI and Tableau questions might come up?

Dashboard questions assess whether you can choose useful visuals, organise data and communicate findings. Prepare to explain data models, KPIs, filters and how you would make a report easier to use.

Q7. What is the difference between a calculated column and a measure in Power BI?

Sample answer: A calculated column creates a value for each row and is stored in the data model. A measure calculates a result based on the current filter context, making it useful for dynamic totals and KPIs.

Q8. How would you design a sales dashboard?

Sample answer: I would first clarify the audience and business questions. Then I would choose relevant KPIs, such as sales and profitability, add appropriate time or category comparisons, and use filters that help users explore the results. I would validate the figures against the source data before sharing the dashboard.


4. What Python questions should beginners know?

Python questions vary by role. For entry-level preparation, focus on basic data structures, data cleaning and how Pandas can support analysis.

Q9. What is Pandas used for?

Sample answer: Pandas is a Python library used to work with structured data. It provides tools for loading datasets, filtering rows, handling missing values, grouping records and analysing results.

Q10. How would you handle missing values in a dataset?

Sample answer: I would first measure how many values are missing and check whether the missingness follows a pattern. Depending on the context, I might remove affected rows, fill values using an appropriate method or flag the missing data. I would document the decision because filling values can affect the analysis.


5. What business case questions should you prepare for?

Case questions test how you approach an unfamiliar problem. Interviewers may care as much about your reasoning and clarifying questions as the final answer.

Q11. Sales dropped by 15% this month. How would you investigate?

Sample answer: I would confirm how sales are measured and compare the period with an appropriate baseline. Then I would break the data down by product, region, channel and time to locate where the decline occurred. I would investigate possible explanations, validate the data and present evidence before recommending an action.

Q12. A business reports high customer churn. What would you analyse?

Sample answer: I would define churn and the period being measured first. Then I would compare churn across customer cohorts, tenure, product usage and other available segments. I would check whether particular patterns appear consistently and explain which additional information might be needed before recommending retention measures.


6. How should you prepare for a data analyst interview?

Use a simple preparation checklist rather than memorising dozens of answers.

1. Practise the basics: Solve SQL problems and Excel exercises without looking at the solution first.
2. Explain your projects: Be ready to discuss the business question, data cleaning, analysis, findings and limitations.
3. Validate your work: Check calculations, query results and dashboard figures.
4. Practise speaking clearly: Explain why you chose an approach, not just what tool you used.
5. Use GenAI carefully: It can help you practise or review queries, but verify every answer and make sure you understand the logic.

For project-based questions, use examples you have actually completed. Do not claim experience with tools or tasks you have not used.


Final takeaway

Data analyst interviews can test technical knowledge, practical problem-solving and communication. For freshers, a strong preparation plan combines SQL and Excel practice, dashboard concepts, basic Python, business cases and a clear explanation of personal projects.

If you want guided practice with projects and interview preparation, explore the QUAT Data Analyst Fellowship Program with GenAI at quat.one or contact the QUAT team on WhatsApp at +91 81784 09601.

Scroll to Top