Business Process Improvements
The analysis of master data and MDM processing logs can reveal interesting opportunities for business process improvements. We show how, as long as you collect the right data and know how to analyze it, you can drive significant business benefits that extend beyond just data quality improvements.
By Martin Dunn
Our industry is renowned for inventing new terms to describe old things. My current favorite is Data Scientist which has been described as a data analyst with additional business acumen and statistical analysis skills. Most of our data analysts, some of whom have been working with data since VSAM KSDS was considered leading edge, would consider that this data scientist role is what they have been doing their entire career. At least they have a modernized name for their profession, which is nice.
In a very Gil Grissom-esque manner our data scientists uncover some interesting insights in the analysis of master data and MDM processing logs. Here are two of my favorite examples of the last few years.
1. Gaming the System
When building a customer master at distributor/e-tailer we noticed an abnormally high number of duplicates. Based on our experience of customer data over many projects the analysis at this client indicated that something was wrong. Many of the duplicates arose from misspellings in both name and address fields. In the days prior to MDM these variations would be enough to create a new customer account whereas the fuzzy matching within the MDM solution immediately revealed the problem.
The client pointed out that reps were paid an additional bonus for opening new accounts. Therefore, they were not surprised that sometimes a rep would “game the system”, however they were shocked to see the metrics.
Our analysis of the MDM matching logs isolated the worst offenders and resulted in far tighter controls being introduced. By creating alerts when duplications were being trapped in the MDM Hub, the client was able to establish an immediate intervention and “training” program to help reps with their data entry challenges.
Not only did the client eliminate unjustified bonus payments, but they also reduced the back-office admin and customer support costs associated with multiple accounts for a single customer.
2. Data Entry Misery
We were working with a client to migrate their legacy ERP from JDE to SAP. This process involved the construction of a Customer Master file with the appropriate sold-to, ship-to and bill-to address information. Our analysis showed an unusually high number of duplicate ship-to addresses that, on further analysis (by a data scientist), turned out to be localized to a particular plant and oddly, for high-volume customers.
It turned out that in JDE a high-volume customer could have a default shipping address in the system, but the order entry screen still allowed the entry of an override shipping address if necessary. If a new shipping address was entered, it was stored in JDE as a valid shipping address for the customer. The employee that captured the order for the plant in question had been working at this company for more than 10 years. She had diligently re-entered the shipping address on every order because she was unaware that if the order was going to the default location, no override was required.
We have no idea how much time was invested over the years typing redundant data but I’m sure she would have appreciated the heads-up a decade ago.
MDM provides the platform to analyze data flows to uncover anomalies that would otherwise remain hidden within operational applications. The business benefit of MDM extends beyond just the obvious advantages of better data quality to identifying opportunities for business process improvement.
Martin Dunn was the co-founder of Delos Technology which developed the MDM technology marketed under the Siperian brand. The Delos MDM technology introduced many MDM concepts that are now widespread within the MDM discipline including a data steward console to adjudicate match results, opt-in synchronization, cell level delta detection and the concept of measuring trust.
Martin is now a partner with Gaine Solutions and continues to advance the techniques by which enterprise Master Data is managed.
Key Questions to Ask During Master Data ConsolidationsTypical master data consolidation starts with combining the operational master records from all the data silos where they exist. The key aspect being, creation of master data indexes to support single view; knowing...
Opt-in SynchronizationNot all operational systems will choose to, or be able to, consume the changes made to master data in an MDM hub. The reasons for being out-of-synchronization may be technical, regulatory, political or economic but at some point it will be...
Changing a Match RuleWhen we are talking to companies about our MDM platform we cover a broad range of topics, from measuring ROI, to more technical questions about the way the software operates. A common technical question is "How do we change a match rule?" Our...
Ready to master data mastering?
Subscribe to our mailing list and we’ll send you courses, insights, product updates, and more. Get to know the ins-and-outs of your Gaine MDX platform, features, and solutions.