Tell me how you have used a spreadsheet or your company's system to spot a trend or solve a supply problem.

What the interviewer is looking for

• This question tests erp & spreadsheet skills. Gives concrete examples of using an ERP or warehouse system and spreadsheets to track, analyse and report supply data.
• Strong answers: Names the tools and features used, how they cleaned or analysed the data, and the decision or fix that resulted.
• Likely follow-up: How did you make sure the data you were using was accurate?

Another way it may be asked: Describe a time you pulled data into a spreadsheet or system report and it helped you fix something.

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.

Related questions

• Tell me about a time you caught a mistake before it caused a problem, at work, school or anywhere else.
• A truck that was due this morning has not arrived and the warehouse is waiting. What do you do first?
• The system says we have forty units on the shelf but the picker finds only twenty-five. How would you work out what happened?
• How do you keep track of open purchase orders and make sure suppliers deliver on time?
• What documents do you check before an international shipment leaves, and what can go wrong if one is incorrect?

Browse all questions