Better Information through Master Data Management - MDM as a Foundation for BI

Introduction ............................................................ 1
Enterprise data .................................................. 1
Transactional Data ......................................... 1
Analytical Data ............................................................ 2
Master Data............................................................. 2
The Data Quality Problem .......................................... 2
The MDM Solution ....................................... 3
MDM - Data Warehouse Interfaces ............................ 4
Dimensions ............................... 4
Cross-Reference ....................................... 5
Hierarchies ....................................... 5
Analytics Example ................................ 5
Star Schema ................................... 6
Query Results ...................................... 6
The Data Quality Problem ...................... 6
MDM Capabilities ...................................... 7
Data Model ............................................... 7
Change Management ................................... 7
Person Duplicate Identification ........................ 8
Company Duplicate Identification ...................... 8
Duplicate Elimination & Cross-reference ................... 9
Attribute Survivorship ................................ 9
Product Standardization................................... 9
Hierarchy Management ........................... 10
Updated Star Schema ............................ 10
Re-Run the Query .................................... 10
Top Ten Example ............................. 11
Pre-defined Mappings ..................................... 11
Analytical & Operational MDM...................................... 11
Conclusion ................................................ 13

Download