Data analyst interview questions for India

LiveRec EditorialUpdated

Data analyst interview questions in India typically cover SQL, Excel, a scripting tool such as Python, data cleaning and how you explain findings to non-technical people. Expect a small case or test. Show your method first, then the answer, and be ready to discuss a real dataset you analyzed.

At a glance

  • Practice SQL joins, grouping and filtering.
  • Prepare one project with a clear business question.
  • Explain the method before the result.
  • Say how you check data quality.

What should you know about the role before the interview?

The pandas documentation describes a Series as a one-dimensional labeled array and a DataFrame as a two-dimensional table of rows and columns, describes group by as splitting, applying and combining, and notes that merge enables SQL-style joins; dropna removes rows with missing data and fillna fills them (pandas user guide, accessed 31 October 2026).

What data analyst interview questions will you be asked?

1. "What is the difference between INNER JOIN and LEFT JOIN?" SQL basics.

Sample answer: "INNER JOIN returns only matching rows from both tables. LEFT JOIN keeps all rows from the left table and shows nulls where the right has no match."

2. "How do you handle missing data?" Judgment about data quality.

Sample answer: "First I check how much is missing and why. Depending on the case I drop rows, fill with a sensible value, or flag it, and I note the choice in my report."

3. "What is the difference between a Series and a DataFrame in pandas?" Tool fluency.

Sample answer: "A Series is a one-dimensional labeled array, and a DataFrame is a two-dimensional table. Selecting one column from a DataFrame gives a Series."

4. "How would you find the top five products by sales?" Turning a question into a query.

Sample answer: "I would group by product, sum sales, sort in descending order and limit to five, in SQL or with groupby in pandas."

5. "What does GROUP BY do?" Aggregation concepts.

Sample answer: "It splits rows into groups by a column, then applies an aggregate such as sum or count to each group, giving one result per group."

6. "How do you check if a dataset is reliable?" Data quality habits.

Sample answer: "I look for duplicates, nulls, odd ranges and mismatched formats, compare totals with a known source, and ask the data owner about anything strange."

7. "Which Excel functions do you use most?" Practical spreadsheet skill.

Sample answer: "VLOOKUP or XLOOKUP, SUMIFS, pivot tables and conditional formatting. I use pivots first for quick exploration, then build charts."

8. "How would you explain findings to a non-technical manager?" Communication.

Sample answer: "I start with the answer and its impact, show one simple chart, mention the main assumption, and offer the details if they want them."

9. "Describe a project where your analysis changed a decision." Impact, not just tools.

Sample answer: "In a college project I found that most returns came from one product size. I suggested a revised size chart, and the sample test showed fewer returns."

10. "What is a KPI, and how do you choose one?" Business thinking.

Sample answer: "A KPI is a measurable value tied to a goal. I choose one that is clear, measurable and linked to the decision the team needs to make."

How should you prepare?

Practice ten SQL queries on a sample database, and one end-to-end analysis on a public dataset. Prepare a three-minute story with the question, data, method and result. For the general round see fresher interview questions. A broader general guide is data analyst interview questions and answers.

What should you ask the interviewer?

  • What tools and databases does the team use?
  • How do analysts work with business teams?
  • What does success look like in six months?
  • Is there mentoring for new analysts?

Frequently asked questions

Will there be a coding test? Often yes, in SQL or Python. Ask the recruiter which formats to expect.

What if I lack work experience? Use personal or academic projects with real data and clear findings.

See data analyst interview questions and answers, data analyst career guide in India, behavioral questions and the STAR method, fresher interview questions.

By LiveRec Editorial. Read our editorial standards.