🎯 Data Analyst Interview

Mastery Guide
🚀 Interview Flow Overview
📋 HR Screen (15-30 min)
↓
👔 Hiring Manager (30-45 min)
↓
💻 Technical Screen (45-60 min)
↓
🔬 Onsite/Panel (2-4 hours)
↓
✅ Final Leadership Chat
🧠 Behavioral Questions (STAR Method)
Question Why Asked Pro Response Framework
Tell me about "Started in [field] → Built skills via
Fit & journey
yourself [courses/projects] → Last role: [metric] ↑ X%"
"Love turning raw data → business decisions
Why data analyst? Passion test
(ex: optimized [project])"
Problem- "Faced [issue] → Used [tool] → Result: [quant
Toughest project?
solving win]"
Stakeholder "Translated insights → dashboards → iterated on
Communication
handling? feedback"
Unexpected
Data mindset "Assumed A → Data showed B → Saved [cost]"
results?

🛠️ Technical Skills Pyramid

📊 VISUALIZATION
Tableau/PowerBI

🎯 Data Analyst Interview Mastery Guide 1

 ↑
📈 STATISTICS
Hypothesis Testing, A/B
↑
💻 SQL/Python/R + Data Cleaning
↑
🧹 DATA ETHICS & CLEANING (80% of job!)
Key Stats: Data analysts spend 80% time cleaning, 20% analyzing [1]

🗃️ SQL Questions (LIVE CODING)

Sample Table: sales (id, product, qty, date, customer_id)
-- 🔥
TOP 5 PRODUCTS BY REVENUE
SELECT product, SUM(qty * price) AS revenue
FROM sales
GROUP BY product
ORDER BY revenue DESC
LIMIT 5;

-- 🛒
CUSTOMERS >3 PURCHASES
SELECT customer_id, COUNT(*) AS purchases
FROM sales
GROUP BY customer_id
HAVING COUNT(*) > 3;

-- 📊
MONTHLY GROWTH (Window Function)
SELECT DATE_TRUNC('month', date) AS month,
SUM(qty) AS total,
LAG(SUM(qty)) OVER (ORDER BY DATE_TRUNC('month', dat
e)) AS prev_month
FROM sales
GROUP BY 1;

🎯 Data Analyst Interview Mastery Guide 2

 Question Type Pro Tips
Aggregates GROUP BY + HAVING + ROW_NUMBER()

Complex Joins INNER/LEFT/FULL + explain logic

Optimization Indexes, EXPLAIN , avoid SELECT *

🐍 Python/Pandas Live Tasks

import pandas as pd

# 🧹CLEAN MISSING DATA

df = pd.read_csv('[Link]')
df['revenue'] = df['qty'] * df['price']
[Link]([Link](), inplace=True)

# 📈TOP PRODUCTS
[Link]('product')['revenue'].sum().nlargest(5)

# 🔄PIVOT TABLE
df.pivot_table(index='date', values='sales', aggfunc='sum')

Outlier Detection:

Q1 - 1.5×IQR Rule (Boxplot method)

📊 Statistics Crash Course

🔬 HYPOTHESIS TESTING FLOW
H₀ (Null) → Data → Test Statistic → P-value < 0.05 → REJEC
T!

Concept When to Use Key Formula

Skewed data →
Mean vs Median $$\bar{x} = \frac{\sum x_i}{n}$$
Median
$$r = \frac{\cov(X,Y)}
Correlation Feature relationships
{\sigma_X\sigma_Y}$$

🎯 Data Analyst Interview Mastery Guide 3

 Concept When to Use Key Formula
Linear Regression Predict sales $$y = \beta_0 + \beta_1x + \epsilon$$
Confidence
95% range $$\bar{x} \pm 1.96\frac{s}{\sqrt{n}}$$
Interval

💼 CASE STUDY Framework (30-40% of onsite)

❌ Problem: "User retention dropping"
✅ SOLUTION STEPS:
1️⃣ DEFINE METRICS DAU/MAU ratio
2️⃣ SEGMENT Cohorts by signup
3️⃣ HYPOTHESIZE Feature bug? Pricing?
4️⃣ QUERY/VISUALIZE Retention curves
5️⃣ RECOMMEND A/B test fix

Pro Communication: "First I'd pull user logs via [SQL]. Viz shows 30% drop
post-update."

🎯 Questions YOU Ask Interviewers

💰 "What metrics define team success?"
🐛 "Biggest data challenge right now?"
🛠️ "Current tools + growth path?"
📊 "How does data drive decisions here?"
✅ 30-Day Prep Checklist
Week 1: 🗃️ SQL (50 LeetCode Medium)
Week 2: 🐍 Python/Pandas (3 EDA projects)
Week 3: 📊 Stats + Case Studies
Week 4: 🎭 Mock Interviews (5x)
PORTFOLIO MUST-HAVES:
✅ Sales Dashboard (Tableau/PowerBI)

🎯 Data Analyst Interview Mastery Guide 4

 ✅ Customer Segmentation (K-Means)
✅ A/B Test Analysis (Statistical significance)
🚀 Final Pro Tips
1. EXPLAIN CODE like to your mom
2. Always quantify impact: "↑ 23% revenue"
3. Think aloud during cases
4. Ask clarifying questions
5. Portfolio > perfect answers

Success Rate: Candidates with portfolio + SQL + behavioral stories get 3x

more offers.

🎯 Data Analyst Interview Mastery Guide 5