The Procurement Software Podcast

Fixing Dirty Data – Susan Walsh is The Classification Guru


Listen Later

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

      • ...more
        View all episodesView all episodes
        Download on the App Store

        The Procurement Software PodcastBy James Meads

        • 5
        • 5
        • 5
        • 5
        • 5

        5

        5 ratings


        More shows like The Procurement Software Podcast

        View all
        Freakonomics Radio by Freakonomics Radio + Stitcher

        Freakonomics Radio

        32,073 Listeners

        The Joe Rogan Experience by Joe Rogan

        The Joe Rogan Experience

        223,412 Listeners

        Art of Procurement by Philip Ideson

        Art of Procurement

        64 Listeners

        Odd Lots by Bloomberg

        Odd Lots

        1,788 Listeners

        Pivot by New York Magazine

        Pivot

        8,866 Listeners

        Pod Save America by Crooked Media

        Pod Save America

        86,341 Listeners

        The Daily by The New York Times

        The Daily

        111,479 Listeners

        Inside the Strategy Room by McKinsey & Company

        Inside the Strategy Room

        175 Listeners

        The Procurement Show by The Procurement Show

        The Procurement Show

        0 Listeners

        Fintech Leaders by Miguel Armaza

        Fintech Leaders

        28 Listeners

        Money Stuff: The Podcast by Bloomberg

        Money Stuff: The Podcast

        367 Listeners