
Preparing for your first data analyst interview in 2027? Most fresher interviews test the same five areas: Excel, SQL, Power BI, Python and basic statistics, followed by a few scenario and HR questions. This guide covers the top 50 data analyst interview questions and answers for freshers, grouped by topic, with short answers you can explain in your own words.
New to the field? Read how to become a data analyst from a non-IT background first, then come back to practise.
What Does a Data Analyst Do?
A data analyst collects, cleans and analyses data, then turns it into reports and dashboards that help a business make decisions. A typical day includes writing SQL queries, cleaning data in Excel or Python, building Power BI dashboards and explaining findings to managers.
Section 1: Data Analytics Basics
1. What is data analytics?
Data analytics is the process of collecting, cleaning, transforming and analysing data to find patterns and answer business questions.
2. What are the four types of data analytics?
Descriptive: what happened (monthly sales report)
Diagnostic: why it happened (sales dropped because of fewer repeat buyers)
Predictive: what is likely to happen (next quarter's forecast)
Prescriptive: what should we do (which offer to run)
3. What is the difference between data analysis and data analytics?
Data analysis is the act of examining a dataset to answer a question. Data analytics is the wider field that includes collecting, storing, analysing and reporting on data.
4. What are the steps in a data analysis project?
Define the question, collect the data, clean it, explore and analyse it, visualise the results, and share insights and recommendations.
5. What is data cleaning and why is it important?
Data cleaning means fixing or removing incorrect, duplicate, incomplete or badly formatted data. Analysts often spend most of their time here, because wrong data leads to wrong decisions.
6. What is the difference between structured and unstructured data?
Structured data fits neatly into rows and columns, like a sales table. Unstructured data has no fixed format, like emails, images or customer reviews.
7. What is the difference between data mining and data profiling?
Data profiling checks the quality and structure of data (missing values, data types, ranges). Data mining looks for hidden patterns and relationships in large datasets.
8. What is a KPI?
A Key Performance Indicator is a measurable value that shows how well a business is meeting a goal, for example monthly revenue, conversion rate or customer churn.
9. How do you handle missing data?
First find out why it is missing. Then remove the rows if they are few, fill them with the mean, median or mode, use a value from a related column, or flag them as "Unknown". The choice depends on how much data is missing and how it affects the analysis.
10. What is an outlier and how do you treat it?
An outlier is a value far away from the rest of the data. Detect it with a box plot or the IQR method, check whether it is an error or a genuine value, then correct, remove or keep it with a note.
Section 2: Excel Interview Questions
For a deeper list, see our Advanced Excel interview questions for data analytics.
11. What is the difference between VLOOKUP and XLOOKUP?
VLOOKUP searches only in the first column and returns values to the right. XLOOKUP can search in any direction, returns exact matches by default and handles "not found" results without extra formulas.
12. What is the difference between INDEX-MATCH and VLOOKUP?
INDEX-MATCH can look up values to the left, does not break when columns are inserted and is faster on large sheets.
13. What is a PivotTable?
A PivotTable summarises large data in seconds by grouping, counting, summing or averaging values, without writing formulas.
14. What is conditional formatting used for?
It highlights cells that meet a rule, such as sales below target in red, so trends and problems stand out quickly.
15. What is Power Query in Excel?
Power Query is a tool to import, clean and transform data from many sources. Its steps are recorded, so the same cleaning runs again when new data arrives.
16. How do you remove duplicates in Excel?
Use Data → Remove Duplicates, or the UNIQUE function, or Power Query's Remove Duplicates step for repeatable cleaning.
17. What is the difference between COUNT, COUNTA and COUNTIF?
COUNT counts numeric cells, COUNTA counts all non-empty cells, and COUNTIF counts cells that meet a condition.
18. What is data validation in Excel?
Data validation limits what users can enter in a cell, such as a dropdown list or a date range, which keeps data clean at the source.
Section 3: SQL Interview Questions
19. What is SQL?
SQL (Structured Query Language) is used to store, retrieve and manage data in relational databases such as MySQL, PostgreSQL and SQL Server.
20. What is the difference between WHERE and HAVING?
WHERE filters rows before grouping. HAVING filters groups after GROUP BY, so it works with aggregate functions like SUM or COUNT.
21. Explain the types of JOINs.
INNER JOIN: only matching rows from both tables
LEFT JOIN: all rows from the left table, matches from the right
RIGHT JOIN: all rows from the right table, matches from the left
FULL OUTER JOIN: all rows from both tables
22. What is the difference between a primary key and a foreign key?
A primary key uniquely identifies each row in a table. A foreign key is a column that refers to the primary key of another table and links the two.
23. What is the difference between UNION and UNION ALL?
UNION combines results and removes duplicates. UNION ALL keeps duplicates and is faster.
24. Write a query to find the second-highest salary.
SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
25. What is a subquery?
A subquery is a query inside another query, used to filter or calculate values that the outer query needs.
26. What is a CTE?
A Common Table Expression, written with WITH, is a named temporary result that makes long queries easier to read and reuse.
27. What are window functions?
Window functions such as ROW_NUMBER, RANK, DENSE_RANK, LAG and running SUM calculate values across related rows without collapsing them into one row like GROUP BY does.
28. What is the difference between RANK and DENSE_RANK?
Both rank rows, but RANK skips numbers after a tie (1, 1, 3) while DENSE_RANK does not (1, 1, 2).
Section 4: Power BI Interview Questions
Want more? Read our full list of Power BI interview questions and answers.
29. What is Power BI?
Power BI is Microsoft's business intelligence tool for connecting to data, modelling it and building interactive reports and dashboards.
30. What is the difference between a report and a dashboard in Power BI?
A report can have many pages of interactive visuals from one dataset. A dashboard is a single page of pinned tiles, often from several reports, for a quick overview.
31. What is DAX?
DAX (Data Analysis Expressions) is the formula language in Power BI used to create measures, calculated columns and tables.
32. What is the difference between a measure and a calculated column?
A calculated column is computed row by row and stored in the table. A measure is calculated on the fly based on filters in the report, so it uses less memory.
33. What is a star schema?
A star schema has one central fact table (such as sales) linked to dimension tables (such as date, product and customer). It keeps models fast and easy to understand.
34. What does the CALCULATE function do?
CALCULATE evaluates an expression with modified filters, for example total sales for only one region or only last year.
35. What are slicers?
Slicers are on-page filters that let users click to filter a report by date, region, product or any other field.
36. What is row-level security (RLS)?
RLS restricts which rows a user can see, so a regional manager sees only their region's data in the same report.
Section 5: Python Interview Questions
37. Why do data analysts use Python?
Python handles large datasets, automates repetitive cleaning and has strong libraries like Pandas, NumPy, Matplotlib and Seaborn for analysis and charts.
38. What is the difference between a list and a tuple?
A list can be changed after creation (mutable). A tuple cannot be changed (immutable) and is slightly faster.
39. What is the difference between NumPy and Pandas?
NumPy works with fast numerical arrays. Pandas is built on NumPy and works with labelled tables (DataFrames), which suits real business data.
40. How do you handle missing values in Pandas?
Use isnull() to find them, dropna() to remove them and fillna() to replace them with a value, mean or median.
41. What is the difference between merge() and concat() in Pandas?
merge() joins DataFrames on a common column, like a SQL JOIN. concat() stacks DataFrames on top of or next to each other.
42. What is EDA?
Exploratory Data Analysis is the first look at a dataset: checking shape, data types, missing values, distributions and relationships, using summary statistics and charts.
Section 6: Statistics Interview Questions
43. What is the difference between mean, median and mode?
Mean is the average, median is the middle value and mode is the most frequent value. Median is better than mean when data has outliers, such as salaries.
44. What is standard deviation?
Standard deviation shows how spread out values are from the mean. A low value means data points are close together.
45. What is the difference between correlation and causation?
Correlation means two variables move together. Causation means one actually causes the other. Ice-cream sales and AC sales rise together, but one does not cause the other; summer causes both.
46. What is A/B testing?
A/B testing compares two versions (such as two web page designs) on similar groups of users to see which performs better on a chosen metric.
Section 7: Scenario and HR Questions
47. Sales dropped 20% last month. How would you investigate?
Check the data is correct first. Then break sales down by region, product, channel and customer type, compare with the same month last year, and look for events such as price changes, stock issues or a competitor offer.
48. How would you explain a complex insight to a non-technical manager?
Start with the conclusion, use one clear chart, avoid jargon and link the insight to a business action, such as "Repeat customers fell 15%, so a loyalty offer could recover sales."
49. Tell us about a data project you have worked on.
Use the STAR method: the Situation, the Task, the Actions you took (tools and steps) and the Result in numbers. A dashboard or SQL project from your course works well for freshers.
50. Why do you want to become a data analyst?
Connect your answer to problem-solving and impact, for example: "I enjoy finding patterns in numbers and turning them into decisions. I have built Excel, SQL and Power BI projects and want to apply these skills to real business problems."
Tips to Crack a Data Analyst Interview as a Fresher
Practise SQL queries daily, especially JOINs, GROUP BY and window functions.
Keep 2–3 portfolio projects ready to explain: one Excel, one SQL and one Power BI dashboard.
Revise basic statistics: mean, median, standard deviation and correlation.
Explain your thinking out loud during case questions.
Research the company's business and the KPIs it likely tracks.
Not sure which tool to learn first? Read Excel vs Power BI vs SQL: what should a beginner learn first.
Prepare for Data Analyst Interviews with Brillica Services
Brillica Services offers a 6-month classroom Data Analytics Course in Dehradun and a Data Analytics Course in Delhi. You learn Excel, SQL, Power BI and Python, build 4 real-world projects and attend 15 PDP and interview sessions, including mock interviews, to practise questions like these before the real thing.
Conclusion
Data analyst interviews for freshers focus on fundamentals, not tricks. If you can explain these 50 questions clearly, write basic SQL without help and walk through one or two projects, you are well prepared. Want to know where this career can take you? Read is data analytics a good career in 2027.
Frequently Asked Questions
What questions are asked in a data analyst interview for freshers?
Fresher interviews usually cover Excel (lookups, PivotTables), SQL (JOINs, GROUP BY, window functions), Power BI (DAX, data models), basic Python with Pandas, statistics, plus one or two scenario and HR questions.
Is SQL compulsory for a data analyst interview?
Yes. SQL is asked in almost every data analyst interview, often as a live query test. Practise JOINs, GROUP BY, HAVING, subqueries and window functions.
Can a fresher with no experience crack a data analyst interview?
Yes. Interviewers expect strong basics and practical projects rather than work experience. Two or three portfolio projects in Excel, SQL and Power BI make a big difference.
How should I prepare for a data analyst interview in 1 month?
Spend the first week on Excel, the second on SQL, the third on Power BI and statistics, and the fourth on projects, mock interviews and revising these 50 questions.
How can Brillica Services help me prepare for data analyst interviews?
Brillica Services' 6-month Data Analytics course in Dehradun and Delhi covers Excel, SQL, Power BI and Python with 4 real-world projects and 15 PDP and interview sessions, including mock interviews.
