Why business dashboards lose trust and how we fixed ours

One dashboard I inherited was technically correct and still useless. Sales used one number, finance used another, and ops had a spreadsheet that everyone secretly trusted more than the BI tool. The fix started with a meeting nobody wanted: define the metric in plain English before touching SQL. For revenue, we wrote down whether refunds counted, what timezone closed a day, how test orders were ex…