End-to-End SQL Server 2012 Master Data Services
This session describes how SQL Server 2012 Master Data Services can be used to implement Master Data Management (MDM). It introduces the discipline of MDM and maps common processes to the feature set of Master Data Services.
Topics include defining models, entities, attributes and hierarchies, to store and manage master data. Additionally, administrative tasks including business rules to validate data, the import and export of master data, model versioning, and permission management will be described. The two Microsoft user interfaces (the Master Data Manager web application, and the Excel add-in) will be covered, in addition to T-SQL scripting opportunities to automate processes.
This session will be of interest to data stewards, ETL developers and ETL administrators to appreciate what SQL Server 2012 Master Data Services can achieve.
Sorry, there are no downloads available for this session.
Peter Myers has been working with Microsoft database and development products since 1997. Today he specializes in Microsoft Business Intelligence and provides mentoring, technical training and course content authoring for Microsoft SQL Server and Microsoft Office. Specifically, he works with SQL Server Integration Services, SQL Server Analysis Services (data modeling and data mining), SQL Server Reporting Services, Microsoft Excel, PowerPivot and PerformancePoint Services.
He has a broad business background supported by a Bachelor degree in applied economics, and he extends this with current MCITP and MCT certifications. He has been a SQL Server MVP since 2007.
Peter is an established presenter and enjoys sharing his enthusiasm for Microsoft products by presenting in classrooms and at user group meetings, technical events and conferences.
The video is not available to view online.