Interview prep
Data Analyst interview questions
Data analyst interviews test SQL, how you turn data into decisions, and communication. Expect a SQL/case exercise plus behavioral questions about stakeholder work.
🎤 Practice these out loud with AceCoach →The questions
Write a SQL query to find the top 3 products by revenue per month. SQL
How to answerState assumptions on the schema, use window functions (RANK over partition), and mention indexing for scale.
A dashboard shows signups dropped 20% overnight. How do you investigate? Case
How to answerCheck data pipeline first (is it real or a tracking bug?), segment by source/device/geo, correlate with releases, then hypothesize.
Explain a insight you delivered that changed a decision. Behavioral
How to answerSTAR: the question asked, your analysis, the recommendation, and the business outcome that followed.
How do you explain a statistically insignificant result to a non-technical stakeholder? Communication
How to answerLead with the decision implication, avoid jargon, use one concrete analogy, state confidence plainly.
What's the difference between correlation and causation, with an example? Fundamentals
How to answerDefine both, give a real confound example, mention how you'd test causation (experiment / controls).
How do you validate a dataset you've never seen before? Rigor
How to answerRow counts, nulls, duplicates, ranges, join keys, distribution sanity-checks against a known source.
What data analysts are tested on
SQLExcel / SheetsOne BI tool (Tableau/Power BI/Looker)Statistics basicsPython or R (a plus)Storytelling with data
Frameworks are guidance, not scripts — the point is to make the answers your own. All roles →