Mock interview practice

Data Analyst interview questions & mock practice

Practise Data Analyst questions freeCreate my free profile

What interview questions are asked for a Data Analyst?

A Data Analyst interview in 2026 runs across 4 rounds — sql round, excel / spreadsheet round, case / analytics round, tool & viz round. Below are the most-asked Data Analyst interview questions and a focused prep plan. Rehearse every answer out loud with the free timed practice below before the real one.

  • SQL
  • Excel
  • Statistics
  • Power BI
  • Tableau
  • Data Cleaning
  • Python

Free interview practice · Data Analyst

Practise your Data Analyst interview now — free

Step through the 12 most-asked Data Analyst questions one at a time, under a timer, just like the real thing. Jot your answer, then reveal what a strong answer covers. No signup needed to practise.

Interview rounds

The Data Analyst interview process

SQL, Excel, statistics and storytelling with data — the analyst interview for product, BI and analytics teams across India.

1. SQL round

Joins, aggregations, window functions and query writing.

2. Excel / spreadsheet round

Lookups, pivot tables and formulas.

3. Case / analytics round

Business case: define metrics, analyse and recommend.

4. Tool & viz round

Power BI / Tableau dashboards and stakeholder communication.

Most-asked questions

Most-asked Data Analyst interview questions

12 of the questions Data Analyst candidates are asked most often in India. Practise answering each one out loud in the timed practice above.

  1. 1. What is the difference between INNER JOIN, LEFT JOIN and FULL OUTER JOIN?
  2. 2. Write a SQL query to find the second-highest salary in a table.
  3. 3. What is the difference between WHERE and HAVING?
  4. 4. Explain window functions like ROW_NUMBER(), RANK() and DENSE_RANK().
  5. 5. What is the difference between mean, median and mode, and when is each misleading?
  6. 6. How do you handle missing or null values in a dataset?
  7. 7. Explain the difference between a primary key and a foreign key.
  8. 8. What is normalisation, and why does it matter for analysis?
  9. 9. How would you measure whether a new feature improved user engagement?
  10. 10. Explain the difference between correlation and causation with an example.
  11. 11. What is a pivot table and when would you use one?
  12. 12. How do you decide which chart type to use for a given dataset?
How to prepare

How to prepare for your Data Analyst interview

Make SQL second nature: joins, GROUP BY, subqueries, CTEs and window functions — practice on real datasets.

Know core statistics: distributions, central tendency, percentiles, A/B testing and p-values at an intuitive level.

Be ready for a business case: clarify the question, define the metric, then analyse — don't jump to charts.

Build a portfolio dashboard in Power BI or Tableau you can demo and explain.

Practice telling a story with data — the insight and recommendation matter more than the query.

Practise other roles

Interview prep guides

Data Analyst interview — FAQs

What questions are asked in a Data Analyst interview?

Common Data Analyst interview questions include: What is the difference between INNER JOIN, LEFT JOIN and FULL OUTER JOIN? Write a SQL query to find the second-highest salary in a table. What is the difference between WHERE and HAVING? Explain window functions like ROW_NUMBER(), RANK() and DENSE_RANK(). Interviews usually run across 4 rounds — SQL round, Excel / spreadsheet round, Case / analytics round, Tool & viz round. Practise them with the free timed practice on this page.

How many rounds are in a Data Analyst interview?

A typical Data Analyst interview has 4 rounds: SQL round (Joins, aggregations, window functions and query writing.); Excel / spreadsheet round (Lookups, pivot tables and formulas.); Case / analytics round (Business case: define metrics, analyse and recommend.); Tool & viz round (Power BI / Tableau dashboards and stakeholder communication.).

How do I prepare for a Data Analyst interview?

To prepare for a Data Analyst interview: Make SQL second nature: joins, GROUP BY, subqueries, CTEs and window functions — practice on real datasets. Know core statistics: distributions, central tendency, percentiles, A/B testing and p-values at an intuitive level. Be ready for a business case: clarify the question, define the metric, then analyse — don't jump to charts. Then rehearse every question out loud with the timed practice on this page before the real thing.

What skills do I need for a Data Analyst role?

Core Data Analyst skills tested in interviews include SQL, Excel, Statistics, Power BI, Tableau, Data Cleaning, Python. OnJob shows you exactly which of these skills stand between you and a 100% match on every live Data Analyst job.

Is the Data Analyst mock interview practice free?

Yes. The questions, the answer guidance and the timed practice on this page are free and need no signup. With a free OnJob account you can also take timed role tests and free certification tests. Personalised AI role and skill tests are part of the paid plans.

Free practice, no signup to start

Ace your Data Analyst interview

Rehearse every Data Analyst question out loud on this page, then sign in to take a timed role test or a free certification in the OnJob practice hub.

Open the practice hubSee certifications
Explore the full cluster

Everything about Data Analyst on OnJob

Move across the whole Data Analyst topic — live openings, real salary data, the job description, interview prep, and early-career routes — all in one place.