Microsoft Master Data Services (MDS)

Master Data Issues

Have you ever been in a meeting where different managers present the same information or metric with vastly divergent results?  The meeting subsequently focuses on debating the reasons for the discrepancy rather than the organisation’s performance associated with that metric and what needs to done to improve it.

Unfortunately this scenario is not uncommon, most companies do not have a precise view about their customers, products, suppliers, inventory or even employees.  Confusion can arise with data flowing in so many directions as shown below.


Leverage Technology

Fortunately, cost-effective solutions exist to facilitate the consistent alignment of master data or reference data across the organisation to create a single, unified view.  The combination of refined business process using enabling technology is commonly referred to as Master Data Management (MDM).

From a technology standpoint, there are many different levels of sophistication that can be implemented, from a simple spreadsheet to manage the hierarchies to an expensive custom built solution on specialised software.  Within certain editions of the recent few releases of SQL Server exists an optional installable component called Master Data Services (MDS) which enables the integration and rules based alignment of reference data readily managed by the relevant business users.


MDS is a highly customisable software component that can be integrated into other systems facilitating a real-time publish/subscribe of reference data (think new customer registrations via a website).  It provides the platform upon which purpose built software can used enabling additional functionality such as reference data de-duplication or address validation.

Successful Outcomes

Using this technology, QMetrix MDM consultants successfully help customers to eliminate the need to provide ongoing explanations to management about why their monthly financials are inconsistent and save many man days per month lost trying to reconcile hierarchies between systems.  In one example, QMetrix consultants implemented an MDM solution using Microsoft MDS for a major financial institution to regain up to 10 man days that were being lost each month trying to line up the Chart of Accounts between 3 different systems.

QMetrix has worked for over a decade in BI and has often seen a solution’s success compromised by the lack of reference data management.

Call us on 1300 785 336 or email us to get in touch and learn how QMetrix can help your organisation suffering with master data issues.

Related Articles

QMetrix is ISO/IEC 27001 certified: Information Security Management System

QMetrix is pleased to announce we are now ISO/IEC 27001 certified, demonstrating our commitment to information and data security. Highlighted by various data breaches in recent times, cyber threats and criminal activities are on the rise. It is paramount for organisations to uphold high security standards and manage cyber-risks even before they occur in order

QMetrix is named 2024 APJ Workday Adaptive Planning Partner of the Year

QMetrix is named Winner of the 2024 Adaptive Planning Partner of the Year Award – APJ at the annual Workday Sales Kickoff. QMetrix announced it was named a winner of the 2024 Adaptive Planning Partner  of the Year Award – APJ by Workday, Inc. (NASDAQ: WDAY), a leading provider of solutions to help organisations manage

Stay in touch

Get the latest insights from QMetrix straight in you inbox.

Scroll to Top

This website uses cookies to ensure you get the best experience on our website. More Information

Skip to content