← Blog
INTERVIEW PREP — INDIA 2026

Data Analyst Interview Preparation India 2026
Complete Guide to Clear Every Round

What does a data analyst interview actually look like in India in 2026? This guide covers every round — SQL test, Excel practical, Power BI case study, and HR — with what is asked, how to answer it, and a four-week preparation plan that has you ready for all of it.

Interview Rounds4-Week PlanBehavioural Q&APortfolio TipsFAQs

The 5 Interview Rounds — What Happens in Each

Not every company runs all 5 — small companies often combine rounds 2 and 3.

Round 1 — HR Screening
15–30 minPhone or video call
Commonly asked
  • Walk me through your background
  • Why data analytics?
  • What tools do you know?
  • Notice period / availability
  • Salary expectations
Prep tip: Prepare a 90-second introduction: current role → what you learned → why analytics → tools you know → what you are looking for. Keep it confident and concise.
Round 2 — SQL Technical Test
30–60 minOnline (HackerRank / Google Colab) or screen share
Commonly asked
  • Write a query to find customers who never ordered
  • Find the second highest salary
  • Top 3 products per category
  • Month-over-month revenue change using LAG
  • Duplicates with ROW_NUMBER
Prep tip: Practise writing queries from scratch in a blank editor — not autocomplete. Time yourself: 10 min per question. If stuck, write a partial query and explain your thinking aloud.
Round 3 — Excel / Power BI Practical
30–60 minYou are given a file and asked to do something with it
Commonly asked
  • Build a pivot table summarising sales by region and category
  • Create a dashboard with 3 KPI cards and a trend line
  • Use XLOOKUP to bring in product names from a lookup table
  • Identify anomalies in the dataset
  • Write a DAX measure for month-to-date sales
Prep tip: Speed matters here. Practise building a complete Power BI dashboard from a raw CSV in under 30 minutes — data load, relationships, 3 visuals, basic DAX. Know keyboard shortcuts in Excel.
Round 4 — Case Study / Presentation
45–90 min (sometimes overnight)You receive a dataset — analyse it and present findings
Commonly asked
  • Here is 6 months of sales data — what are the key insights?
  • Customer churn analysis — what is driving churn?
  • Identify the best performing regions and explain why
  • What would you recommend the business do based on this data?
Prep tip: Structure your presentation: (1) Key finding in one sentence; (2) 3–5 supporting insights with visuals; (3) Business recommendation with rationale; (4) Limitations and what further data you would want. Interviewers reward clear thinking over fancy charts.
Round 5 — Managerial / HR Final
30–45 minVideo or in-person
Commonly asked
  • Tell me about a time you found an error in someone else's data
  • How do you handle a situation where the data contradicts what the business believes?
  • Describe your most complex analysis
  • Where do you see yourself in 3 years?
  • Why this company over others?
Prep tip: Prepare 3–4 STAR stories from your projects. Research the company's business model, recent news, and what their data challenges might be. Ask one specific question about their analytics stack at the end.

4-Week Interview Preparation Plan

1–2 hours per day. Adjust based on your current skill level — if SQL is weak, spend 2 weeks on it.

Week 1SQL Deep Practice
  • Day 1–2: Revise JOINs — write LEFT JOIN, INNER JOIN, SELF JOIN from scratch without looking at notes
  • Day 3–4: GROUP BY + HAVING — 10 aggregation problems. Practice "top N per group" with RANK()
  • Day 5: Window functions — ROW_NUMBER, LAG, running totals. Write 5 window function queries
  • Day 6–7: Timed practice — 3 SQL questions in 30 minutes. Simulate interview conditions
Week 2Excel + Power BI Practical Speed
  • Day 1–2: Build a complete Power BI report from a raw CSV in under 30 min — data load, 3 visuals, 2 DAX measures
  • Day 3: Excel — XLOOKUP, SUMIFS, Power Query on a messy dataset
  • Day 4–5: Practise DAX — CALCULATE with ALL, SAMEPERIODLASTYEAR, RANKX
  • Day 6–7: Build one portfolio-quality Power BI dashboard. Polish layout, labels, and colour scheme
Week 3Case Study + Portfolio
  • Day 1–2: Do a full case study — take a public dataset, analyse it in Python or Power BI, write 5 key findings
  • Day 3: Structure your portfolio — GitHub with SQL queries documented, Power BI file with README
  • Day 4: Resume review — does every bullet have a verb + tool + number + outcome?
  • Day 5–7: Practise answering "walk me through this project" for every item in your portfolio. Record yourself.
Week 4Mock Interviews + Company Research
  • Day 1–2: Mock SQL round — get a friend or mentor to give you 3 questions and watch you solve them live
  • Day 3: Mock HR + behavioural — practise 4 STAR stories from your projects
  • Day 4: Research your target companies — what tools do they use? What is their data challenge?
  • Day 5–6: Apply actively — tailor your resume and cover note for each company type
  • Day 7: Rest and review. Confidence comes from preparation, not cramming.

Behavioural Questions — What to Say and What to Avoid

These determine fitment and are asked in HR and managerial rounds.

"Tell me about yourself"

Current background → analytics skills (tools + projects) → what you are looking for. 90 seconds max. Practise until it sounds natural, not memorised.

"Why do you want to work in data analytics?"

Be specific — reference a real moment when data helped you make a decision. Avoid generic answers about "the field growing rapidly."

"What is your biggest weakness as an analyst?"

Name a real technical gap you are actively working on (e.g., "I am still building my Python skills — I am practising EDA daily"). This shows self-awareness and initiative.

"How do you handle conflicting data from two sources?"

Say: trace the data lineage of each source, check collection methodology, escalate to the data owner, document the discrepancy, and flag it in the report rather than hiding it.

"Where do you see yourself in 3 years?"

Align to the role: "I want to deepen my SQL and Python skills in year 1, take on more complex analyses in year 2, and potentially mentor junior analysts by year 3." Companies want stability, not ambiguity.

Portfolio Tips — What Makes a Hiring Manager Stop and Look

Your portfolio is what you reference in every interview. Make it easy to demo in 3 minutes.

1
Keep everything clickable
Power BI report on Power BI Service (public link), SQL on GitHub, Python in Google Colab or GitHub. Never say "I have a project but can't share it" — this kills the conversation.
2
Write a one-paragraph project summary
For each project: what was the business question? What dataset? What did you find? What would the business do differently? Interviewers read this in 30 seconds before clicking your link.
3
Use real-sounding data
A dashboard on "India E-commerce Sales Jan–Jun 2025" sounds more real than "Sample Superstore Dataset." Use public datasets from Kaggle and give them a real-world context.
4
Show your SQL in a README
Put 3–5 of your best SQL queries in the GitHub README with the question they answer and the result. This alone impresses technical interviewers who want to verify SQL skill before the interview.
5
Quality over quantity
2 excellent projects beat 8 mediocre ones. An interviewer has 90 seconds to assess your portfolio during screening. One compelling dashboard that tells a clear story is better than ten half-finished notebooks.
Practice resources
SQL Interview Q&AExcel Interview Q&APower BI Interview Q&APython Interview Q&AResume Guide

Frequently Asked Questions

How many rounds are there in a data analyst interview in India?

Data analyst interviews in India typically have 2–4 rounds: (1) Screening call with HR or a recruiter — 15–30 minutes, assessing communication and basic background; (2) Technical round — SQL and/or Excel test, 30–60 minutes, often conducted online via HackerRank, Google Meet screen share, or a written assessment; (3) Practical/case study round — you are given a dataset and asked to analyse it in Power BI, Excel, or Python and present findings; (4) Final HR/managerial round — fitment, salary negotiation, and behavioural questions. Small companies may combine rounds 2 and 3. Large IT companies and MNCs almost always have all four.

What SQL questions are asked in data analyst interviews in India?

Indian data analyst SQL interviews most commonly test: (1) JOIN queries — especially LEFT JOIN with IS NULL to find non-matching records; (2) GROUP BY with HAVING — "find departments where average salary exceeds X"; (3) Subqueries — "find the second highest salary"; (4) Window functions — ROW_NUMBER(), RANK(), LAG() — asked at mid-level and above; (5) Date functions — filtering by month/year, calculating date differences. Most SQL rounds give 3–4 questions in 30–45 minutes. Practice writing queries from scratch under a timer.

How should I answer "Tell me about a data analysis project you have done" in an interview?

Use the STAR method adapted for analytics: Situation (what was the business question or problem?), Task (what data did you have and what analysis was needed?), Action (what tools did you use, what did you do with the data — cleaning, analysis, visualisation?), Result (what did you find? what decision or action did it inform?). Be specific: name the dataset, the tools, the key insight, and the impact. Generic answers like "I analysed sales data using Excel" fail — the interviewer wants to understand your analytical process and business thinking, not just the tools you used.

What should I put in my portfolio as a fresher data analyst in India?

As a fresher, build 2–4 projects: (1) A Power BI dashboard on a sales or financial dataset — include DAX measures, a date table, and drill-through. Upload it to Power BI Service and share the link; (2) A SQL analysis project — document 5–8 queries that answer business questions on a dataset; share on GitHub with a README that explains the questions and findings; (3) A Python EDA project — Jupyter Notebook with pandas, matplotlib, and seaborn on a public dataset. Write markdown cells explaining what you found. These three, done well, are more impressive than 10 certifications with no portfolio work.

How long should I prepare for a data analyst interview in India?

For entry-level roles: 4–6 weeks of focused preparation (1–2 hours/day) is sufficient if you already know the tools. If you are still learning SQL or Power BI, you need your training period plus 2–3 weeks of interview-specific preparation. For senior roles: 2–4 weeks of targeted preparation covering advanced SQL (window functions, CTEs), case study practice, and behavioural questions. The most common mistake is preparing too broadly — focus on what is actually tested: SQL, Excel, a visualisation tool, and your portfolio projects.

EVIKA ACADEMY · NOIDA SECTOR 51 · MOCK INTERVIEWS INCLUDED

Train, build your portfolio, and do mock rounds before the real thing

Our course includes live SQL mock rounds, portfolio review, and HR interview preparation. Free demo first.

Book Free Demo →