1 / 29

SQL Server 2008 R2

SQL Server 2008 R2. Master Data Services. Pierre-Louis Usselmann, Ben Watt SOGETI Switzerland pierrelouis.usselmann@sogeti.com, ben.watt@sogeti.com. Agenda. Sogeti 2‘ The problems with Data 2‘ What is Master Data ? 3‘ Master Data Management 5‘ Master Data Services 10‘

wyoming-irwin
Download Presentation

SQL Server 2008 R2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server 2008 R2 Master Data Services Pierre-Louis Usselmann, Ben Watt SOGETI Switzerland pierrelouis.usselmann@sogeti.com, ben.watt@sogeti.com

  2. Agenda • Sogeti 2‘ • The problems with Data 2‘ • What is Master Data ? 3‘ • Master Data Management 5‘ • Master Data Services 10‘ • SS2008 R2 MDS Demo 30‘

  3. SOGETI Capgemini Group Sogeti and Business Intelligence

  4. 4 disciplines and 2 brands € 8’710 Million 92’000 employees Capgemini Group 20’000 employees Answer to all IT needs that require Proximity: * Technical Assistance * Small/Medium Projects * Maintenance “Big deals” IS Business Process Outsourcing Design & Integration of Enterprise Solutions Technological Transformation Program Business Transformation Economic Performance Improvement

  5. Sogeti and Business Intelligence

  6. Data The Problems with Data

  7. The Problems with Data It takes us too long to introduce products. Product information is in too many places, and we don’t have a system or process for managing all of the information that we need to offer our products. We have customer data spread across many systems. We don’t know which data is right, and we can’t see our complete relationship with our customers.

  8. Master Data What is it ?

  9. Five types of data in enterprise

  10. Master data, which may include reference data, is information that is key to the operation of business Master Data

  11. Master Data Management What is MDM ? Core Capabilities Benefits

  12. Decouples master information from individual applications Becomes a central, application independent resource Ensures consistent master information across transactional and analytical systems Simplifies ongoing integration tasks and new application development Addresses key issues such as data quality and consistency proactively rather than “after the fact” in the data warehouse What is MDM?

  13. What is MDM? Data Existing Applications Existing Applications Master Data Data Existing Applications Analytical Systems New Applications Data Historical Data Data

  14. MDM is the discipline of providing an authoritative source for referential data in your organization. MDM is a continuous process, involving Technology & Tools People Processes MDM objective is creating and maintaining consistent and accurate lists of Master Data What is MDM?

  15. Hierarchy Management Governance and Stewardship Workflow Management Flexible and business user centric data modeling Source and IT system synchronization Matching, Cleansing & Standardization Authoring Master Data Versioning MDM Core Capabilities

  16. Creating and maintaining a high quality, consistent set of Master Data leads to Coherent and correct reporting & regulatory compliance An authoritative source of information used throughout your organization The ability to evolve Master Data to accommodate changing business needs MDM can also facilitate the merging of multisource environments e.g. as a result of mergers and acquisitions MDM Benefits

  17. Master Data Services Concepts and Features Core Capabilities

  18. Models Entities Attributes Members Hierarchies Derived Explicit Collections Versions Database Concepts and Features

  19. Container of logical entities Unit of data versioning Boundary for entites relationships Typically named for their „primary entity“ 1-N models per MDS instance RDBMS metaphor : Database OLAP metaphor : Cube Model

  20. Container for master data („members“) Identifies the attributes for entity members Can be related to each other (1:1, 1:N, N:M) Examples : Products, Customers, Country 1-N entities per Model RDBMS metaphor : Table OLAP metaphor : Dimension Entity

  21. An instance of an entity Define the attribute values for the instance Can be related to each other (1:1, 1:N, N:M) Examples : „BK-M18B-40“, „Mountain 500 Black, 40“ 1-N members per entity RDBMS metaphor : Record OLAP metaphor : Dimension member Member

  22. A data value associated with an entity member Text, numeric, datetime, link, ... Examples : Name, Size, Color, Width, Height Can be sourced from another entity Domain based attribute 1-N attributes per entity RDBMS metaphor : Column OLAP metaphor : Attribute Attribute

  23. Relational arrangement of entity members Types Derived : Based on attributes Explicit : each member can have one parent assigned 1-N hierarchies per model RDBMS metaphor : Parent/Child relationship OLAP metaphor : Hierarchy Hierarchy

  24. MDS Core Capabilities

  25. Master Data Services Demo

  26. Demo Overview Model: Geography Entities: Region, Country, Status Members:France, Germany, Hungary, … Attributes: Population, Square km, … Hierarchy: Country →Region (derived)Country → Sales Volumes (explicit) Workflow: Business Rules Security: User Access Import/Export

  27. Business Case Demonstration SQL Server Analysis Services Master Data Excel Source Versioning Governance Workflow Notification

  28. Thank you for your Attention! • For more Information please contact Pierre-Louis USSELMANN BIPractice Manager pierrelouis.usselmann@sogeti.com +41 (0) 76.220.78.78 Ben WATT Microsoft BIConsultant ben.watt@sogeti.com +41 (0) 61.205.41.00

More Related