What Data Analyst Interviews Test
Most data analyst interviews have 3–5 rounds covering these areas:
- Round 1 (HR Screening): Background, motivation, communication
- Round 2 (Technical SQL): Joins, aggregations, window functions, complex queries
- Round 3 (Python/Excel): Data manipulation, EDA, visualisation
- Round 4 (Business Case): Interpret data, identify trends, make recommendations
- Round 5 (Final): Manager/stakeholder fit, communication of insights
SQL for Data Analysts
SQL is the #1 tested skill. You need to be fluent — not just familiar.
- Complex JOINs across multiple tables
- Window functions: ROW_NUMBER, RANK, LAG/LEAD for time-series analysis
- Aggregation with GROUP BY, HAVING, ROLLUP
- Subqueries and CTEs for complex multi-step analysis
- Date functions: month-over-month, year-over-year comparisons
- NULL handling and data cleaning in SQL
Python for Data Analysts
Pandas and NumPy are the core libraries tested:
- DataFrame manipulation: filtering, groupby, pivot tables
- Data cleaning: handling nulls, duplicates, data type conversions
- Exploratory Data Analysis (EDA): distributions, correlations, outliers
- Matplotlib / Seaborn: basic charts (bar, line, scatter, heatmap)
- Merging datasets and performing calculations
Statistics & Analytics Concepts
Non-negotiable knowledge for senior data analyst roles:
- Mean, median, mode — when each is appropriate
- Standard deviation, variance, and distributions
- Correlation vs. causation — a classic interview question
- A/B testing: hypothesis testing, p-values, statistical significance
- Basic probability: conditional probability, Bayes theorem
- Cohort analysis, funnel analysis, retention metrics
- DAU/MAU, conversion rate, churn, LTV — key business metrics
Business Case Questions
These test your ability to think like a business analyst, not just a SQL writer:
- 'Our revenue dropped 20% last month. Walk me through how you would investigate.'
- 'How would you measure the success of a new feature launch?'
- 'What metrics would you track for a food delivery app?'
- 'We have two A/B test variants with similar CTR. How do you decide the winner?'
Common Interview Questions & Answers
Q1. How would you approach investigating a 30% drop in app signups last week?
I would first check if it's a data issue (tracking error, pipeline failure). If the data is clean, I'd segment by channel (organic, paid, direct) to isolate the source. Then segment by device, geography, and user type. I'd look at the funnel steps to find where users drop off. Finally, I'd check for external factors: app update, competitor campaign, seasonality.
Show systematic, hypothesis-driven thinking — not random guessing.
Q2. Explain the difference between correlation and causation.
Correlation means two variables move together — when one goes up, the other tends to. Causation means one variable CAUSES the other to change. Ice cream sales and drowning deaths are correlated (both peak in summer) but neither causes the other — the confounding variable is hot weather. In analysis, always look for alternative explanations before concluding causation.
Always give a concrete example — the interviewer will remember it.
Q3. How would you define metrics for a new product feature?
I would use the North Star framework: identify one primary metric that measures the feature's core value delivery. Then add 3–5 guardrail metrics to ensure we aren't improving one thing at the expense of another. For each metric, define the measurement method, baseline, and target threshold before launch.
Mentioning guardrail metrics shows mature product thinking.
Common Mistakes to Avoid
Writing SQL that works but is not readable or scalable
Not asking clarifying questions in a case study — jump straight to analysis
Presenting data without a conclusion or recommendation
Using correlation to imply causation in analysis
Not knowing basic statistical concepts like p-value or confidence interval
Expert Tips
Practice the MECE framework for case study breakdowns (Mutually Exclusive, Collectively Exhaustive)
Build a portfolio of 3–5 data analysis projects on Kaggle or GitHub
Practice communicating your analysis to a non-technical audience out loud
Know the key business metrics cold: DAU, MAU, CAC, LTV, NPS, churn rate
Pre-Interview Checklist
6 itemsFrequently Asked Questions
Do data analysts need to know machine learning?
Not for most analyst roles, but knowing basic ML concepts (regression, classification, clustering) is a strong differentiator. Senior analyst and data scientist roles increasingly expect it.
What tool skills are most important for a data analyst in 2026?
SQL (non-negotiable), Python with pandas (strongly preferred), one BI tool (Tableau, Power BI, or Looker), and Excel/Sheets for ad-hoc work.
Ready to ace your next interview?
Practice with SpeakWell AI. Upload your resume → get resume-based questions → practice with AI interviewers → improve communication → track progress → get instant AI feedback.