Master Data Services - PowerPoint PPT Presentation

master data services n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Master Data Services PowerPoint Presentation
Download Presentation
Master Data Services

play fullscreen
1 / 23
Master Data Services
139 Views
Download Presentation
tallulah
Download Presentation

Master Data Services

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Master Data Services …with Microsoft BI • Henrik Nordtorp • Mads Carsten Brink Hansen • Lorents Nord-Varhaug • Microsoft Services – BI and SQL team

  2. Agenda

  3. What is Master Data? • Master Data Managements enables • Central administration of data • Effective sharing (producing and consuming) • Continuous quality management • Ease of access for business users • Master Data is • Slowly changing reference data across systems • Typical Master Data • Customers, Partners, Employees • Products, Accounts, Units • Locations, Areas • Business Rules, Licenses • Master Data • Master Data Management

  4. Traditional system architecture - Spaghetti CRM ERP DW PowerPivot HR SSAS SSAS Produc-tion

  5. MDS hub and spoke architecture CRM ERP Customers Accounts MDS DW PowerPivot HR Employees Products SSAS SSAS Produc-tion

  6. Master Data Services Components ValidationAuthoring business rules to ensure data correctness Modeling Entities, Attributes, Hierarchies • MDS Excel Add-In Web UI Versioning Role-based Security and Transaction Annotation • Master Data Stewardship Loading batched data through Staging Tables Consuming data through Views Workflow / Notifications 6

  7. Mds AND ANALYTICAL SOLUTIONS …or get faster started or shorter time-to-market… • Mads Carsten Brink Hansen • Senior Consultant • Microsoft Services • madsch@microsoft.com

  8. The business problem Sourcing of hierarchies are infeasible they simply does not exist sourcing does not meet time constraints but hierarchies are still requested by the business [for analytical solutions]

  9. The solution: SQL Server 2012 MDS Empower your business by allowing the business to: Create Hierarchies [and Dimensional Attributes] Maintain the Hierarchies [and Dimensional Attributes]

  10. MDS OLTP DW Data Marts SSAS/ BISM

  11. The IT Department The Business Create Models [Placeholder] Create Integration and Business Rules IT Related stuff Create Entities Create Hierarchies Maintain Entities and Hierarchies

  12. Business Case: how to implement a customer segment hierarchy [in 5 mins.]

  13. The business doing the Homework

  14. demotime

  15. The it department: Create Integration [ETL] From MDS Insert into dw.owner.table select a, b, c from mds.dbo.view To MDS: Insert into mds.stg.entity_table select a, b, c from dw.dbo.table

  16. conclusion MDS can significantly shorten time-to-market for BI Solutions In combination with PowerPivot this can further be accelerated

  17. Experiences from customer implementations

  18. Master Data FOcus Operational Master Data Analytical Master Data No Master Data BI Cube BI Cube Master Data Repository Data Warehouse Master Data Repository Data Warehouse ERP ERP XXX ERP ERP XXX ERP ERP XXX ERP CRM ERP CRM ERP CRM

  19. WHY Microsoft MDS

  20. Lessonlearned

  21. OBJECTIVES

  22. Resources • MDS videos and slides: http://msdn.microsoft.com/en-us/sqlserver/ff943581.aspx • DQS videos and slides: http://technet.microsoft.com/en-us/sqlserver/hh780961 • Presentations at earlier TechEd events: http://channel9.msdn.com/Events/TechEd • SQL Server – Enterprise Information Management: http://www.microsoft.com/sqlserver/en/us/solutions-technologies/enterprise-information-management.aspx