Don’t let master data become the “Master of Disaster” – Introduction to MDM/MDS

What is Master Data Management (MDM)

Master data represents the business objects which are agreed on and shared across the enterprise. It can cover relatively static reference data, transactional, unstructured, analytical, hierarchical and meta data.

Let me start by telling you what it is not. Master Data Management (MDM) is not a pure technological solution. It’s not a quick, pre-developed GUI to maintain data. To ensure sanitized master data, you need to include fundamental changes which are required in business processes. Often, the most complex master data management challenges are more policy related than technical (and policy is politically sensitive).

What is important to note, is that MDM consists of both creating and maintaining your master data. Creating a sanitized, consistent master data set is a waste of investment in function of time, money and effort, if the solution does not include tools and processes to this master data through updates. To do so, a Data Governance structure is usually set up (really mastering the Data) as part of a Master Data Management program. This process involves the roles of Data Owners, Data Architects and a Data Steward.

In order to implement a successful MDM program, it is important that the focus on people, processes and technology is in balance. Also archiving and keeping track of historical data needs to be part of the Master Data Architecture.

What is this master data?

Each organization holds master data, basic information consisting of customers, products, employees, processes, etc. This master data is essential for an organization in order to guarantee an optimum functioning of the organization. Most of the time, this master data is stored in different (duplicated) ways and systems. Every system has its own version of the truth, in totally incompatible ways. This makes it impossible to combine all data, and have a 360° view on the data. There are also other types of data that don’t fit in the existing systems, like configurations, pictures, logos, PDFs, etc. Usually, these are stored somewhere locally in each division.

Depending on the type and structure of the organization, the purpose, sources and targets of specific data, the same data can be master data for one company, and non-master data for another company.


Why Master Data Management?

Organizations are engaged in business intelligence, (re-)designing their systems, optimizing business processes, creating a single view of the customer and complying with external regulations. An adequately equipped MDM for this, is an crucial prerequisite. For that reason, MDM has gained a lot of importance within many large and medium-sized organizations.


The MDM process

Managing master data involves a whole process, which can be facilitated by specific technology. If we take this to the Microsoft SQL Server Stack, we are talking about MDS of course, but also SSIS, SSRS and DQS.
Here is an overview of what this process can look like:

Important in the whole process is also that:

  • A data steward is responsible for data management at a higher level. This person needs to have adequate business knowledge and connectivity.
  • The process is managed, monitored and supported by a technical team.
  • Source systems are able to get an additional Column (MDS_ID) that can be updated by the feedback system of MDS.
  • Source systems are really the sources of the system and have their own Interface (GUI) for managing their own data. The systems need to be able to operate independently from each other and from MDS. It’s not MDS’s target to create extra constraints between different applications. The goal is to get added value from applications that (re-)use the same data and reports, or execute other data requests over different applications.



    1. MDM is not a tool. It involves people, processes and technology.
    2. MDM/MDS can bring a lot of added value to your business.
    3. MDM/MDS can avoid duplicated key data, therefor simplifying data management.
    4. Consider the following when you start an MDM project within your company:
      • What is the purpose/target of it (business)?
      • What is the added value (business)?
      • Which technology are we going to use to support this process: in House / External (technical)
      • Do we have someone that will/can manage our master data (business)
      • Which extra skills / trainings do we need to foresee (technical)?
Power BI Desktop is een prachtige tool om snel data-analyses te kunnen uitvoeren. Je connecteert op een databron, importeert en...
dba image
DBA is not that scary
Often when talking to people who are looking for a career path in the data world I feel like there...
How do you link an SCD Type 2 table in Power Query?
This article uses a simple example to demonstrate how to link an SCD Type 2 table in Power Query to...
How to easily parse JSON in Power BI Desktop
Sometimes you want to use JSON data in Power BI. And sometimes Power BI doesn’t exactly do what you want...
Power BI reports as monitoring tool
Who has not created monitoring reports or beautiful dashboards in Power BI? Would it not be great to show off...
Your Modernization Journey starts now
Recently Microsoft introduced SQL server 2022. We wrote this post to make sure you won’t be missing out on all...