What is Master Data Management? Master Data Management (MDM) fixes data quality problems, creates clean master records, and manages changes in those records. That’s the short version.
The reality is, unsurprisingly, slightly more complicated.
Modern business is always in motion. So, something like this happens:
We know Business A and Business B share some clients. With customer data from several sources, we don’t know if John Smith on A Street and John Smith at #16 A St are the same person.
We need to know that. If we don’t know that, our analytics are off. Way off. And our business intelligence? Not quite so intelligent.
MDM gives us a data model to work from—a structure to help identify and fix conflicting data, remove duplication, create a single source record (sometimes called a golden record) and make sure that record and its data stays clean. Once created, a golden record can weather new mergers, channel expansion, diversification, divestitures, and a partridge in a pear tree. Or a half million partridges in a half million pear trees. That’s a lot of pear trees.
What does MDM offer? Here’s a quick list:
How does MDM help BI?
At the 2013 Enterprise IQ MDM and Data Governance Summit, the MDM Institute predicted the need for proactive, tightly-integrated data governance to marshal the growing volume of “living” data required for modern business operations. The future-forming of five years ago is today’s reality. Today, business intelligence is smart if the underlying data is accurate. And MDM builds accurate data.
Our merger example describes Business B bringing data from several different sources — databases, siloed legacy systems, even paper records. Each data source has slightly different rules and methods for entry, so the records have to be consolidated manually. When records need updating, those updates might have to happen in two or more places. That process will not be perfect.
MDM automates that process, using flexible, customizable rules. The result is a consolidated, error-free master data set designed to improve BI reporting accuracy. Snazzy charts and actionable visualizations are terrific tools—as long as they actually help you understand the finances, operations, and customers they’re
meant to represent.
The purpose of BI is to understand fundamentals: Product/service user profiles, key conversion pathways, engagement. If you’re pursuing bigger business, building toward bigger goals, you’ll need the best possible data quality, effectively aggregated in a long-term management system, to get you there. That’s MDM.
Is There A “One Size Fits All” Solution?
Our merger example illustrates a fundamental MDM challenge: Each situation is different. Business B has three data management systems, all separate. Business A has only one, but it is different from the Business B systems. Managing internal versus external data, various forms of external data, and aggregated data from separate external systems requires a broad spectrum of tools.
Once the business merger is complete, new data requirements will likely surface, changing the game again. Heraclitus said all entities move and nothing remains still. The popular paraphrase is “change is the only constant.” It’s not a new concept. But the sheer amount of data we deal with now would have staggered the ancient Greeks. Our world is bigger, more complex.
That said, the basic process for generating cleaner data, leading to stronger BI, can be expressed pretty simply.
How Do We Implement?
Identify the business driver and associated data.
Often, a single significant pain point is the beginning of a serious MDM conversation. This is a great place to start the MDM process—on a limited scale, with minimal impact on existing business processes (hopefully making them easier), requiring few additional stakeholders to sign off. Identify the pain point, define the data assets associated with it, and bring that information into the next step:
Evaluate current data quality.
Fact: Your data quality is suffering due to current business processes. We know that because you’re here. So let’s nail down some specifics. Are you Business A, with one siloed system? Are you Business B, with three incompatible systems requiring a lot of manual labor to integrate? Most businesses have some data management that works, and some that doesn’t. Some clean data, some that looks like the grey water you use to keep your flower garden happy. To solve the problem effectively, we need to know what kind of shape we’re in before we start.
Identify the integration path.
Our Business A/Business B situation has four different sources. Your business might have more. It might have less, but deeper integration challenges. If your data comes from a combination of hand-written index cards and cuneiform carved into stone tablets, you have a deep integration challenge. Better hire a couple of extra interns next summer.
Assess the business impact.
We’re starting from a single business driver to minimize impact, but there is always some impact. Cost and impact are the two aspects of implementation with the greatest potential for eliciting a “no” from stakeholders. Know the impact, and have a handful of solutions ready to head off the inevitable questions.
Choose an MDM implementation that best supports that path.
Due diligence is critical. All MDM solutions are not created equal; in fact, all MDM solutions are not even created to solve the same problems. There is no such thing as too much research. Make sure you understand what you’re bringing in. Choose wisely, and be everyone’s friend.
Don’t be the person who showed up to work late. Be the person who brought breakfast for the whole team.
The Profisee MDM platform provides exactly what we are looking for."
―Slobodan R.Read the full review
"MDM made straightforward for enterprise level initiatives."
―IT Enterprise ArchitectRead the full review
"Very affordable and user friendly. Great for modeling big data domains."
―User in Higher EducationRead the full review
"Great end-to-end product to make MDM easier for organizations."
―Internal ConsultantRead the full review
"Quick way to establish an MDM discipline. Software was easy to implement and manage."
―Director of Business IntelligenceRead the full review
"Proactive business partner, straight forward implementations, excellent vision"
―Business Intelligence ManagerRead the full review
"The price is right and the technical support is competent."
"Excellent integration with common platforms. Superb enterprise data management platform."
―User in AccountingRead the full review
"The best thing about the software is the UI, it is very nice and clear. It is very easy to understand."
―Administrator in Computer SoftwareRead the full review