Before making another copy, run the reuse test
Most organizations cannot eliminate every extract, cache, warehouse, or local file, nor should they. Some copies are necessary for performance, disaster recovery, regulatory isolation, or offline work. The goal is to make duplication a deliberate design choice rather than the default response to every new reporting request.
1. Name the source of truth. Identify the governed dataset, business owner, technical steward, and approved definitions. If no one can name the source of truth, interoperability will spread confusion rather than resolve it.
2. Identify why a copy is being requested. Is the reason speed, access, tooling, transformation, resilience, or simply habit? A clear reason makes alternatives easier to evaluate.
3. Test access without movement. Check whether the consuming tool can query the data through a supported connector, catalog, or open format. Verify actual performance and permissions rather than assuming that a standards label guarantees compatibility.
4. Verify controls end to end. Test row and column restrictions, data classification, audit logs, service identities, and how policy changes propagate. A single successful query is not proof of governance.
5. Calculate the full copy cost. Include storage, refresh pipelines, data transfer, reconciliation, support, incident response, and the effort of explaining why two versions disagree. Compare that total with the performance and operating cost of shared access.
6. Choose a lifecycle. If a copy is justified, record its owner, refresh expectation, expiry or review date, and what happens when the source definition changes. Temporary extracts should not silently become permanent systems.
Start with one frequently copied dataset, such as customer, product, or sales history. Map every downstream copy and its reason for existing. Then select one low-risk consumer to test governed reuse. The measure of success is not the number of platforms connected. It is fewer conflicting versions, less maintenance, and no loss of control.
CLOSING
The October releases are not the end of data duplication. They are evidence that data access, discovery, and policy enforcement are being redesigned around shared assets. That brings an old management question back into focus. Are we copying information because the business needs a separate version, or because the systems were never designed to share it well? The answer shapes cost, trust, and the speed of future analytics work. Shared data only creates value when people know which information to trust and how to use it.
If any of this edition’s topics connect to challenges your organization is working through, we are glad to continue the conversation.
data@work is published by SVA Consulting. Each issue is designed to help business leaders understand what is changing in the data and analytics landscape, why it matters, and what to do with it.