Every spreadsheet named "FINAL_v2_USE_THIS", every number that can't be traced to its source, every analyst morning spent reconciling conflicting files — this is the compounding cost of operating without a governed data platform. This document makes the case for change.
The Reality
Every organisation starts here. A sheet for sales. Another for inventory. A Drive folder that became the default filing cabinet. Over time, files fork, versions multiply, and the data driving decisions becomes uncertain. The simulation below visualises that environment at the data layer.
Live simulation · Each node is a spreadsheet or file. Lines show data dependencies. Red indicators mark version conflicts and broken links.
The Evidence
These figures come from independent research across thousands of organisations. The cost of poor data governance rarely arrives as a single event — it accumulates in every hour spent reconciling figures, every decision made on stale data, every compliance breach that could have been prevented.
Average annual cost of poor data quality per organisation
Gartner, 2022
Of an analyst's time spent finding, cleaning, and reconciling data — not analysing it
Harvard Business Review / TDWI
COVID-19 test results silently lost when NHS England's Excel file hit its row limit
Public Health England, Sept 2020
More likely to beat revenue goals — organisations with mature data governance vs. those without
Forrester Research
The Solution
A data platform does not replace your sources — it governs how data moves between them. Every record is validated, catalogued, and tracked. Every consumer — a dashboard, a report, a model — receives a guaranteed, traceable version of the truth. Failed validations are quarantined, not silently passed downstream.
Live simulation · Data flows from sources (left) through the governance layer (centre) to consumers (right). Red particles fail validation and are rejected before reaching consumers.
Framework
Governance is not a product — it is a capability. Without all three pillars operating together, data quality cannot be assured, compliance cannot be demonstrated, and trust in your numbers cannot be established.
Every record is tested against defined rules before it enters the platform. Type checks, range checks, referential integrity, and business logic all run automatically. Bad data is quarantined, not silently propagated to every downstream report.
Every transformation is recorded. When leadership asks "where did this number come from?", the answer is a click away — not a two-day investigation. A data catalogue means every dataset is discoverable, described, and owned.
Role-based access means each person sees only what they are authorised for. Every access event is logged. GDPR, HIPAA, SOX — demonstrating compliance becomes an automated audit export, not a manual reconciliation across shared Drive folders.
Real-World Evidence
These are documented, public cases. The consequences of spreadsheet-dependent data management are not hypothetical — they have played out at the scale of national health systems, energy markets, and global retail.
⚠ Cautionary · Public Health
In September 2020, Public Health England aggregated daily COVID results in Excel's legacy .xls format — a format capped at 65,536 rows by a design decision made in the 1980s. When the file exceeded that limit, rows were dropped silently. No warning. No alert. 15,841 positive cases went uncontact-traced as a direct result.
⚠ Cautionary · Energy Markets
In 2003, Canadian power company TransAlta lost approximately $24 million USD on electricity contracts because a bid spreadsheet contained transposed data from a copy-paste operation. The values were outliers — but without anomaly detection or lineage tracking, the error was submitted and accepted before anyone noticed. The loss was realised before it could be reversed.
✓ Transformation · Retail
Walmart's Retail Link gives every supplier real-time, governed access to store-level sales and inventory data. Instead of spreadsheet exports by email, suppliers see a live, validated, role-scoped view of their own product performance across thousands of stores. The platform processes over 2.5 petabytes daily with full lineage, access auditing, and row-level security.
The Difference
This is not a comparison of products — it is a comparison of operating models. Google Sheets is a capable tool. The question is whether your organisation's data operating model can scale, be trusted, and be audited.
| Dimension | Google Sheets / Drive | Governed Data Platform |
|---|---|---|
| Version of truth | Multiple versions in circulation; "correct" file unclear; manual reconciliation required before every decision | Single versioned, timestamped source of record; all consumers read the same data at the same version |
| Data quality | Depends on the person who entered it; no automated validation; errors propagate silently to all downstream consumers | Schema enforced at ingestion; validation rules run automatically on every record; failures quarantined before they propagate |
| Audit & lineage | Cannot demonstrate where a figure came from or how it was derived; spreadsheet version history is partial and per-file | Full lineage graph from source to consumer; every transformation logged; any number is fully reproducible and explainable |
| Access control | File-level sharing; link sharing creates uncontrolled exposure; no row or column granularity; revocation is manual per file | Role-based, row-level security; all access events logged and reportable; revocation is immediate and applies everywhere |
| Regulatory compliance | Cannot demonstrate consent management, data residency, or right-to-erasure across a folder of spreadsheets | GDPR, HIPAA, SOX controls built into the platform; compliance reports generated on demand with full audit trail |
| Scale | Performance degrades beyond ~100k rows; legacy .xls format has a hard 65,536 row limit that silently drops data | Designed for petabyte-scale volume, high velocity, and mixed data types — performance does not degrade as data grows |
| Analyst productivity | 80% of analyst time spent finding, cleaning, and reconciling data across multiple conflicting sources | Clean, catalogued, discoverable data — analysts spend time on analysis, not preparation |
Every month operating on ungoverned spreadsheets is a month of accumulated risk — in data quality, compliance exposure, and analyst productivity. A data platform assessment takes days, not months, and produces a clear picture of where the gaps are and what they are costing you.
Map all existing data sources, owners, and consumers. Surface duplication, inconsistency, and compliance exposure.
Select the right platform for your scale and budget. Define governance contracts, access model, and migration priority.
Migrate highest-value, highest-risk data first. Deliver value incrementally while building institutional capability.