Data analyst interview questions cover SQL querying, Excel functions, Power BI dashboards, statistics, and business case reasoning. Interviewers test your ability to clean data, write efficient queries, and translate numbers into business decisions. This guide covers the most common questions across every category with sample answers.

What to Expect in a Data Analyst Interview

Most data analyst interviews in India follow a three-round structure: a technical screening on SQL and Excel, a tool-specific round on Power BI or Python, and a business case or stakeholder communication round. Companies like Infosys, Wipro, Mu Sigma, and Tiger Analytics each run slight variations, but the core question bank stays predictable.

According to LinkedIn’s 2024 Jobs on the Rise report, data analyst roles in India grew by 41% year-over-year, making it one of the fastest-growing tech-adjacent job titles in the country. That growth means more competition, and interviewers are raising the bar on both technical depth and communication skills.

The NASSCOM Future of Work 2024 report puts the current data professional demand in India at over 11 lakh open positions, with SQL and Power BI consistently listed as the top two required skills. If you have not touched those yet, our guide on top free and paid resources for learning data analytics is worth reading before you continue here.

Technical Interview Questions for Data Analysts

SQL Interview Questions for Data Analysts

SQL is non-negotiable. Every company, from a Series A startup to an MNC, will test it. The questions range from basic SELECT statements to window functions, subqueries, and performance optimisation. Entry level data analyst interview questions on SQL tend to focus on JOINs and GROUP BY, while mid-level roles add window functions and query optimisation.

Here are the most frequently asked SQL interview questions for data analysts, with concise answers:

• What is the difference between WHERE and HAVING? WHERE filters rows before aggregation; HAVING filters after. Use HAVING with GROUP BY when you want to filter on an aggregate like COUNT or SUM.
• Explain the different types of JOINs. INNER JOIN returns matching rows from both tables. LEFT JOIN returns all rows from the left table and matched rows from the right. RIGHT JOIN is the mirror. FULL OUTER JOIN returns everything, matched or not.
• What are window functions? Give an example. Window functions perform calculations across a set of rows related to the current row without collapsing them. ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) ranks employees by salary within each department.
• How do you find duplicate records in a table? Use GROUP BY on the columns you want to check and filter with HAVING COUNT(*) > 1.
• What is a CTE and when do you use it? A Common Table Expression (WITH clause) creates a temporary named result set. It improves readability and lets you reference the same subquery multiple times without rewriting it.
• How would you optimise a slow SQL query? Check for missing indexes, avoid SELECT *, reduce subqueries by using JOINs, and use EXPLAIN or query execution plans to find bottlenecks.

Practice tip: Write queries on real datasets. Platforms like HackerRank, LeetCode, and Mode Analytics offer free SQL practice environments that mirror actual interview conditions.

Excel Interview Questions for Data Analysts

Even with Python and BI tools everywhere, Excel comes up in almost every entry level and mid-level data analyst interview in India. Interviewers want to know you can handle it under pressure.

• What is the difference between VLOOKUP and INDEX-MATCH? VLOOKUP only looks to the right and breaks when columns are inserted. INDEX-MATCH is more flexible, can look in any direction, and is faster on large datasets.
• How do you remove duplicates in Excel? Data tab, then “Remove Duplicates”. For more control, use COUNTIF to flag duplicates first before deleting.
• What are Pivot Tables used for? Summarising large datasets quickly. You can group, filter, and aggregate data without writing a single formula.
• Explain the use of SUMIFS and COUNTIFS. Both apply multiple conditions. SUMIFS adds values where all conditions are met; COUNTIFS counts rows where all conditions are met.
• What is Power Query? A data transformation tool inside Excel (and Power BI) that lets you clean, reshape, and combine data from multiple sources without writing code.

Statistics and Analytical Reasoning Questions

You do not need a statistics degree, but you do need a working understanding of the concepts that show up in real analysis work.

• What is the difference between mean, median, and mode? Mean is the arithmetic average. Median is the middle value when sorted. Mode is the most frequent value. For skewed distributions like income data, median is more representative.
• What is standard deviation? It measures how spread out values are around the mean. A low standard deviation means data points cluster tightly; a high one means they are spread out.
• What is the difference between correlation and causation? Correlation means two variables move together. Causation means one causes the other. Ice cream sales and drowning rates are correlated because both rise in summer, not because one causes the other.
• What is a p-value? It tells you the probability of observing your results if the null hypothesis were true. A p-value below 0.05 is conventionally considered statistically significant, though context matters.
• What is an outlier and how do you handle it? An outlier is a data point significantly different from others. You investigate first: is it a data entry error, a real extreme event, or a meaningful signal? Then you decide whether to remove, cap, or keep it.

Power BI and Business Analytics Questions

Power BI questions for experienced candidates go well beyond “how do you make a bar chart.” Interviewers expect you to talk about DAX measures, data model design, performance issues, and report publishing workflows.

Power BI Interview Questions for Experienced Candidates

If you are applying for a mid-to-senior analyst role, expect these:

• What is the difference between a measure and a calculated column in Power BI? A calculated column is computed row by row during data refresh and stored in the model. A measure is computed at query time based on the current filter context. Measures are more memory-efficient for aggregations.
• Explain DAX’s CALCULATE function. CALCULATE evaluates an expression in a modified filter context. It is one of the most powerful DAX functions because it lets you override or add filters dynamically.
• What is a star schema and why does it matter in Power BI? A star schema has one central fact table connected to multiple dimension tables. Power BI performs best with this structure because it simplifies DAX and improves query speed.
• How do you handle row-level security in Power BI? You define roles in Power BI Desktop using DAX filter expressions, then assign users to those roles in the Power BI Service so each user only sees their permitted data.
• What is DirectQuery vs Import mode? Import mode loads data into Power BI’s in-memory engine for fast performance. DirectQuery queries the source database live, which is better for real-time data but slower on large datasets.

If you are planning a career in this space, the Power BI developer career roadmap on 3University breaks down exactly which skills to build at each level.

Data Analytics vs Business Analytics: What Interviewers Actually Ask

The distinction between data analytics and business analytics trips up a lot of candidates. It is a common interview question, especially in consulting-adjacent roles.

In practice, the roles overlap heavily. A data analyst at a company like Flipkart or Razorpay is expected to do both: write the SQL and then explain the business implication to a product manager who does not know what a JOIN is.

Business Case and Scenario-Based Questions

These are increasingly common, especially at product companies and consulting firms. The interviewer gives you a business problem and watches how you structure your thinking.

• Example: “Our app’s Day 7 retention dropped 15% last month. How would you investigate?”

A strong answer structures like this: define the metric clearly, segment the data (by platform, region, user cohort, acquisition channel), identify when the drop started and whether it correlates with any product change or marketing shift, form a hypothesis, and describe what data you would pull to validate it.

Interviewers are not looking for the right answer. They are looking for structured thinking and an understanding that data questions always live inside a business context.

How to Prepare for a Data Analyst Interview

Start with a skills audit. Map what you know against what the job description asks for. Most job descriptions in India for data analyst roles require SQL (all levels), Excel or Google Sheets (entry level), Power BI or Tableau (mid and above), and basic Python or R (increasingly common even for entry level). Data analyst salaries in India for mid-level roles range from Rs 6 lakh to Rs 12 lakh per annum according to AmbitionBox 2024 data, which reflects how competitive the hiring market has become.

According to a 2024 survey by Analytics Vidhya, 68% of data analyst candidates who failed their first interview cited SQL as their weakest area, not statistics or tools. That is where to focus first.

Practice one real dataset end to end. Download a public dataset from Kaggle, write 20 SQL queries on it, build a Power BI dashboard, and document your findings as if you were presenting to a non-technical manager. That single exercise covers 80% of what interviews test and is the most effective data analyst interview preparation you can do.

If you want to go further into data science and ML roles, the how to become a data scientist guide on 3University maps the full progression from analyst to scientist.

Common Mistakes to Avoid in Data Analyst Interviews

Many candidates fail not because of knowledge gaps but because of avoidable errors. Memorising SQL syntax without understanding query logic is the most common trap. Interviewers at companies like Mu Sigma and Fractal Analytics often ask you to explain your reasoning, not just produce an output. Other frequent mistakes include skipping the business context when answering case questions, not asking clarifying questions before diving into a problem, and underestimating Excel in favour of flashier tools.

Frequently Asked Questions

What are common data analyst interview questions?

Common data analyst interview questions cover SQL queries (JOINs, GROUP BY, window functions), Excel functions (VLOOKUP, Pivot Tables, SUMIFS), Power BI concepts (DAX, data models, row-level security), statistics basics (mean, standard deviation, p-value), and business case questions that test structured thinking. Most interviews in India follow a technical screening round followed by a case or communication round.

What SQL questions are asked for data analysts?

SQL questions for data analysts typically include the difference between WHERE and HAVING, types of JOINs, window functions like ROW_NUMBER and RANK, how to find and remove duplicates, what CTEs are and when to use them, and how to optimise a slow query. Mid-level roles also ask about subqueries, stored procedures, and indexing strategies.

How do I prepare for a data analyst interview?

Audit your skills against the job description, then practise SQL on platforms like HackerRank or LeetCode. Work through at least one end-to-end project on a real dataset: clean it, query it, visualise it in Power BI, and write up the business insight. Mock interviews with a peer or mentor help significantly. Give yourself four to six weeks of structured data analyst interview preparation for a mid-level role.

What Power BI questions are asked in interviews?

Power BI interview questions for experienced candidates focus on DAX (especially CALCULATE, SUMX, and time intelligence functions), the difference between measures and calculated columns, star schema data model design, DirectQuery vs Import mode, and how to implement row-level security. Entry-level questions focus on report building, slicers, and basic DAX measures.

What is the difference between data and business analytics?

Data analytics focuses on extracting and processing insights from raw data using technical tools like SQL, Python, and Power BI. Business analytics focuses on using those insights to inform strategy, forecast outcomes, and support business decisions. In practice, many analyst roles blend both: you write the query and then explain what it means for the product or revenue target.

What are entry level data analyst interview questions?

Entry level data analyst interview questions focus on foundational SQL (SELECT, WHERE, GROUP BY, basic JOINs), Excel functions (VLOOKUP, Pivot Tables, COUNTIF), basic statistics (mean, median, standard deviation), and simple data cleaning scenarios. Interviewers at this level prioritise logical thinking and learning potential over deep technical expertise.

Last updated: June 2026. Reviewed by the 3.0 University editorial team.