Data Analyst: Interview questions: SQL, statistics, Excel, BI and cases
Data analyst interviews usually test four things: statistics basics, hands-on SQL and Excel, a BI tool such as Power BI or Tableau, and a business case where you reason aloud. This kit works for any employer and covers fresher and early-career roles.
19 questions · 4 rounds · updated Nov 2026
How the interview works
- Screening: Resume, projects, tools and basic statistics.
- Technical round: SQL queries, Excel or Python tasks, data cleaning scenarios.
- Case and business round: Metric definition, diagnosing a drop, A/B testing, communicating a result.
- HR round: Motivation, communication, salary expectations.
Sample questions
- 01
You receive a customer dataset with missing values, duplicates and inconsistent city names. What steps do you take?
MediumData cleaning
Model answer
What the interviewer checks
A reproducible process and judgement about how to treat missing data.
How to answer
1. Profile first: row count, data types, nulls per column, distinct values, min and max. Notice problems such as an age of 240 or dates in 1900. 2. Duplicates: decide the business key (email or phone, normalised to lower case with spaces trimmed), remove exact duplicates, and review near-duplicates. 3. Standardise: trim and fix case, map variants to one value ("Bangalore", "Bengaluru", "BLR" → Bengaluru) with a mapping table, and parse dates into one format. 4. Missing values: first ask why they're missing. Drop rows only if few are affected and the gaps are random. Fill numeric gaps with the median or a group median, use "Unknown" for categories, and add a flag column so the analysis can see what was filled. 5. Outliers: check whether they are errors (fix or drop them) or real (keep them, maybe cap them for modelling). 6. Document every rule and do it in a script (SQL or Python), not by hand, so it can be rerun on next month's file.
- 02
Ice cream sales and drowning incidents are strongly correlated. What is the most likely explanation?
MediumStatistics
- 03
List the highest-paid employee in each department, with the department name. Include ties.
MediumWindow functions
Approach and solution
Approach
Rank inside each department with a window function, then keep rank 1. RANK keeps ties; ROW_NUMBER would pick one arbitrarily.
SELECT d.name AS department, e.name, e.salary FROM ( SELECT e.*, RANK() OVER (PARTITION BY dept_id ORDER BY salary DESC) AS rnk FROM employees e ) e JOIN departments d ON d.id = e.dept_id WHERE e.rnk = 1;Complexity: One sort per partition.
16 more questions, members only
- Analytics fundamentals5
- SQL for analysts8
- Tools: Excel, Python and BI3
- Case and business questions3
Members also get how to answer each question and a preparation plan for this company.
See plans from ₹399Every question and answer is written by Hirecept and the code is run before it is published. How a company runs its process comes from candidate reports and public pages, and companies change it, so treat that part as a guide, not a promise.