290 likes | 417 Vues
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‘
E N D
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‘ • SS2008 R2 MDS Demo 30‘
SOGETI Capgemini Group Sogeti and Business Intelligence
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
Data The Problems with Data
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.
Master Data What is it ?
Master data, which may include reference data, is information that is key to the operation of business Master Data
Master Data Management What is MDM ? Core Capabilities Benefits
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?
What is MDM? Data Existing Applications Existing Applications Master Data Data Existing Applications Analytical Systems New Applications Data Historical Data Data
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?
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
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
Master Data Services Concepts and Features Core Capabilities
Models Entities Attributes Members Hierarchies Derived Explicit Collections Versions Database Concepts and Features
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
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
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
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
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
Master Data Services Demo
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
Business Case Demonstration SQL Server Analysis Services Master Data Excel Source Versioning Governance Workflow Notification
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