End-to-End SQL Server Master Data Services with Peter Myers!
End-to-End SQL Server Master Data Services with Peter Myers!
Peter Myers has worked with Microsoft database and development products since 1997. Today, he specializes in all Microsoft BI products and provides mentoring, technical training, and training course content authoring for SQL Server, Office, and SharePoint. Peter has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with solid experience backed by current MCSE and MCT certifications. He lives in Melbourne, Australia and has been a SQL Server MVP since 2007.
His presentation describes how SQL Server 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 master data processes.
This session will be of interest to data stewards, ETL developers and ETL administrators to appreciate what SQL Server 2012 (or 2014) Master Data Services can achieve.
Facebook event!
КОГА: 12.02.2015
МЯСТО: Microsoft Bulgaria
ВХОД: СВОБОДЕН