Data analyst interview questions to practise out loud
Data analyst interviews test two things: whether you can work with data, and whether you can explain what it means to someone who cannot. The second is where many good analysts struggle, and it is exactly what speaking practice improves.
These questions are about explaining your thinking out loud. Pair them with hands-on practice in SQL and spreadsheets for the technical rounds.
Walk me through a data analysis project you worked on.
What they are looking for: Your end-to-end process and the impact of your work.
How to approach it: Question → data sources → cleaning → analysis → finding → what changed because of it. Keep tools to a brief mention.
How do you handle missing or messy data?
What they are looking for: Practical judgement, not a textbook list.
How to approach it: Explain how you first find out why data is missing, then the options you choose between — drop, impute, flag — and how you decide.
Explain the difference between an inner join and a left join.
What they are looking for: SQL fundamentals, and whether you can explain them clearly.
How to approach it: Use a tiny example — customers and orders — and say what each join returns for a customer with no orders.
How would you explain a dashboard to a manager with no data background?
What they are looking for: Communication with stakeholders.
How to approach it: Start with the decision it supports, point to the one or two numbers that matter, and say what to do when they change.
Tell me about a time your analysis contradicted what a stakeholder believed.
What they are looking for: Confidence, tact and rigour.
How to approach it: STAR: how you double-checked your work, how you presented it, and what was decided.
How do you check that your analysis is correct?
What they are looking for: Attention to detail.
How to approach it: Name concrete checks: row counts, totals against a known source, sanity ranges, a second pair of eyes.
Which metric would you track to measure the success of a new app feature?
What they are looking for: Product sense and choosing the right metric.
How to approach it: Tie the metric to the feature’s goal, name a counter-metric to watch, and say over what time period.
How would you design an A/B test for a change to a sign-up page?
What they are looking for: Experimental thinking.
How to approach it: Hypothesis, the metric, random split, how long to run it, and what result would make you ship the change.
Which tools do you use, and why?
What they are looking for: Hands-on familiarity.
How to approach it: Name the tools you have actually used, what for, and one thing you would like to learn next.