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


Another Business Intelligence Books
Download