Intro to Master Data Warehousing A Bridge Over Siloed Data

1
Intro to Master Data WarehousingA Bridge Over
Siloed Data

• Rob Paller, ConsultantBaseline Consulting

2
Overview

• Data as an enterprise asset
• What is data?
• What is an asset?
• Data as an asset
• How does data compare?
• Types of Data
• Master Data
• Master Data Management (MDM)
• The Master Data Warehouse

3
What is data?

• Data is the raw material ... used by
  information consumers to create information.
• -- DMReveiw.com

4
24 Gigabytes
5
Data Overflow
6
What is an asset?

• an item of value owned
• Websters Dictionary

7
(No Transcript)
8
Data as an asset?
9
Value is quantifiable
10
Helps achieve strategic goals
11
Awareness of the assets importance
12
How does data compare?
13
Checkpoint

• Data as an enterprise asset
• Types of Data
• Transaction
• Reference
• Metadata
• Master Data
• Master Data Management (MDM)
• The Master Data Warehouse

14
Types of Data

• Transaction Data
• Reference Data
• Metadata

15
Checkpoint

• Data as an enterprise asset
• Types of Data
• Master Data
• Master Data Management (MDM)
• The Master Data Warehouse

16
Master Data and the State of Michigan is
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
about people, places, and phenomena.
25
Checkpoint

• Data as an enterprise asset
• Types of Data
• Master Data
• Master Data Management (MDM)
• 5 Levels of Master Data Maturity
• Master Data Benefits
• Master Data Challenges
• The Master Data Warehouse

26
Master Data Management

• is the set of disciplines and methods to ensure
  the currency, meaning, and quality of a the
  States reference data within and across subject
  areas and systems
• -- Customer Data Integration Reaching a
  Single Version of the Truth Dyche, Jill and
  Evan Levy. Wiley (July 21, 2006)

27
5 Levels of Maturity for Master Data Management
28

• Level 5 Enterprise Data Convergence
• Level 4 Business Rule and Policy Support
• Level 3 Centralized Hub Processing
• Level 2 Peer-Based Access
• Level 1 List Provisioning
• Level 0 No Master

29
Master Data Benefits
30
Master Data Challenges
31
Checkpoint

• Data as an enterprise asset
• Types of Data
• Master Data
• Master Data Management (MDM)
• The Master Data Warehouse

32
Current Environment
DCH
CSES
DHS
33
The Master Data Warehouse
34
Thank You!