Grounded in: r/analytics — "why is so much data work still in Excel?" (77 upvotes, 75 comments, 2026-06-03)
Every company with a "real" BI tool still has a shadow spreadsheet. You've seen it: the finance team's Google Sheet with last month's revenue re-added by hand, or the growth lead's personal Excel tab that "just tracks things properly." The dashboard exists. People still don't use it as the source of truth.
The instinct is to blame the tool. Swap Looker for Tableau, add another chart, run a training session. None of it sticks, because the tool was never the problem. The actual complaint, once you read past the "Excel is outdated" jokes, is trust: nobody believes the dashboard's number enough to stop re-deriving it themselves.
Dashboards disagree, and nobody can say why. Ask two people in the same company for last quarter's active-user count and you'll often get two different answers — one from the product dashboard, one from the ops spreadsheet — and neither side can explain the gap in under five minutes. Industry surveys back up what that thread is describing anecdotally: one recent analysis put the share of organizations that don't fully trust their own data for decision-making at 67%, up from 55% a year earlier. That's not a tooling gap. That's a definition gap.
Three things usually cause it:
- The metric was never actually defined once. "Active user" means something different to the person who wrote the product query than to the person who wrote the finance query — different time windows, different exclusions, different joins — and nobody wrote down which definition is canonical.
- The dashboard is built on a moving target. A chart built directly on an operational table reflects right now, not the historical state of the business at the time someone looked at it. Pull the same report at 9am and 2pm and get different numbers, and suddenly nobody trusts any number pulled from it.
- There's no way to check your work. Even if the dashboard is right, there's no cheap way to verify it without either trusting blindly or re-deriving the number by hand — so people default to re-deriving it, every time, forever. That's the shadow spreadsheet's whole reason to exist.
The fix isn't a better chart. It's making the definition the product. A metric ledger — one place where "active user" is defined once, versioned, and referenced everywhere downstream — kills the definition-drift problem at the root, because there's no longer a second definition to drift from. And a golden-query gate — a small set of known-answer queries that have to keep returning the right number before anything ships — gives people the "can I check this without re-deriving it by hand" answer they've been missing. Instead of "trust the dashboard," it's "here's the receipt."
None of this is about a bigger warehouse or a fancier visualization layer. The shadow Excel file isn't a discipline problem or a training problem. It's what happens, rationally, when the actual metric definition lives in someone's head instead of somewhere checkable. Fix that, and the spreadsheet stops being necessary — not because anyone was told to stop using it, but because there's finally something worth trusting more.