Fixing Dirty Data - Susan Walsh is The Classification Guru

The Procurement Software Podcast

Susan Walsh is The Classification Guru, bringing you affordable solutions to clean up your data before undertaking any digital transformation project. Dirty data is the scourge of most organisations, both large and small. We discuss the approach, the root causes of poor data, what to do about it, and how maintaining key data is the key. Doing it once and then washing your hands of the problem is a recipe for disaster!

Fixing your Dirty Data - Get your data classified, so you can deliver savings opportunities or commence your digital transformation

2:05 Susan's story of how she became a data specialist, from quite an unconventional work experience history! 6:45 Why starting with the basics and making data FUN is core to Susan's approach to data. 7:25 Where to get started if you're a complete beginner to the topic of cleaning your data. A "Data 101" of how to get the basics in place and what the best first steps to take should be. 9:20 Consistency is key - the first rule of data classification. Using a master taxonomy that sits above any local level data classification. 10:12 The first step: Supplier normalisation (vendor master harmonisation) to remove duplicate records of the same vendor. 11:31 Once vendor records have been harmonised, Susan then explains how the next steps are really dependent upon the client's setup and to what level of detail they wish to categorise their data. 13:32 What is the recommended programme for ongoing follow-up and data cleansing reviews? We dig in to how much ongoing maintenance is necessary, depending on the specifics of each case. 15:49 Proactive roles which can be playes to ensure data governance is given the necessary importance in roles and responsibilities throughout teams. 18:58 Susan gives her best answer to anyone facing the conundrum of how to put together a business case for senior leaders to sign off on the costs of a data cleansing initiative. 20:58 The opportunity cost question: Is it more cost effective to do this in-house? Why would you task your category managers or procurement analysts with this, when it's not their core job? 22:30 Ownership of data (or lack of!) Why this conundrum scuppers most organisations, and what can be done to change this. Where should data ownership sit, especially in a larger organisation? 24:29 The role that a Chief Data Officer could play in future, and how this could disarm some of the politics of "who's data is this anyway"? Useful Links:

  • Art of Procurement Episode 301

How to connect with Susan:
  • The Classification Guru website
  • Susan's LinkedIn profile

How to connect with James:
  • Download our Tech Map for Enterprise
  • Download our Tech Map for Mid-Market
  • Download our Tech Map for SMEs
  • Find your perfect procurement tech solution in our Software Finder app
  • Sign up for the Procurement Software Newsletter
  • Book an Intro Call and let’s talk all things Digital Procurement!
  • Connect with James on LinkedIn

To listen to explicit episodes, sign in.

Stay up to date with this show

Sign in or sign up to follow shows, save episodes and get the latest updates.

Select a country or region

Africa, Middle East, and India

Asia Pacific

Europe

Latin America and the Caribbean

The United States and Canada