Data Analyst Interview Questions and Answers

Data Analyst Interview Questions and Answers

Data Analyst interviews are not only about knowing tools. Companies usually evaluate whether you can understand a business problem, work with data, find useful insights, and communicate those insights clearly.

Below are some practical interview questions you can use for preparation.

1. What does a Data Analyst do?

A Data Analyst collects, cleans, explores, and interprets data to support business decisions.

Typical responsibilities include:

Cleaning and preparing datasets Writing SQL queries Creating reports and dashboards Finding trends and patterns Tracking business KPIs Presenting insights to stakeholders Supporting data-driven decision making

A strong analyst does not simply create charts. The goal is to convert data into useful business information.

1. What is the difference between WHERE and HAVING in SQL?

WHERE filters rows before aggregation.

HAVING filters aggregated results after GROUP BY.

Example:

SELECT department, AVG(salary) FROM employees WHERE status = 'Active' GROUP BY department HAVING AVG(salary) > 50000;

Here, WHERE first selects active employees, while HAVING filters departments based on their average salary.

1. What is a JOIN in SQL?

A JOIN combines information from two or more tables using a related column.

Common types include:

INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN

For example, if one table contains customers and another contains orders, we can join them using customer_id.

SELECT customers.name, orders.order_value FROM customers INNER JOIN orders ON customers.customer_id = orders.customer_id;

1. What is the difference between INNER JOIN and LEFT JOIN?

An INNER JOIN returns only records that match in both tables.

A LEFT JOIN returns every record from the left table and matching records from the right table.

If there is no matching record, values from the right table will usually appear as NULL.

1. How would you handle missing values in a dataset?

The approach depends on the business problem and the amount of missing data.

Possible approaches include:

Removing rows with missing values Replacing missing numerical values with mean or median Replacing categorical values with mode Creating an "Unknown" category Using business rules to estimate missing values Investigating why the data is missing before modifying it

The important point is that missing values should not be handled blindly.

1. What is the difference between mean and median?

Mean is the average of all values.

Median is the middle value after sorting the dataset.

Median is often more useful when the dataset contains extreme values.

For example, if employee salaries are:

₹20,000 ₹25,000 ₹30,000 ₹35,000 ₹5,00,000

the mean can be heavily influenced by the ₹5,00,000 salary, while the median better represents the typical salary.

1. What is an outlier?

An outlier is a data point that is significantly different from most other observations.

Outliers can occur because of:

Genuine unusual behaviour Data entry errors Technical issues Exceptional business events

An analyst should investigate the reason before removing an outlier.

1. What is correlation?

Correlation measures the relationship between two variables.

For example, we may investigate whether advertising spending and sales revenue move together.

However, correlation does not automatically mean causation.

Two variables can move together without one directly causing the other.

1. What is a KPI?

KPI stands for Key Performance Indicator.

A KPI measures progress toward an important business objective.

Examples include:

Revenue Conversion rate Customer acquisition cost Retention rate Average order value Customer churn Monthly active users

Good analysts understand the business meaning behind a KPI instead of simply reporting the number.

1. What is data cleaning?

Data cleaning is the process of identifying and correcting problems in raw data.

Common tasks include:

Removing duplicates Handling missing values Correcting inconsistent formats Standardizing categories Fixing incorrect data types Detecting invalid values Handling outliers

Good analysis depends heavily on clean and reliable data.

1. What are Pivot Tables in Excel?

Pivot Tables help summarize and analyze large datasets quickly.

They can be used to:

Calculate totals and averages Compare categories Group data Analyze trends Create summary reports

For example, a sales dataset can be summarized by region, product, salesperson, or month using a Pivot Table.

1. What is VLOOKUP?

VLOOKUP searches for a value in one table and retrieves corresponding information from another column.

However, modern Excel users should also understand functions such as:

XLOOKUP INDEX MATCH

These can provide more flexible lookup functionality.

1. Why is Python useful for Data Analysis?

Python helps analysts automate and perform complex data analysis.

Common libraries include:

Pandas for data manipulation NumPy for numerical operations Matplotlib for visualization Scikit-learn for machine learning

Python becomes especially useful when datasets or analytical workflows become too complex for spreadsheets.

1. What is Pandas?

Pandas is a Python library widely used for working with structured data.

A Pandas DataFrame behaves similarly to a table with rows and columns.

Analysts commonly use Pandas for:

Reading CSV and Excel files Filtering data Grouping records Handling missing values Joining datasets Creating calculated columns Performing exploratory analysis

1. What is data visualization?

Data visualization means presenting information through charts, graphs, dashboards, and other visual formats.

The objective is not simply to make data look attractive.

A good visualization should make an important insight easier to understand.

1. What makes a good dashboard?

A good dashboard should:

Focus on important KPIs Avoid unnecessary visual clutter Present information clearly Use appropriate charts Allow users to identify important trends quickly Support decision making

The dashboard should be designed for the person who will use it.

1. How would you investigate a sudden drop in sales?

A good analyst would first break the problem into dimensions.

For example:

When did sales decline? Which product categories declined? Which regions were affected? Did website traffic change? Did conversion rate change? Did pricing change? Was inventory available? Did a marketing campaign stop? Was there a technical problem? Did competitors introduce an offer?

The analyst should move from the broad problem toward the root cause.

1. How would you explain an analysis to a non-technical manager?

Avoid unnecessary technical language.

A useful structure is:

What happened? Why did it happen? What is the business impact? What should we do next?

For example:

Sales declined 12% this month, mainly because mobile conversion dropped after the checkout update. Desktop sales remained stable. We should investigate the mobile checkout flow before increasing marketing spend.

That is more useful to a business stakeholder than explaining every technical step of the analysis.

1. What is A/B Testing?

A/B testing compares two versions of something to understand which performs better.

For example:

Version A: Existing checkout page Version B: New checkout page

Users are divided into groups, and a metric such as conversion rate is compared.

Statistical testing helps determine whether the observed difference is meaningful.

1. What should you do if your analysis contradicts your manager's assumption?

The analyst should rely on evidence.

First:

Verify the data Recheck calculations Validate assumptions Look for missing context

If the analysis remains valid, communicate the finding professionally with supporting evidence.

An analyst's responsibility is not to confirm assumptions. It is to provide reliable information for better decisions.

Key takeaway

Technical skills such as SQL, Excel, Python, Power BI, Tableau, and statistics matter in Data Analyst interviews.

But strong candidates also demonstrate:

Structured thinking Business understanding Problem-solving ability Clear communication Curiosity Attention to data quality

Do not prepare only definitions.

Practice explaining how you would use data to solve real business problems.

That is what often separates someone who knows analytics tools from someone who can actually work as a Data Analyst.