Skip to main content

Business Analyst

Describe how you have used data, whether spreadsheets or queries, to back up a recommendation.

TechnicalMid levelTests: Data analysis
Drill this questionCreate a free account to answer out loud with Ava and get feedback.

What the interviewer is looking for

  • This question tests data analysis. Uses spreadsheets, queries or reporting tools to test assumptions and back recommendations with numbers.
  • Strong answers: Explains the question, data source, analysis method and limitations, and how the findings changed the decision.
  • Likely follow-up: How did you check the data was accurate?

Another way it may be asked: Tell me about a time numbers helped you prove a point to the business. What data did you use and how?

A structure to follow: Answer, explain, example, limits

  1. Step 1

    Answer

    Give your direct answer in the first sentence so the interviewer knows where you are going.

  2. Step 2

    Explain

    Say how it works or why you would do it that way, in plain words before jargon.

  3. Step 3

    Example

    Anchor it in something you have actually done or seen, with the detail that shows hands-on experience.

  4. Step 4

    Limits

    Say when your approach would not be the right one. It shows judgement.

This is guidance on shape, not a script. Use your own real experience and facts; never invent details to fill a gap. See the STAR guide and answer frameworks.

Common slips

  • Reciting a definition without showing you have applied it.
  • Using terms you cannot explain if asked a level deeper.
  • Claiming experience beyond what you can discuss in detail.

How to practise it

Say the answer in 90 seconds, then answer the follow-up as if it were a new question.

Browse all questions

Describe how you have used data, whether spreadsheets or queries, to back up a recommen... | How to answer