Triple Strategy For Data Warehouse Projects

Enterprise Data Warehouse (EDW) should deliver unified, consistent information but usually doesn’t, due to conflicts in master data and a lack of common understanding of data sense (metadata). So, the typical complaints from IT and business users are:

“We have implemented the enterprise data warehouse and don’t need metadata management. Why does EDW deliver information of improper quality?”

“We have an enterprise Master Data Management (MDM) system in production. Why can’t we agree on data sense and terminology?”

“We have developed our company’s business glossary. Why do our business users still receive contradictive reports?”.

Strategy

These problems can be solved by the parallel execution of three strategic projects:

Metadata Integration

Enterprise metadata integration establishes a common understanding of data and master data sense.

Master Data Integration

Master data integration eliminates data and metadata coding conflicts in various information systems.

Data Integration

Data integration provides end users with data as a single version of the truth based on consistent metadata and master data.

This triple strategy provides effective interaction of data, metadata, and master data management systems, eliminates modules with similar functionality, lowers the total cost of ownership, and increases user confidence in EDW data.

The triple strategy allows the implementation…