Data Quality in SQL Server 2012 Part 5: Master Data Services Excel Add-In

In the previous post in this series (sorry for the delay), I talked about the Client for DQS. It seems appropriate then that I introduce the desktop client for MDS. In this case, the client is Excel, through a freely-downloadable add-in that runs in Excel 2007 or 2010. You can download the add-in from the…

1

Data Quality in SQL Server 2012 Part 2: Introducing Master Data Services

In the previous blog post, I introduced the concept of Master Data Management as a methodology to improve data quality by creating a “master” version of important information. Master Data Services is Microsoft’s technology for implementing Master Data Management. It is included in SQL Server 2008 R2 Enterprise and SQL Server 2012 Enterprise and Business…

5

Data Quality in SQL Server 2012 Part 1: Introducing Master Data Management

Data quality is important and data quality mistakes can be expensive. Imagine a situation where a company has two systems, each with their own data set. One system is for CRM, the other is a financial system. Both systems have information about customers. Now an employee needs to send an invoice to a customer. What…

2