How do I use master data in Excel?

What is master data in Excel?

With the SQL Server Master Data Services Add-in for Excel, you can load filtered lists of data from Master Data Services (MDS) into Excel and then work with it just as you would any other data. When you are done, you can publish the data back to MDS where it's centrally stored.

How do you connect master data in Excel?

To connect to an MDS repository1In the MDS Add-in for Excel, on the Master Data tab, in the Connect and Load group, click the arrow under the Connect button and click Manage Connections.2On the Manage Connections dialog box, in the New connection section, click Create a new connection.3Click New.

How do I set up master data?

Getting Started With Your MDM Program1Identify sources of master data. ... 2Identify the producers and consumers of the master data. ... 3Collect and analyze metadata for your master data. ... 4Appoint data stewards. ... 5Implement a data governance program and data governance council. ... 6Develop the master data model. ... 7Choose a toolset.

What does Master Data Services do?

Master Data Services enables you to manage a master set of your organization's data. You can organize the data into models, create rules for updating the data, and control who updates the data. With Excel, you can share the master data set with other people in your organization.