sql server 2008 r2 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
SQL Server 2008 R2 PowerPoint Presentation
Download Presentation
SQL Server 2008 R2

Loading in 2 Seconds...

play fullscreen
1 / 29

SQL Server 2008 R2 - PowerPoint PPT Presentation


  • 116 Views
  • Uploaded on

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‘

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'SQL Server 2008 R2' - callie


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
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
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
SOGETI

Capgemini Group

Sogeti and Business Intelligence

capgemini group

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

slide6
Data

The Problems with 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
Master Data

What is it ?

master data10

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

Master Data
master data management
Master Data Management

What is MDM ?

Core Capabilities

Benefits

what is mdm

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 mdm13
What is MDM?

Data

Existing Applications

Existing Applications

Master Data

Data

Existing Applications

Analytical Systems

New

Applications

Data

Historical Data

Data

what is mdm14

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?
mdm core capabilities

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
mdm benefits

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
Master Data Services

Concepts and Features

Core Capabilities

concepts and features

Models

Entities

Attributes

Members

Hierarchies

Derived

Explicit

Collections

Versions

Database

Concepts and Features
model

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
entity

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
member

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
attribute

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
hierarchy

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
demo overview
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
Business Case Demonstration

SQL Server

Analysis Services

Master Data

Excel

Source

Versioning

Governance

Workflow

Notification

thank you for your attention
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