Data governance best practice: look after your data COAT

Data governance best practice: look after your data COAT

If you’re familiar with my work, you may already know that good data governance includes accuracy, and that means your data needs to have its COAT on. It’s a simple and effective data management framework I created and we apply to all of The Classification Guru’s services and your data.

But did you know this, your data COAT also has to be maintained, it's not good enough to just put it on, you need to keep it on, all year round.

Hold on, what’s a data COAT?

New to The Classification Guru? Don’t know what a data COAT is? This quick video explains all.

Let’s put it this way… you wouldn’t spend your hard-earned money on a fancy high-performance winter jacket to protect you from the elements and then leave it in a heap to get dirty. And you wouldn’t treat it roughly, so it falls apart at the seams. So, why do that with your data? If you’ve just spent thousands on expert data classification, you need to maintain it. This way it stays expertly classified!

How long do I need to keep my data COAT on for good data governance??

Good data governance means you should keep wearing data COAT all year round, regardless of the season. Your data will almost certainly be correct once it's been cleaned, it’ll have its COAT on. It’ll be Consistent, Organised, Accurate and Trustworthy.? But, unless you look after it, it will only stay that way for a short period of time.

This data COAT will keep you warm, dry and take care of your data governance needs.

Updates and changes mean that before you know it, your once neat and tidy data sets will contain unclassified data, data that’s been incorrectly classified by your team or typos, missing information and cut & paste errors to name but a few issues.

Specifically, it is essential that you continue to check and maintain your data for any errors that can have a knock-on effect.

For example, you might have a supplier that must be classified in a specific category.?Even if it seems unusual, you must make sure it’s classified like this.?For example, you might usually classify Google as ‘Cloud’ or ‘Software’ under ‘IT’, but your organisation is using Google Ads. In this instance, it should be classified as ‘Advertising’ under ‘Marketing’.?By having a data COAT on, you can help ensure that regardless of which team member is classifying the data, it will always be correct.?And if you’re using technology or AI, you can add these rules in to make sure the tech classifies correctly too.

It’s also the same for address data; define whether you want to spell out counties or states in full or abbreviate them. And with phone numbers do you want to add in dialling codes? What about the use of spaces, brackets and dashes? Get everyone inputting correctly at the point of entry. This will save you so many hours, days or weeks in the future having to fix everything.

It’s really important to document your COAT and have clear guidelines to make sure everyone is doing the same process the same way. It can be hard to incentivise people to do this, but if their accuracy is tied to performance and you have the ability to track changes and errors, this will be a great motivator.

How do I keep my data COAT on?

There’s no big secret here. The key to keeping your data COAT on is maintenance, it’s really a case of good housekeeping – you need to check and maintain it on a regular basis.

In the same way that you regularly give your jackets and coats a wash and fix-up, regularly checking in with your data makes life easier in the long run. Just like sewing up any loose buttons and keeping your garments fresh, it’s a good idea to check in on your data on a monthly or quarterly basis. Remember, if you have a lot of data and many, many inputs, you’ll need to check it more frequently.

Perhaps you have a 3rd party supplier checking your data for you. This is a great idea! But, it’s still really important you spot-check your data once in a while to ensure your supplier is fulfilling their obligations.

And, if your team is running the checks for you, make sure you check in with their progress now and then. That way you can be sure everyone is following the data COAT methodology and that they are cleaning, checking and maintaining the data in the correct way.

As part of the maintenance process, you should also spot-check your data to make sure it’s clean. Just because it was accurate last month, doesn’t mean it will be tomorrow.? Cut & paste errors and accidental deletions can all happen and it’s important to check for them so that they don’t become a bigger problem. This is particularly important if your data is being used as training data for AI or GenAI.

So, how frequently should you maintain your data COAT?

Well, let’s go back to that winter jacket analogy.

Leaving your jacket or COAT hanging on a coat stand for a week doesn’t matter. It probably doesn’t matter if you leave it for a month or two. But leave that once clean and cosy COAT too long and by the time you decide you want to wear it again it’ll smell fusty, it’ll be dusty, the moths might even have had a go. It will need a decent wash at the very least.


It’s the same with your data. Data that’s not maintained will slowly become unusable over time. Incorrect or conflicting information will build up. AI outputs become corrupted. And because you can’t afford to use bad data, you end up spending significant time or money to fix the problem. Ouch.

  • Regular data maintenance means:
  • Better data accuracy for better decisions
  • Avoiding a time-consuming and costly data clean-up operation (because your data won’t slowly become corrupted).
  • A better-trained and more responsive data team. Doing a little bit of something regularly is always easier than doing a lot of it occasionally.

How The Classification Guru can support your data governance

Need help with your data governance? We’re happy to oblige. The Classification Guru team can review your existing data, run a quick check and flag any errors. Alternatively, we can carry out an in-depth check and fix any mistakes so your data is as perfect as it possibly can be.

Want to be sure you’re always making decisions based on the right data? Outsource your regular data maintenance service to The Classification Guru. Get in touch to tell us more and receive a no-obligation guideline quote.

Enjoyed this post? Read this one next – The Dangers of Dirty Data.

Or why not read Between the Spreadsheets for even more tips?


Yoav Harel

Co-Founder & CEO at Makat | Weekly insights from the trenches | Independent electronics distribution 2.0 ??

2 周

Love the COAT approach, but like any good system, it’s only as strong as the people maintaining it!

Richard Kaufman

Retired C.P.M., MBA, Senior Manager, Supply Chain Compliance - Electric / Engine System at Collins AEROSPACE SYSTEMS

2 周

Great article, Susan. I spent 40 years in procurement, the last 10 managing supply chain compliance, auditing and being audited to policy, contract requirements and federal regulations. Serious question, is the lack of data governance being exposed by DOGE due to incompetence or by intentional design? My thoughts, both, mainly the latter given this information from 2024: "One of the reasons it is so difficult to get an accurate picture of how FWA erodes the effectiveness, efficiency, and availability of government services is that more than 6-in-10 (61%) of respondents said their government departments simply don’t track the impact of FWA on their agency." https://www.thomsonreuters.com/en-us/posts/wp-content/uploads/sites/20/2024/08/2024-Government- -Waste-Abuse.pdf Federal Fraud, Waste, Abuse, GAO report: "We estimated that the federal government could lose between $233 billion and $521 billion annually to fraud." [report link] https://www.gao.gov/products/gao-24-105833 I'd appreciate your thoughts on that.

Steven McIntosh

Taking your customers from "What??" to "Woah!!" | Talking tech so even non-techies get it. | Get the Ultimate strategy for your Clients. Type "Wow!" and I'll send it to you.

2 周

There's something I've always loved about your posts. You take a difficult (and some would call boring) topic and make it accessible to everyday bums like me. Thanks :)

Dr. Joe Perez

?Data Analytics Expert ?Internat'l Keynote Speaker ?CTO? ??? ?Amazon Best-selling Author??Senior Systems Specialist ??? ?? ?Gartner Peer Community Ambassador of the Year 2023

2 周

You have such a wonderful way of captivating people with your top-notch content, Susan; thank you for sharing! I appreciate the value you bring to the data community with your quality and consistency, ma'am!

要查看或添加评论,请登录

Susan Walsh的更多文章

  • Fabulous February

    Fabulous February

    And just like that we are at the end of another month. This one has gone particularly quickly for me, as I've been…

    4 条评论
  • Progress & Plans: January Roundup

    Progress & Plans: January Roundup

    Welcome everyone to the first newsletter of the year! It's been off to a busy start, I've been writing the 2nd edition…

    8 条评论
  • What is supplier normalisation and why does it matter?

    What is supplier normalisation and why does it matter?

    Supplier normalisation (or, if you’re from the States, supplier normalization) is the process of giving your existing…

    35 条评论
  • November/December roundup

    November/December roundup

    Merry Christmas everyone! Boy has this been a year and a half, but it's ended on better news with some great…

    20 条评论
  • Overloaded October

    Overloaded October

    Hi Everyone, Here we are in November already, I can't quite believe where this year has gone! First up I have to say…

    8 条评论
  • The Dangers of Dirty Data

    The Dangers of Dirty Data

    Dirty data. It’s a term that can mean very different things to different people.

    8 条评论
  • Superb September

    Superb September

    Hi Everyone, Boy has it been a busy month, I finally finished two really tough projects, and had some amazing…

    3 条评论
  • Anarchic August

    Anarchic August

    Hi Everyone, I'm so glad it's a new month as August was absolutely crazy! We've been working on two very complex and…

    10 条评论
  • Jumpin' July

    Jumpin' July

    Well hello there, how has your month been? Mine started out very busy with non-work events - Abba Voyage, Robbie…

    10 条评论
  • The secret to digital transformation is not clean data…. it’s people

    The secret to digital transformation is not clean data…. it’s people

    Shocker, I know, but having recently moderated panels on digital transformation in the data and procurement space, one…

    20 条评论

其他会员也浏览了