Data Analyst practice interview
SQL, analysis, dashboards and turning numbers into decisions. Practise the 5 questions interviewers ask for this role with follow-ups. Paid plans add scored feedback on every answer.
Free with an Intaviu account: 320 credits a month, at 10 credits a minute of practice. Private: interview creators never see them.
- Junior
- 20 minutes
- 5 questions
- Scored feedback on paid plans
About the role
A data analyst turns raw business data into answers people can act on. Day to day you write SQL queries, clean messy spreadsheets, build dashboards and explain what the numbers mean for sales, operations or customers. The panel wants to see that you work accurately with data and tell a clear story from it, not just produce charts.
How to prepare
- Practise writing SQL with joins, grouping and window functions until you can do it without notes.
- Pick one analysis you did and be ready to explain the question, the data, your method and the decision it led to.
- Think about how you check your own numbers before sharing them, and have an example of catching an error.
- Practise explaining a chart to someone with no data background in under a minute.
- Learn the basic metrics of the industry you are applying to, such as churn for a subscription business.
Common mistakes
- Describing tools and charts without saying what the business learned or did.
- Presenting numbers without checking for missing data, duplicates or odd outliers.
- Overcomplicating the answer when a simple table or sum would have done the job.
What to expect
A real first-round interview
5 questions the way interviewers ask for this role, with follow-ups when an answer needs more.
Spoken, like the real thing
Speak your answers in your browser or the free desktop app, with live captions. You can ask the interviewer to repeat anything.
Scored on 4 areas
The things this interview weighs most. With a paid plan, your report shows how you did on each one.
A private report
On Plus, Pro and Premium: every answer scored, your strongest lines quoted and what to say differently next time. Interview creators never see it.
More data and ai practice
Business Intelligence Analyst
Dashboards, SQL reporting, KPI definitions and helping teams act on data.
Data and AIJunior Power BI Developer
Building reliable Power BI models, measures and dashboards from business data and user requirements.
Data and AILogistics Data Analyst (Entry Level)
Cleaning logistics data, defining delivery metrics, finding operational causes and communicating useful insights.