How would you move a team that constantly sends you ad hoc data requests toward answering more of their own questions?

What the interviewer is looking for

• This question tests stakeholder management. Clarifies requests, sets expectations on timing, handles challenges to numbers calmly and builds trust over time.
• What to bring out: Finds common request patterns, builds self-service dashboards or datasets, trains users and keeps time for deeper analysis.
• Expect a follow-up like: How would you handle someone who keeps asking anyway?

Another way it may be asked: Sales asks you for a new spreadsheet every day. How would you change things so they rely on you less?

A structure to follow: STAR, with the weight on Action and Result

1. Step 1

   Situation

   One or two sentences: where, when and what was at stake. Pick a real example you were close to.

2. Step 2

   Task

   What you personally were responsible for. Say "I", not only "we", so the stakeholder management you showed is visible.

3. Step 3

   Action

   The two or three things you did and why you chose them over the alternatives. This should be about half your answer.

4. Step 4

   Result

   What changed, in your own measure of it, and what you would do differently. Only use numbers you can stand behind.

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

• Describing what the team did without saying what you did.
• Choosing an example with no clear outcome, or one you cannot answer detailed questions about.
• Ending on the action and skipping the result and what you learned.

How to practise it

Write two bullet points for each STAR letter, then say the answer aloud in about two minutes.

Related questions

• Tell me about a time someone questioned your numbers. How did you respond?
• What's the difference between an inner join and a left join, and when could picking the wrong one give you misleading numbers?
• You're handed a spreadsheet of sales with duplicate rows, mixed date formats and some blank regions. How would you clean it up?
• How do you decide which kind of chart to use for a particular piece of data?
• Weekly sign-ups dropped fifteen percent last week. Walk me through how you'd figure out why.

Browse all questions