Interview practice by role
Data Analyst Interview Practice
Data analyst interviews test whether you can turn a vague question into a correct query and a clear recommendation. SQL fluency and sound reasoning about metrics matter most.
160 practice questions4 topics5 typical rounds
How the interview usually runs
Loops differ by company. Treat this as a common pattern, not a fixed format.
- 01Screening callTools you use, the datasets you worked with and the decisions your analysis influenced.
- 02SQL roundJoins, aggregations, window functions and debugging a query that returns the wrong numbers.
- 03Python or spreadsheet taskClean a messy dataset and summarise it, explaining each assumption.
- 04Case or metrics discussionDefine a metric, find why it dropped and propose what to check next.
- 05Stakeholder roundExplaining results to a non-technical audience and handling pushback.
What interviewers probe
- Window functions, grouping and avoiding duplicate counting in joins
- How you validate that a number is correct
- Choosing a metric and knowing its limits
- Cleaning data and documenting assumptions
- Turning an analysis into a recommendation
Common mistakes
- Writing a query without checking the result against a known figure
- Presenting numbers with no recommendation attached
- Not asking what decision the analysis will feed
Practice questions for Data Analyst interviews
A starting set from each topic. Every question has a short answer, the full reasoning and the follow-ups interviewers ask.
01How do you choose between SQL and NoSQL databases?Mediumsql · nosql · data modelling02What is the difference between WHERE and HAVING?Mediumwhere · having · aggregation03What is the difference between INNER JOIN and LEFT JOIN?Mediuminner join · left join · nulls04Why does mutability matter in Python?Mediummutability · aliasing · defaults05How do generators work and why use them?Mediumgenerators · laziness · yield06What is the iterator protocol?Mediumiterators · protocols · for loops07What does the CAP theorem actually say?Mediumcap theorem · consistency · partition tolerance08How does eventual consistency work and how do you handle it?Mediumeventual consistency · replication · session guarantees09How do wide-column stores organise data?Mediumwide-column · cassandra · partitioning10Why are you leaving your current job?Mediummotivation · professionalism · job change11What is your greatest weakness?Mediumself-awareness · growth · weakness12What is your proudest achievement?Mediumimpact · storytelling · ownership
Reading is step one
Now say it out loud.
Understanding an answer and delivering it under pressure are different skills. Rehearse this topic in a live Data Analyst mock interview and get scored feedback on depth, clarity and confidence.