Interview questions
Data Analyst Interview Questions
Prepare for your Data Analyst interview with 25 essential questions covering SQL, statistics, visualization, and problem-solving with expert evaluation.
What's here
10 Data Analyst interview questions, grouped into 3 areas: technical sql & data questions, analytical & problem-solving questions and statistical & visualization questions. Each one comes with why it is worth asking and what a strong answer contains, so the same question can be scored the same way by different interviewers.
- Include a practical SQL test or take-home analysis. Technical interviews reveal more than conversation alone.
- Ask candidates to walk through their portfolio or a past project. How they explain their process is as important as the result.
- Test communication by asking them to explain a technical concept simply. Great Data Analysts are also great communicators.
Hiring a Data Analyst requires evaluating technical proficiency, analytical thinking, and communication skills. The best candidates can not only crunch numbers but also translate data into actionable business insights. Use these questions to assess SQL skills, statistical knowledge, visualization abilities, and business acumen.
Technical SQL & Data Questions
These questions test hands-on data skills that every Data Analyst needs.
- 1
Explain the difference between INNER JOIN, LEFT JOIN, and FULL OUTER JOIN. When would you use each?
Why ask it
Tests fundamental SQL knowledge that's used daily.What to look for
Clear explanations with practical examples. Should understand when data loss from joins matters and how to handle it. - 2
You receive a dataset with missing values, duplicates, and inconsistent formats. Walk me through your data cleaning process.
Why ask it
Data cleaning is 80% of the job. This reveals their systematic approach.What to look for
Methodical approach: identify scope of issues, document assumptions, handle missing values appropriately (imputation vs. deletion), deduplicate with reasoning, and validate results. - 3
How would you identify and handle outliers in a dataset?
Why ask it
Tests statistical knowledge and critical thinking about data quality.What to look for
Should mention multiple methods (IQR, z-scores, domain knowledge) and emphasize that outliers aren't always errors—they may be legitimate data points requiring investigation. - 4
Write a SQL query to find the top 5 customers by total order value in the last 12 months, including their order count.
Why ask it
Tests practical SQL writing ability with aggregation, filtering, and ordering.What to look for
Correct use of GROUP BY, SUM, COUNT, WHERE with date filtering, and ORDER BY with LIMIT. Bonus for considering edge cases.
Cohesyve
Screen Data Analyst candidates before you ask any of these
Cohesyve builds a Data Analyst assessment from your job description so interview time goes to people who have already shown they can do the work.
Analytical & Problem-Solving Questions
These questions evaluate how candidates approach ambiguous problems and derive insights.
- 5
The marketing team reports that website conversions dropped 20% last month. How would you investigate this?
Why ask it
Tests structured analytical thinking and business problem-solving.What to look for
Systematic approach: define the metric precisely, segment the data (by channel, device, geography, user type), look for correlations, check for data quality issues, and form hypotheses to test. - 6
How would you design a dashboard for a sales team? What metrics would you include and why?
Why ask it
Evaluates business understanding and ability to think about end-user needs.What to look for
Should ask clarifying questions about the audience, prioritize actionable metrics over vanity metrics, and demonstrate understanding of sales KPIs (pipeline, conversion rates, revenue, forecast accuracy). - 7
Explain a complex analysis you've done to a non-technical audience. How did you communicate the findings?
Why ask it
Communication is critical. Analysts who can't explain findings can't drive impact.What to look for
Clear narrative structure, use of analogies and visualizations, focus on "so what?" rather than methodology, and ability to tailor communication to the audience.
Statistical & Visualization Questions
These questions assess statistical literacy and data presentation skills.
- 8
Explain the difference between correlation and causation. Give an example from your work where this distinction mattered.
Why ask it
Tests statistical literacy and critical thinking about data interpretation.What to look for
Clear understanding with practical examples. Should mention confounding variables, the need for controlled experiments, and the risks of drawing causal conclusions from observational data. - 9
When would you use a bar chart vs. a line chart vs. a scatter plot? How do you choose the right visualization?
Why ask it
Evaluates data communication and visualization best practices.What to look for
Thoughtful matching of chart type to data and message: bar for comparisons, line for trends over time, scatter for relationships. Should mention audience and clarity as key factors. - 10
What is a p-value and how do you use it in practice? What are its limitations?
Why ask it
Tests depth of statistical knowledge beyond surface-level understanding.What to look for
Accurate definition (probability of observing results given the null hypothesis is true), practical use in A/B testing, and awareness of limitations (p-hacking, arbitrary thresholds, sample size dependency).
Running the interview well
- 1Include a practical SQL test or take-home analysis. Technical interviews reveal more than conversation alone.
- 2Ask candidates to walk through their portfolio or a past project. How they explain their process is as important as the result.
- 3Test communication by asking them to explain a technical concept simply. Great Data Analysts are also great communicators.
- 4Look for intellectual curiosity. The best Data Analysts ask "why?" and dig deeper rather than accepting surface-level answers.
- 5Evaluate their approach to ambiguity. Real-world data problems are rarely well-defined.
Common questions
Should I include a SQL test in the Data Analyst interview?
Yes, a practical SQL test is highly recommended. It's the most reliable way to assess hands-on data querying skills. Use realistic business scenarios rather than trick questions. Allow candidates to use documentation and focus on problem-solving approach.
How do I assess analytical thinking vs. just tool knowledge?
Present ambiguous business problems and observe how candidates structure their approach. Tool knowledge can be taught; analytical thinking is harder to develop. Look for hypothesis formation, systematic investigation, and the ability to draw actionable conclusions.
What are red flags in a Data Analyst interview?
Watch for: inability to explain statistical concepts, no questions about business context, over-reliance on tools without understanding underlying methods, poor communication of findings, and lack of curiosity about data quality issues.
Cohesyve · Skill assessments for hiring
Assess Data Analyst candidates before you interview them
Cohesyve turns a job description into a role-specific assessment with a scoring rubric. Each candidate gets a different version, so questions cannot be shared between applicants.
1,500+
assessments completed
50%
faster time-to-hire
90%
completion rate
5 min
from JD to assessment
No credit card · 10 free candidates · Plans sized to your hiring volume
For candidates
Preparing for a Data Analyst role yourself? Practise on the same AI job simulations companies use — 5 free assessments a month, no card required.
From the blog