Data Analyst Intern Interview Questions: SQL, Excel and Case Questions

Data analyst intern interviews focus on whether you can pull the right numbers with SQL or spreadsheets, check them, and explain what they mean for the business. This page covers the rounds to expect, the questions that come up with what a strong answer contains, two sample answers, what interviewers expect from an intern, the mistakes that cost offers, and a two-week prep plan.

What the data analyst intern interview looks like

Questions that come up, and what strong answers contain

1. Write a query to find the top five products by revenue last month. Correct filtering by date, aggregation and ordering, and handling ties.
2. What is the difference between a VLOOKUP and an INDEX MATCH, or a pivot table and a formula? When each is appropriate and their limits.
3. How would you check that a report is correct? Reconcile totals, spot-check rows, compare with a previous period and question outliers.
4. What does this chart tell you? The main pattern, a caveat about the data, and the question you would ask next.
5. Tell me about a time you found an error in data. How you noticed, how you confirmed it and what you did to prevent it again.
6. How would you explain a drop in sales to a manager? A clear structure: what changed, where, when and the likely causes, with evidence.
7. Which visualization would you use to show change over time? A line chart, and why a pie chart would not work.

Two sample answers

Tell me about a time you found an error in data.

In a club budget spreadsheet I noticed that monthly totals didn't match the bank statements. I traced it to duplicated rows from two exports. I removed them with a unique-ID check, reconciled every month and added a simple check formula that flags mismatches. The treasurer now uses it every month.

How would you explain a drop in sales to a manager?

I'd start with the size and timing of the drop, then break it down by product, region and channel to find where it's concentrated. If it's one region, I'd check for data issues or a local event. I'd finish with the most likely cause, the evidence, and what I'd monitor next.

What interviewers expect from an intern

• Accurate, checked numbers.
• Clear explanations without jargon.
• Curiosity about why a number moved.

For the full-time version of these questions, see data analyst interview questions.

Mistakes that cost offers

• Presenting a number without checking it.
• Over-designing a chart instead of answering the question.
• Not asking what the business decision is.
• Weak SQL fundamentals such as joins and GROUP BY.

A two-week prep plan

1. Days 1 to 5: SQL every day, focusing on joins and aggregation.
2. Days 6 to 8: spreadsheet skills: lookups, pivot tables and charts.
3. Days 9 to 11: analyze a public dataset and write a one-page summary.
4. Days 12 to 14: practice presenting findings out loud and run a mock interview.

Timing matters as much as preparation: see our internship recruiting timeline, and once you are in, turning an internship into a return offer. Engineering candidates should also read software engineer intern interview questions.

Where CoPilot Interview fits

Intern interviews reward clear explanations of your own projects and coursework, and that takes practice out loud. CoPilot Interview is an AI interview assistant; its free AI mock interview builds data analyst intern questions from your résumé and the job description, reads them aloud, scores each spoken answer out of ten and shows a model answer to compare. The free plan gives 15 minutes a day of live help in sessions of up to 15 minutes, with AI mock interviews included, with no card, which suits a student budget. For real interviews and online assessments, follow your employer's rules.

Disclosure: CoPilot Interview is our product, so weigh what we say about it accordingly.

Frequently asked questions

Do data analyst intern interviews include Excel tests?

Often, yes: lookups, pivot tables and basic formulas are common, sometimes in a timed test.

How much SQL do I need?

Comfortable joins, GROUP BY with HAVING, and basic window functions are enough for most intern roles.

Should I build a portfolio?

A small one helps: one or two analyses of public data with a clear question and conclusion.

Can I use AI tools during an internship interview?

Only where the instructions allow it. Online assessments and many live rounds forbid outside help. Use AI to practice beforehand, and follow your employer's rules.