📌 Data Analyst Interview Questions & Answers

 

📌 Data Analyst Interview Questions & Answers

Here’s a structured list of common Data Analyst interview questions, covering SQL, Excel, Python, Statistics, and Business Acumen.

---

🔹 1. General & Behavioral Questions

✅ Tell me about yourself.
✅ Why do you want to become a data analyst?
✅ What are the key responsibilities of a data analyst?
✅ Explain a project where you analyzed data to solve a business problem.
✅ How do you handle missing or inconsistent data?
✅ Have you ever worked with large datasets? How did you manage them?
✅ Tell me about a time you presented data insights to non-technical stakeholders.
✅ How do you ensure the accuracy and integrity of data?

---

🔹 2. SQL Interview Questions (Most Important)

✅ Basic SQL Queries:
1️⃣ Write a query to fetch the top 5 highest-paid employees from an employees table.

sql

SELECT name, salary 
FROM employees 
ORDER BY salary DESC 
LIMIT 5;

2️⃣ Find the total number of orders placed by each customer from the orders table.

sql

SELECT customer_id, COUNT(order_id) AS total_orders 
FROM orders 
GROUP BY customer_id;

✅ Intermediate SQL:
3️⃣ Find duplicate records in a table.

sql

SELECT column_name, COUNT(*) 
FROM table_name 
GROUP BY column_name 
HAVING COUNT(*) > 1;

4️⃣ Join tables: Fetch employee names along with their department names.

sql

SELECT e.name, d.department_name 
FROM employees e 
JOIN departments d ON e.department_id = d.department_id;

✅ Advanced SQL:
5️⃣ What is the difference between JOINs (INNER, LEFT, RIGHT, FULL)?
6️⃣ What is a window function? Explain RANK(), ROW_NUMBER(), LEAD(), LAG().
7️⃣ How do you optimize SQL queries for large datasets?

---

🔹 3. Excel Interview Questions

✅ What are the most used Excel functions for data analysis?

• VLOOKUP & INDEX-MATCH (Searching data)
• Pivot Tables (Summarizing data)
• COUNTIF / SUMIF (Conditional calculations)
• TEXT functions (LEFT, RIGHT, MID, CONCATENATE)
  ✅ How do you handle missing values in Excel?
  ✅ How do you use conditional formatting in Excel?
  ✅ What is the difference between Absolute & Relative cell referencing in formulas?
  ✅ How do you create a Pivot Table to summarize sales data?

---

🔹 4. Python Interview Questions (if required)

✅ Basic Python for Data Analysis:
1️⃣ How do you read a CSV file using Pandas?

python

import pandas as pd
df = pd.read_csv("data.csv")

2️⃣ How do you handle missing data in Pandas?

python

df.fillna(0)  # Replace NaN with 0
df.dropna()  # Remove rows with NaN values

3️⃣ What’s the difference between apply() and map() in Pandas?
✅ Advanced Python:
4️⃣ How do you detect outliers using Python?

python

import numpy as np
Q1 = np.percentile(df["column"], 25)
Q3 = np.percentile(df["column"], 75)
IQR = Q3 - Q1
lower_bound = Q1 - 1.5 * IQR
upper_bound = Q3 + 1.5 * IQR
outliers = df[(df["column"] < lower_bound) | (df["column"] > upper_bound)]

---

🔹 5. Statistics & Data Analysis Questions

✅ Explain mean, median, mode, and when to use them.
✅ What is standard deviation & variance?
✅ What is the difference between correlation and causation?
✅ Explain hypothesis testing (p-value, t-test, chi-square test).
✅ How do you detect outliers in a dataset?
✅ What is A/B testing, and how would you interpret the results?
✅ What is a confidence interval, and why is it important?

---

🔹 6. Data Visualization & Business Intelligence

✅ How do you choose the right visualization for your data?
✅ Power BI vs. Tableau – which one do you prefer?
✅ How would you present data insights to non-technical stakeholders?
✅ When to use a Bar Chart vs. Line Chart vs. Pie Chart?
✅ How do you make a dashboard interactive in Power BI/Tableau?

---

🔹 7. Case Study & Scenario-Based Questions

✅ Case Study 1: E-commerce Sales Analysis

• You are given a dataset containing customer purchases. How would you analyze which product sells the most?
  ✅ Case Study 2: Customer Churn Prediction
• A company wants to reduce customer churn. What steps would you take to analyze and predict churn?
  ✅ Case Study 3: Marketing Campaign Performance
• A company runs a marketing campaign. How would you measure its success?

---

💡 Tips to Crack the Data Analyst Interview

✔ Practice SQL Queries – Many companies test SQL in online assessments.
✔ Work on Real-World Projects – Kaggle datasets can help.
✔ Learn Business Context – Understand how data drives decisions.
✔ Prepare a Portfolio – Show dashboards, SQL queries, and Python scripts.