Data Analyst interview questions & mock practice
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 with OnJob's free AI mock interview and get instant, specific feedback before the real one.
The Data Analyst interview process
SQL, Excel, statistics and storytelling with data — the analyst interview for product, BI and analytics teams across India.
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.
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 your AI mock interview.
- 1. What is the difference between INNER JOIN, LEFT JOIN and FULL OUTER JOIN?
- 2. Write a SQL query to find the second-highest salary in a table.
- 3. What is the difference between WHERE and HAVING?
- 4. Explain window functions like ROW_NUMBER(), RANK() and DENSE_RANK().
- 5. What is the difference between mean, median and mode, and when is each misleading?
- 6. How do you handle missing or null values in a dataset?
- 7. Explain the difference between a primary key and a foreign key.
- 8. What is normalisation, and why does it matter for analysis?
- 9. How would you measure whether a new feature improved user engagement?
- 10. Explain the difference between correlation and causation with an example.
- 11. What is a pivot table and when would you use one?
- 12. How do you decide which chart type to use for a given dataset?
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
- Software Engineer
- Frontend Developer
- Backend Developer
- Full Stack Developer
- Data Scientist
- Product Manager
- DevOps Engineer
- Java Developer
- Python Developer
- UI/UX Designer
- Sales / Business Development
- Digital Marketing
- HR / Recruiter
- Accountant
- Customer Support
- Data Engineer
- Machine Learning Engineer
- QA / Test Engineer
- Android Developer
- iOS Developer
- Business Analyst
- Project Manager
- Scrum Master
- SQL Developer
- React Developer
- Node.js Developer
- Cloud Engineer (AWS)
- Cybersecurity Analyst
- Network Engineer
- Database Administrator
- SEO Specialist
- Content Writer
- Graphic Designer
- Sales Executive
- Business Development Manager
- Operations Manager
- Financial Analyst
- Chartered Accountant
- Customer Success Manager
- Technical Support Engineer
- Civil Engineer
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. Practice all of them with instant AI feedback using OnJob's free mock interview.
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 run a full AI mock interview on OnJob to rehearse out loud and get instant, specific feedback 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 OnJob's Data Analyst mock interview free?
Yes. OnJob's AI mock interview is free to start (₹0) and gives you instant feedback on your answers. Pro (₹99/month) adds unlimited interview-prep AI alongside recruiter tracking and unlimited applications.
Ace your Data Analyst interview
Rehearse every Data Analyst question out loud with OnJob's AI mock interview and get instant, specific feedback. Then apply to AI-matched jobs in one click — free to start.
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.