Building A Better Data Warehouse

The devil, as they say, is in the detail. Your organization might have invested years of effort and millions of dollars in an enterprise data warehouse, but unless the data in it is accurate and free of contradiction, it can lead to misinformed business decisions and wasted IT resources.

We’re seeing an increasing number of organizations confront the issue of data quality in their data warehousing environments in efforts to sharpen business insights in a challenging economic climate. Many are turning to master data management (MDM) to address the devilish data details that can undermine the value of a data warehousing investment.

Consider this: Just 24 percent of data warehouses deliver “high value” to their organizations, according to a survey by The Data Warehousing Institute (TDWI).[1] Twelve percent are low value and 64 percent are moderate value “but could deliver more,” TDWI’s report states. For many organizations, questionable data quality is the reason why data warehouses fall short of their potential.

Our new white paper, MDM and Data Quality for the Data Warehouse,” takes an in-depth look at the issue, including the shortcomings of costly and time-consuming manual approaches to managing data reliability. From a data integration perspective, MDM provides a codeless solution for recognizing and resolving inconsistent customer, product, supplier, partner, and employee data with these capabilities:

  • Match-and-merge logic for identifying and consolidating duplicate records from source systems
  • Extensive cell-level lineage and history, which supply a detailed audit trail for data content
  • A central repository for all relationship data across all sources

Implementing MDM along with data quality as the definitive source for data warehousing reduces data integration complexity, as well as development and maintenance chores. And it gives the business the high-quality data it needs to make informed decisions, and visibility and auditability that are important for regulatory compliance. Learn more in our new white paper.

[1] TDWI, 2010 TDWI Benchmark Report, September 2009.

This entry was posted in Data Quality, Data Warehousing, Enterprise Data Management, Master Data Management and tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>