Methods for Improving Data Quality of Material Data
- by 7wData
Data quality is essential across the entire business footprint. Between the quality of the material data and the accuracy and confidence of the inventory data, most companies can either find or spend a small fortune. Since much of what I have done my past relates to procurement and master data, I’d like to share some insight into improving the data quality of your material data.
At one point, I was a main driver to continuously improve the e-procurement and business intelligence platforms from which some bad inputs were generated. We knew we had to analyze the material data to find the problems, but we had to break the data down into logical categories or other manageable chunks. We started by breaking materials into direct and indirect materials. We found that when we looked at the direct material space that it was a more simplified path. It had a limited supply base and a limited set of SKUs (Stock Keeping Units for the uninitiated) to deal with. When it comes to something more manageable, you can tackle that with people first, then start digging in with data tools. If you throw a good number of skilled analysts working together, you can see what needs to be done with the differing descriptions and material numberings. You can put some people governance process to consistently review the data on a regular basis to get the data clean and drive synergies. That works for manageable data sets.
Then there was the indirect space or what is typically referred to as MRO. It’s literally impossible to use the same methods because it’s far too complex.
[Social9_Share class=”s9-widget-wrapper”]
Upcoming Events
Shift Difficult Problems Left with Graph Analysis on Streaming Data
29 April 2024
12 PM ET – 1 PM ET
Read MoreYou Might Be Interested In
Beyond Acronyms: Humanizing Big Data and Information Governance through Mindful Storytelling
10 Jul, 2016“Data governance applies to everything that we do,” shared Janice Haith, Department of Navy’s Deputy CIO. And, being responsible for …
Project Data Sphere Enables Wide Use of Clinical Trial Health Data
12 Jul, 2016Despite the billions of private and federal dollars spent on cancer research each year, it is estimated that nearly one …
Why CyberSecurity And AI Are Top Governance Risks For Board Directors And CEOs?
6 Oct, 2020Ask most board directors and CEO’s to define cybersecurity and artificial intelligence in a board meeting and have them share …
Recent Jobs
Do You Want to Share Your Story?
Bring your insights on Data, Visualization, Innovation or Business Agility to our community. Let them learn from your experience.