System Design · medium

How do you validate a new dashboard before you ship it?

Asked in BI Developer interviews, in the System Design round.

Short answer

Reconcile totals against a trusted source (finance, the source system, a known-good query), spot-check a few rows end to end, and confirm filters and date logic behave at the edges — empty selection, a single day, a year boundary — at every drill level. A dashboard that is wrong once loses trust for good, so validation is the job, not an afterthought.

How to answer it

Validation is the job, not a step after it. A dashboard that is wrong once loses trust for good, so ship it only when you can say how you know it is right.

Then a short note in the dashboard's description: what was reconciled, against what, on which date. When a number is questioned later, that note is the answer.

Related questions

Practice this for real