Datenqualität und Stammdatenmanagement: Ist Ihr Unternehmen reif dafür?

Datenqualität und

Stammdatenmanagement –

Ist ihr Unternehmen reif dafür?

Dr. Peter Mayer

Walldorf, 20. Mai 2015

SAP-Infotag Stammdatenmanagement

© BEI St. Gallen – Walldorf, 20. Mai, P. Mayer / 2

Business Engineering InstituteA spin-off of the University of St. Gallen

St. GallenHEADQUARTERS

2003FOUNDATION

Prof. Dr. Österle CHAIRMAN

Thomas ZerndtCEO

DivisionsCORPORATE DATA QUALITY MANAGEMENT

SOURCING IN THE FINANCIAL INDUSTRY

INDEPENDENT LIVING


The Competence Center Corporate Data Quality

(CC CDQ) comprises 30 partner companies

NB: Overview comprises both

current and past research partner companies.

ABB LTD. AO FOUNDATION ASTRAZENECA PLC BAYER AG BEIERSDORF AG

CORNING CABLE SYSTEMS

GMBHDAIMLER AG DB NETZ AG

DRÄGERWERK AG & CO.

KGAAE.ON SE

ERICSSON AB ETA SA FESTO AG & CO. KG HEWLETT-PACKARD GMBH IBM DEUTSCHLAND GMBH

KION INFORMATION

MANAGEMENT SERVICE

GMBH

MERCK KGAAMIGROS-

GENOSSENSCHAFTS-BUNDNESTLÉ SA NOVARTIS PHARMA AG

OSRAM GMBH ROBERT BOSCH GMBH SAP AGSCHWEIZERISCHE

BUNDESBAHNEN SBBSCHAEFFLER AG

SIEMENS ENTERPRISE

COMMUNICATIONS GMBH &

CO. KG

SWISSCOM AGSYNGENTA CROP

PROTECTION AG

TELEKOM DEUTSCHLAND

GMBHZF FRIEDRICHSHAFEN AG


Datenqualität und

Stammdatenmanagement


Was heisst reif ?


The CDQ Framework structures the design areas for

effective Master Data Management

Strategy

Strategy

System

Applications

Data Architecture

local global

Organization

Controlling

Processes and

Methods

Organization and

People


Strategy

Strategy

System

Applications

Data Architecture

local global

OrganizationControlling

Processes and

Methods

Organization and

People

An MDM strategy prevents from a purely reactive mode

Mandate

Business Goals

Objectives

Value Contribution

Scope

Strategic Roadmap

The whole organization needs to commit

to the MDM strategy


Strategy

Strategy

System

Applications

Data Architecture

local global


Processes and

Methods

Organization and

People

The establishment of a controlling system is

fundamental for the performance monitoring

Maturity Assessment

Progress Monitoring

Benchmarking

KPI System

Measurement Methods

Cockpit

Integration in Target Systems

The performance of the organization

and business critical data defects need

to be controlled using data quality

indicators!


Strategy

Strategy

System

Applications

Data Architecture

local global


Processes and

Methods

Organization and

People

Data Governance defines roles, tasks, responsibilities

and the organizational setup

MDM organizational setup

Role Model

Operational Concept

The required roles, tasks and

responsibilities need to be embedded

within the organization!


Strategy

Strategy

System

Applications

Data Architecture

local global


Processes and

Methods

Organization and

People

Process definitions and guidelines describe how data

governance is operationalized

Data Governance Processes

Data Lifecycle Processes

Metadata Management Processes

Standards and Guidelines

The use and maintenance of data and

metadata within the business processes

need to be transparent.


Strategy

Strategy

System

Applications

Data Architecture

local global


Processes and

Methods

Organization and

People

The data architecture integrates the data classes on

process and application level

Business Object Model

Corporate Data Models

Metadata

Data Quality Rules

Data Distribution and Integration

Architecture

There has to be a common

understanding of data and business

objects within the whole company!


Strategy

Strategy

System

Applications

Data Architecture

local global


Processes and

Methods

Organization and

People

The applications for master data management have to

respond to the business requirements

MDM Software

Integration Software

Data Quality Management

Software

Business Glossary

Data Modeling Tools

The requirements to MDM/DQM

applications need to be systematically

analyzed!


SAP Applications for Information Management

Strategy

Strategy

System

Applications

Data Architecture

local global

Organization

Controlling

Processes and

Methods

Organization and

People

CDQM Assessment &

Strategy Workshop

Data SAP MDG

SAP Sybase

Powerdesigner

SAP Data Services

SAP Solutions for Data

Migration

SAP Information

Steward

SAP MDG

SAP Information

Steward

SAP MDG

SAP Data Services

SAP NW Information

Lifecycle Management

SAP HANA

SAP System

Landscape

Optimization

SAP Information

Steward

SAP MDG

SAP NW Information

Lifecycle Management

SAP Data Services


Datenqualität und

Stammdatenmanagement


Wie können sie das wissen?


The Framework for CDQM is a standardized maturity

and benchmarking model

Download free PDF: http://benchmarking.iwi.unisg.ch/Framework_for_CDQM.pdf

Purchase print copy: http://www.efqm.org/en/tabid/260/default.aspx

Supporters/Contributers

http://benchmarking.iwi.unisg.ch/Framework_for_CDQM.pdf

http://www.efqm.org/en/tabid/260/default.aspx


A comprehensive maturity assessment evaluates how

MDM maturity advances over time

0

100

200

300

400

500

600

700

800

900

1000

t1 t2 t3 t4

Overa

ll s

co

re

Time

CDQM Performance

Key results

Customer results

People results

Society results

Applications

Data Architecture

Processes & Methods

Organisation & People

Controlling

StrategyThe questionnaire comprises 35

questions for the 6 design areas.

Questionnaire

Self Assessment Questionnaire

1 Strategy - OtC Customer MRD

N/A 1 2 3 4 5

0% 25% 50% 75% 100%

(a) x 2

(b) x 2

(c) x 4

(d) x 2

(e) x 3

TOP Strengths

TOP Improvement areas

Additional comments

Assessment scope:

Customer master data in the Offer to Cash process

*Priority of change or action

5 = Very High

4 = High

3 = Medium

2 = Low

1 = Very Low

Are there any strategic objectives and values of Shell’s customer

master data management defined in a well-documented and well-

communicated form?

Do top executives of Shell clearly show their support for customer

master data management by concrete action or favorable

statements?

Do the strategic objectives and values comply with Shell’s business

process strategy and is this compliance regularly reviewed and

managed?

Is there any strategic project planning or coordination of initiatives for

customer master data management at Shell?

Does Shell provide the resources needed for conducting customer

master data management according to given objectives and plans?

Su

bsta

nti

al

pro

gre

ss m

ad

e:

Majo

r p

rog

ress m

ad

e:

Fu

lly c

om

ple

ted

:

Pri

ori

ty(1

-5 o

r em

pty

fo

r "N

/A")

*:

No

t sp

ecif

ied

No

t yet

sta

rted

:

So

me p

rog

ress m

ad

e:

Establishing

awareness

Creating structures

Becoming effective


The CDQ Benchmarking Platform allows you to

compare yourself against other companies

56%

55%

42%

56%

65%

57%

62%

56% 57%

46%

48%

63% 59%63%

70%68%

61%

70%74%

71%

76%

90%88% 90%

87%91% 90%

94%

0.00%

25.00%

50.00%

75.00%

100.00%

Total Strategy Controlling Organizationand People

Processes andMethods

DataArchitecture

Applications

Self-Assessment Mean 0.75 Quantil Max


The Performance Dashboard supports the whole

assessment and benchmarking process

Assessment

Create and configure a

new Assessment

Good Practices

See how others

improved

Benchmarking

Compare against other

companies


The CDQM Framework has been applied in 40+ maturity

and benchmarking projects across different industriesAssessments within the last 15 months

Beiersdorf AG

Corning Cable Systems GmbH

Drägerwerke AG & Co. KGaA

Elektrizitätswerke des Kantons

Zürich

Novartis Pharma AG

Robert Bosch GmbH

Schweizerische Bundesbahnen

Siemens Enterprise

Communications GmbH & Co KG

Stadtwerke München

SWM Services GmbH

Swisscom IT Services AG

Telekom Deutschland GmbH

ZF Friedrichshafen AG


Interested in our publications?


Contacts & Internet Resources

http://www.iwi.unisg.chInstitute of Information Management at the University of St. Gallen

http://www.bei-sg.chBusiness Engineering Institute St. Gallen

http://cdq.iwi.unisg.chCompetence Center Corporate Data Quality

https://benchmarking.iwi.unisg.ch/CC CDQ Benchmarking Platform

Dr. Peter MayerBEI St.Gallen AG

CC Corporate Data Quality

[email protected]

Phone: +41 78 778 72 48

Data & Analytics

Datenqualität und Stammdatenmanagement: Ist Ihr Unternehmen reif dafür?