Behavioral · medium

A number on the dashboard suddenly spikes. Walk me through what you check.

Asked in BI Developer interviews.

Short answer

Decide whether it is real or an artifact: did upstream data change, did a join fan out, did a filter break, or did one real event drive it. Segment to localize it, compare against the source of truth, and only then explain it to stakeholders. Reporting a broken number as real is worse than catching it late — verify before you raise it.

How to answer it

Decide whether it is real before you tell anyone. A spike reported as real and then withdrawn costs more trust than a spike caught late.

Check in this order, because each step is cheaper than the next:

Then, and only then, explain it, with the evidence attached: "Orders up 40% on Tuesday, all from one campaign in one country, source system confirms 3,200 orders against a usual 800. Real, and here is why."

If it was an artefact, fix the cause and add the check that would have caught it, so the same spike cannot get to a dashboard twice.

Related questions

Practice this for real