10/09/2014 4:08:19 PM
This presentation 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 (or 2014) Master Data Services can achieve.
About the Presenter:
This presentation will be delivered by Peter Myers, an Australian IT professional who 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.
He has a broad business background supported by a Bachelor degree in applied economics and accounting, and he extends this with solid experience backed by current MCSE and MCT certifications. He has received the Microsoft Valuable Professional (MVP) award since 2007.
Venue: Microsoft Level 5, Building 4, Freshwater Place, Southbank , Melbourne, VIC |
Duration 5:30PM pizzas & drinks for 6:00 start, approx 7:45pm finish |
On: Tuesday, 25 November 2014