SoftCrayons logo
DEVELOPMENT18 November 2026

Data Analyst Interview Questions and Answers for Freshers

Data Analytics Interview Questions and Answers - Excel, SQL, Python, Power BI - SoftCrayons
Preparing for your first data analyst interview? This guide covers 33 questions and answers on Excel, SQL queries, Power BI, Python, statistics and real scenarios, plus a round-by-round overview, preparation steps and common mistakes freshers should avoid.
Key Points15 Topics

Cracking your first data analyst interview is less about memorising answers and more about showing that you can work with data. Interviewers want to see that you understand the basics, can write a clean SQL query, can build a useful report and can explain what the numbers mean.

This guide covers 33 data analyst interview questions with clear answers on general concepts, Excel, SQL, Power BI, Python, statistics and real scenarios, followed by preparation tips and common mistakes to avoid.

Quick Answer: What Is Asked in a Data Analyst Interview for Freshers?

For fresher data analyst interviews they usually test Excel, SQL, a business intelligence tool like Power BI or Tableau, basic statistics and in many companies, python. Expect a blend of concept questions, hands on tasks and scenario questions. SQL and Excel answers are key for entry-level roles. A portfolio of real projects sets you apart.

How Data Analyst Interviews Usually Work

The exact process differs from company to company, but most interviews follow a similar pattern.

RoundWhat Is TestedHow to Prepare
HR or screeningBackground, communication, interest in dataPrepare a short introduction and one project story
Technical roundExcel, SQL, statistics and sometimes PythonPractise queries, formulas and concept questions
Tool or assignment roundBuilding a dashboard or analysing a datasetPractise on real datasets in Power BI or Tableau
Case or scenario roundProblem solving and business thinkingPractise explaining your approach step by step
Final or manager roundFit, expectations and growthResearch the company and know your strengths

General Data Analytics Interview Questions

1. What is data analysis?

Data analysis is the process of collecting, cleaning, transforming and interpreting data to find patterns and support decisions. For example, analysing sales data can show which products sell best and which regions need attention.

2. What does a data analyst do?

A data analyst gathers data from different sources, cleans it, analyses it using tools such as Excel, SQL and Python, builds dashboards and reports, and explains insights to business teams so they can make better decisions.

3. What are the four types of data analytics?

  • Descriptive: What happened? (for example, last month’s sales)
  • Diagnostic: Why did it happen? (for example, why sales dropped in one region)
  • Predictive: What may happen next? (for example, forecasting next quarter’s demand)
  • Prescriptive: What should we do? (for example, recommending a pricing change)

4. What are the steps in data cleaning?

Common steps include removing duplicates, handling missing values, fixing data types, standardising formats (such as dates and text), correcting errors, checking for outliers and validating the final data against the source.

5. What is the difference between structured and unstructured data?

Structured data is organised in rows and columns, such as SQL tables and spreadsheets. Unstructured data has no fixed format, such as emails, images, audio and free text. Semi-structured data, such as JSON, sits in between.

6. What is the difference between a data analyst and a data scientist?

A data analyst mainly explains what happened and why using reports and dashboards. A data scientist usually builds predictive models using advanced statistics and machine learning. Read the full comparison in our guide on data analytics vs data science vs data engineering.

Excel Interview Questions

7. What is the difference between VLOOKUP and XLOOKUP?

VLOOKUP searches the first column of a range and returns a value from a column to its right, using a column index number. XLOOKUP can search any column, look left or right, returns an exact match by default and lets you set a value for when nothing is found. XLOOKUP is available in Microsoft 365 and Excel 2021 onwards. INDEX and MATCH is a common alternative in older versions.

8. What is a pivot table?

A pivot table summarises large datasets by letting you drag fields into rows, columns, values and filters. For example, you can quickly see total sales by region and month without writing any formulas.

9. How do you handle duplicates and blank cells in Excel?

Use Remove Duplicates or conditional formatting to find repeated values. For blanks, decide based on context: filter and review them, fill them with a default value, or use functions such as IFERROR and IF. For repeatable cleaning, Power Query lets you save the steps and refresh them on new data.

10. What is the difference between COUNTIF, COUNTIFS and SUMIFS?

COUNTIF counts cells that meet one condition. COUNTIFS counts cells that meet several conditions. SUMIFS adds values that meet several conditions. For example, =SUMIFS(C:C, A:A, "North", B:B, "Laptop") totals column C where the region is North and the product is Laptop.

11. What is the difference between absolute and relative cell references?

A relative reference such as A1 changes when you copy a formula to another cell. An absolute reference such as $A$1 stays fixed. Pressing F4 toggles between them.

Want more? See our advanced Excel interview questions.

SQL Interview Questions

12. What are the different types of SQL joins?

  • INNER JOIN: Returns rows that match in both tables.
  • LEFT JOIN: Returns all rows from the left table and matching rows from the right.
  • RIGHT JOIN: Returns all rows from the right table and matching rows from the left.
  • FULL JOIN: Returns all rows from both tables, matched where possible.

SELECT c.customer_name, o.order_id

FROM customers c

LEFT JOIN orders o ON c.customer_id = o.customer_id;

13. What is the difference between WHERE and HAVING?

WHERE filters individual rows before grouping. HAVING filters groups after aggregation, so it is used with functions such as COUNT, SUM and AVG.

14. What is the difference between a primary key and a foreign key?

A primary key uniquely identifies each row in a table and cannot be null. A foreign key is a column that refers to the primary key of another table and links the two tables together.

15. How do you find duplicate records in a table?

SELECT email, COUNT(*) AS total

FROM users

GROUP BY email

HAVING COUNT(*) > 1;

This groups rows by the column and shows values that appear more than once.

16. How do you find the second highest salary?

SELECT MAX(salary) AS second_highest

FROM employees

WHERE salary < (SELECT MAX(salary) FROM employees);

You can also use DENSE_RANK() in a subquery and filter for rank 2, which works well when you need the Nth highest value.

17. What are window functions?

Window functions perform calculations across a set of related rows without collapsing them into one row. Common examples are ROW_NUMBER, RANK, DENSE_RANK, LAG and LEAD.

SELECT name, department, salary,

RANK() OVER (PARTITION BY department ORDER BY salary DESC) AS dept_rank

FROM employees;

18. What is the difference between DELETE, TRUNCATE and DROP?

DELETE removes selected rows and can use a WHERE clause. TRUNCATE removes all rows from a table quickly but keeps the table structure. DROP removes the entire table, including its structure.

Learn more about databases in our guide on types of SQL software..

Power BI and Tableau Interview Questions

19. What is the difference between a measure and a calculated column in Power BI?

A calculated column is computed row by row when data is refreshed and stored in the model. A measure is calculated at query time based on the filters applied in the report, so it changes as users interact with visuals. Measures are preferred for totals, ratios and other aggregations.

20. What is the difference between Import mode and DirectQuery?

Import mode loads data into Power BI, which gives fast performance and works with scheduled refresh. DirectQuery sends queries to the source each time, which keeps data current but can be slower and depends on the source system.

21. What is a data model and why are relationships important?

A data model connects tables so that reports can combine data correctly. A common design is the star schema, with one central fact table (such as sales) linked to dimension tables (such as customers, products and dates) through one-to-many relationships.

22. What does the CALCULATE function do in DAX?

CALCULATE evaluates an expression after changing the filter context. For example:

Sales 2025 = CALCULATE(SUM(Sales[Amount]), Sales[Year] = 2025)

23. How do Power BI and Tableau differ?

Both build interactive dashboards. Power BI integrates closely with Excel and the Microsoft ecosystem, while Tableau is known for flexible visual exploration. See our detailed comparison: Power BI vs Tableau.

Python Interview Questions for Data Analysts

24. What is the difference between a Pandas Series and a DataFrame?

A Series is a one-dimensional labelled array, like a single column. A DataFrame is a two-dimensional table made of multiple Series, like a spreadsheet or SQL table.

25. How do you handle missing values in Pandas?

Use df.isnull().sum() to find them, df.dropna() to remove rows or columns with missing values and df.fillna(value) to fill them. The right choice depends on how much data is missing and why.

26. How do you combine two DataFrames?

merged = pd.merge(orders, customers, on="customer_id", how="left")

The how argument works like SQL joins: inner, left, right or outer.

27. How do you summarise data by category in Pandas?

df.groupby("region")["sales"].sum()

This groups rows by region and adds up the sales for each one.

New to Python for analysis? Start with our Python for data analytics.

Statistics Interview Questions

28. When would you use the median instead of the mean?

Use the median when the data has outliers or is skewed, such as salaries or house prices, because a few extreme values can pull the mean away from what is typical.

29. What is the difference between correlation and causation?

Correlation means two variables move together. Causation means one variable directly causes the other to change. Two things can be correlated without one causing the other, for example ice cream sales and sunburn cases both rise in summer.

30. What is a p-value?

A p-value is the probability of seeing results at least as extreme as the observed ones if the null hypothesis is true. A small p-value, commonly below 0.05, suggests evidence against the null hypothesis. It is not the probability that the hypothesis is true.

Scenario-Based Interview Questions

31. Sales dropped 20% last month. How would you analyse it?

Start by checking that the data is correct. Then break the drop down by region, product, channel and time period to find where it happened. Compare with previous months and the same month last year, check for external factors such as promotions, stock issues or seasonality, form hypotheses, test them with data and present a clear recommendation.

32. A dashboard is loading slowly. What would you do?

Remove unused columns and rows, use a star schema, replace calculated columns with measures where possible, reduce the number of heavy visuals on one page, aggregate data before loading and consider incremental refresh for large datasets.

33. You receive a dataset with many missing values. What do you do?

First understand why values are missing and how much is missing. Then choose an approach: remove rows if the loss is small, fill values with a sensible default or statistic if appropriate, or flag the gaps. Always document your assumptions so others understand the limits of the analysis.

How to Prepare for a Data Analyst Interview

  1. Revise the basics. Review data cleaning, types of analytics and the questions in this guide.
  2. Practise SQL daily. Joins, GROUP BY, subqueries and window functions come up most often.
  3. Master Excel essentials. Lookups, pivot tables, conditional formulas and basic Power Query.
  4. Build a dashboard. Create one complete report in Power BI or Tableau from a public dataset.
  5. Prepare project stories. Explain the problem, your steps, the tools used and the result. See data analytics projects for beginners and how to build a portfolio.
  6. Practise explaining aloud. Walk through your thinking step by step, as you would with a manager.
  7. Prepare your introduction. Keep it to about two minutes: your background, your key skills, one project and your career goal.

Common Mistakes Freshers Make

  • Memorising answers without practising queries and formulas.
  • Listing tools on the resume that they cannot explain.
  • Giving results without explaining the business meaning.
  • Not asking clarifying questions in scenario rounds.
  • Ignoring data quality and assumptions.
  • Skipping research about the company and its data.

Know Your Worth Before the Offer Stage

Once you clear the interview, compare the offer with market data. Our guide on data analyst salary in India explains experience-wise pay, city-wise averages and how CTC differs from take-home salary.

Prepare for Data Analyst Roles with Softcrayons

Interview confidence comes from hands-on practice. Softcrayons offers a Data Analytics Training Program for students, freshers and working professionals in Noida, Ghaziabad and online, covering Excel, SQL, Power BI and Python with practical assignments, resume preparation and mock interview support. Read more in our guide to the data analyst course in Noida.

Not sure where to start? Book a free demo class and discuss your career goals with the Softcrayons team.

Conclusion

Data analyst interviews reward clear thinking more than perfect recall. Learn the fundamentals of Excel, SQL, a BI tool and statistics, practise with real datasets and explain your reasoning in simple language. Use these 33 questions as a checklist, and keep practising until you can answer each one in your own words.

Frequently AskedQuestions

What questions are asked in a data analyst interview for freshers?

Freshers are usually asked about data analytics basics, Excel functions, SQL queries, Power BI or Tableau, basic statistics and sometimes Python, along with scenario questions and questions about their projects.

Which SQL topics are most important for a data analyst interview?

Joins, GROUP BY and HAVING, subqueries, aggregate functions, window functions such as RANK and ROW_NUMBER, and finding duplicates or the Nth highest value are the most common topics.

Which Excel functions should I know for a data analyst interview?

VLOOKUP or XLOOKUP, INDEX and MATCH, IF, COUNTIF, COUNTIFS, SUMIFS, pivot tables and basic data cleaning functions. Knowing Power Query is a useful extra.

Is Python mandatory for a data analyst job?

Not always. Many entry-level roles focus on Excel, SQL and Power BI or Tableau, but Python with Pandas is increasingly asked for and can strengthen your profile.

How do I answer 'Tell me about yourself' in a data analyst interview?

Keep it to about two minutes: your educational or work background, your main data skills, one project you built and what kind of role you want next.

How many rounds are there in a data analyst interview?

It varies by company, but most processes include a screening round, one or two technical rounds and a managerial or HR round. Some add a take-home assignment.

How important are projects in a data analyst interview?

Very important for freshers. Projects show that you can apply tools to real data, and interviewers often ask you to explain your approach and results in detail.

Where can I prepare for data analyst interviews in Noida or Ghaziabad?

Softcrayons offers a Data Analytics Training Program in Noida, Ghaziabad and online with practical assignments, resume preparation and mock interview support.
Free Live Demo Class Included

Get Free Career Guide

Register in 10 seconds to secure expert consultation & placements guide.

By submitting the form, you agree to our Terms & Conditions and Privacy Policy.

Fast Enquiry on WhatsApp

Land Your Dream Job

Looking for live vacancies & campus hiring drives? Apply directly on SoftCrayons official Job Portal.

Visit Job Portal

Placements in MNC's

Job PortalJobs