Business Analyst Intern Interview Questions: SQL, Cases and Requirements

Business analyst intern interviews sit between data and people. Companies want to see that you can turn a vague request from a stakeholder into clear requirements, pull and check the numbers with SQL or Excel, and explain a recommendation in plain language. In consulting firms the same title often means a case-style interview, so read the job description to see which kind you face. 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 business analyst intern interview looks like

Questions that come up, and what strong answers contain

1. A manager says the sales dashboard is wrong. What do you do? Ask what looks wrong and compared with what, reproduce it, check the source data and filters, reconcile with a trusted total, then fix and explain.
2. How would you gather requirements for a new internal tool? Identify stakeholders and users, interview them about the current process and pain points, write requirements as user stories with acceptance criteria, confirm priorities and get sign-off.
3. What is the difference between a functional and a non-functional requirement? Functional describes what the system does, such as 'approve an expense'; non-functional describes how well, such as response time, security or availability.
4. Write a query for the number of orders and revenue per customer in the last 30 days, top ten only. A date filter, a GROUP BY on customer, SUM and COUNT, ORDER BY descending and LIMIT, plus a word on duplicate orders or refunds.
5. Map out how a customer return works at a retailer. A swimlane or step list: customer, store or warehouse, finance; decision points; handoffs where delays happen; and one improvement.
6. Two stakeholders want conflicting things. How do you handle it? Clarify the goal each one serves, make the trade-off visible with data, escalate to whoever owns the priority if needed, and document the decision.
7. Tell me about an analysis that changed a decision. The question, the data, what you found, who acted on it and what happened.

Two sample answers

How would you gather requirements for a new expense-approval tool?

I'd start by finding everyone it touches: employees who submit, managers who approve, and finance who reimburse. I'd interview a few from each group about today's process and where it breaks, and ideally watch someone submit an expense. Then I'd write user stories such as 'As a manager, I want to approve from my phone so I don't delay payments', each with acceptance criteria. I'd rank them with the project sponsor, flag non-functional needs like audit history, and get the priority list signed off before design starts.

A manager says the dashboard is wrong. What do you do?

I'd ask exactly which number looks wrong and what they expected, because 'wrong' often means a different definition. Then I'd reproduce it, check the filters and date range, and compare the total with the source system. In one class project, a revenue chart was double-counting orders with two shipments; a join on shipments rather than orders caused it. I'd fix the logic, add a note on the definition, and tell the manager what changed.

What interviewers expect from an intern

• SQL and spreadsheet skills you can use without notes.
• Clarifying questions before solutions.
• Structured communication: the answer first, then the evidence.
• Comfort working with people outside your team.

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

Mistakes that cost offers

• Jumping into analysis before understanding what decision the stakeholder faces.
• Writing requirements that cannot be tested, like 'the tool should be easy to use'.
• Presenting a chart without a recommendation.
• Weak SQL fundamentals, especially joins that silently duplicate rows.

A two-week prep plan

1. Days 1 to 4: SQL every day: joins, GROUP BY with HAVING and one window function; see our SQL interview questions.
2. Days 5 to 6: Excel lookups, pivot tables and a small cleaning exercise.
3. Days 7 to 9: write user stories and acceptance criteria for an app you use daily, and draw one process map.
4. Days 10 to 12: one business case a day out loud, ending with a recommendation.
5. Days 13 and 14: behavioral stories and two mock interviews.

Timing matters as much as preparation: see our internship recruiting timeline, and once you are in, turning an internship into a return offer. Before the last round, prepare your questions to ask at the end of an intern interview.

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 business 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

Is a business analyst intern interview technical?

Usually moderately: SQL or Excel tests are common, plus requirements and case questions. Consulting-firm BA roles lean on case interviews instead.

What is the difference between a business analyst and a data analyst intern?

Data analysts focus on the numbers; business analysts also own requirements, processes and stakeholder communication.

Do I need to know agile terms?

Basic ones help: user stories, backlog, sprint and acceptance criteria come up often in BA interviews.

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.