SQL SERVER – What is MDS? – Master Data Services in Microsoft SQL Server 2008 R2
- by pinaldave
What is MDS?
Master Data Services helps enterprises standardize the data people rely on to make critical business decisions. With Master Data Services, IT organizations can centrally manage critical data assets company wide and across diverse systems, enable more people to securely manage master data directly, and ensure the integrity of information over time. (Source: Microsoft)
Today I will be talking about the same subject at Microsoft TechEd India. If you want to learn about how to standardize your data and apply the business rules to validate data you must attend my session. MDS is very interesting concept, I will cover super short but very interesting 10 quick slides about this subject. I will make sure in very first 20 mins, you will understand following topics
Introduction to Master Data Management
What is Master Data and Challenges
MDM Challenges and Advantage
Microsoft Master Data Services
Benefits and Key Features
Uses of MDS
Capabilities
Key Features of MDS
This slides decks will be followed by around 30 mins demo which will have story of entity, hierarchies, versions, security, consolidation and collection. I will be tell this story keeping business rules in center. We take one business rule which will be simple validation rule and will make it much more complex and yet very useful to product.
I will also demonstrate few real life scenario where I will be talking about MDS and its usage.
Do not miss this session. At the end of session there will be book awarded to best participant.
My session details:
Session: Master Data Services in Microsoft SQL Server 2008 R2
Date: April 12, 2010 Time: 2:30pm-3:30pm
SQL Server Master Data Services will ship with SQL Server 2008 R2 and will improve Microsoft’s platform appeal. This session provides an in depth demonstration of MDS features and highlights important usage scenarios. Master Data Services enables consistent decision making by allowing you to create, manage and propagate changes from single master view of your business entities. Also with MDS – Master Data-hub which is the vital component helps ensure reporting consistency across systems and deliver faster more accurate results across the enterprise. We will talk about establishing the basis for a centralized approach to defining, deploying, and managing master data in the enterprise.
Reference: Pinal Dave (http://blog.SQLAuthority.com)
Filed under: Business Intelligence, Data Warehousing, MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, T SQL, Technology Tagged: TechEd, TechEdIn