Subscribe to DMU

Search DMU Library

Categories

Data Warehousing

Foundations of Data Warehousing

Data warehousing is the proven architecture for delivering subject-oriented, stable, analytical information for decision making.  Effective data warehouse development provides many business benefits. Introduction A data warehouse is an enviroment that combines an integrated decision support database with software to

Read More

Increasing the Business Value of Business Intelligence

Organizations can find increased value in business intelligence and analytics efforts through the use of various data delivery strategies. Introduction Like many organizations, your company probably has invested significant time, effort, and money into establishing your data warehousing and business

Read More

Dimensional Data Modeling Fact Qualifier Matrix

Fact Qualifier Matrix capabilities can be expanded to improve the value of conformed dimensions in business intelligence and analytics systems Introduction The venerable Fact Qualifier Matrix (FQM) has been a tool long used for demonstrating for dimensional models how fact and

Read More

Security Threats in the Data Warehouse Environment

Data warehouse implementations are vulnerable to internal as well as external security threats.  Follow these mitigating steps to reduce the risks. Introduction Security threats exist against your information resources, whether the systems are accessible through the Internet or buried deep

Read More

Migrating From “Independent” Data Marts

Independent data marts cause many problems in data warehouse architecture; combining to result in numerous issues for business intelligence and analytics solutions. Introduction A severe disease has spread to epidemic proportions throughout our society.  This disease is particularly dangerous as

Read More

Data Mining

Data mining is a powerful analytical activity that can be used with data warehouses and with operational systems, yielding valuable insights. Introduction Data mining is often confused with “writing lots of reports and queries,” when in fact data mining activities

Read More

The Evolution of the Corporate Information Factory

Introduction In the beginning were applications.  And applications served the corporation well until there was a desire for integration of historical information. However, applications supported neither integration nor historical data.  When it was noticed that applications – once built and

Read More

Building a Data Warehouse in Iterations

Effective data warehouse development requires an iterative approach that results in a robust, well-defined and usable system for analytics. This article is excerpted from Data Warehouse Project Management (Addison-Wesley, Adelman and Moss, © September 2000). Data Warehouse Iterations Introduction A

Read More