Subscribe to DMU

Search DMU Library

Categories

Best Practices

Value of a Data Warehouse Strategy and Methodology

All successful business intelligence / analytics endeavors are based on a formal strategy and use a best-practices based methodology, even in agile environments. Many companies do not have a data strategy, which is a basic component for successful management of

Read More

Effective Data Warehouse Testing Strategy

Preparing a data warehouse testing strategy can ensure the successful development and completion of end-to-end testing of any data warehouse, data mart, or analytical environment. Introduction Organizations need to learn how to build an end-to-end data warehouse testing strategy. This

Read More

Challenges of Data Warehouse Re-Architecture

Data warehouse / business intelligence / analytics environments require business and IT cooperation for successful architecture and design Introduction In working with many large corporations across a variety of industries, it is clear that we all face the reality of

Read More

Data Warehouse Standards

Standards are different from guidelines.  Standards are firm and must be followed.  Successful data warehouses use standards Introduction Many dog owners give their dogs what they consider to be commands.  They are really more like guidelines. (“Boscoe come!… pause, pause,

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

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

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

Data Warehouse Costs

Developing a process for cost justifying a data warehouse and metrics for measuring various costs associated with a data warehouse project are essential for success This article is excerpted from a book titled Data Warehouse Project Management (published by Addison

Read More