Entry 15 from the book: Data Contracts in Practice


"Your article about future trends inspired us"
1 · The Problem in a Nutshell
Date: February 12, 2024
Manual post-processing is reaching its limits: Even small schema changes from suppliers paralyze the product pipeline and cause marketing campaigns to fail. Without binding Data Contracts with clear fields, formats, and SLAs, every catalog refresh remains a risky blind flight.
2 · Mini-Solution: The 3-Pillar Model (Bird's-Eye View)
Pillar | Question | Quick Win Today |
Asset Management | What do we have & where is it? | Create an inventory table with 4 columns (Data Type · Storage Location · Owner · Criticality) |
Access Management | Who is allowed to do what? | Review admin rights once a month and remove unnecessary access |
Accountability | Who is the Data Sponsor? | Appoint one responsible person per core dataset |
Quick Win from the Field: In one project, 127 customer duplicates were cleaned up – fewer misdirected mailings, more satisfied customers.
3 · What you can do NOW if you also have this problem
Search in your ERP or CRM for a typical entry with an "error message" or a note for correction.
Reconstruct the original error: What was the cause?
Derive a rule from this that automatically detects this error the next time.
4 · Cliffhanger
A seemingly small transposed number triggered a domino effect that almost jeopardized a major order. You can read how we stopped this at the last minute in Chapter 3 of the book.
5 · Want the Whole Story?
In the book “Garbage In, Business Out? — How Small Businesses Can Fix Their Data and Finally Trust Their Decisions” you’ll read practical examples of how this and many other problems were solved.
Bonus: Download the exclusive worksheet (5‑page PDF) and other free extras here → https://drive.google.com/drive/folders/1OevcHwAdZIhyTpXLUq4042cgb4NPjjEv?usp=sharing
Newsletter: Sign up here to get updates and new tools → https://garbageinbusinessout.hashnode.dev/newsletter
What information must your supplier finally deliver reliably for your process to run smoothly? Let us know!
Subscribe to my newsletter
Read articles from Thilo Wilts directly inside your inbox. Subscribe to the newsletter, and don't miss out.
Written by
