Subscribe to DMU

Search DMU Library

Categories

Data Warehousing

Avoiding Data Mess with Effective Data Architecture

Rather than apply new words or phrases to poor data architecture concepts, learn how a data strategy should influence effective data architecture, especially for analytics and business intelligence People love buzzwords. Sometimes people think the quality of a solution improves

Read More

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

ETL Test Automation Planning for DW

Applying DevOps-style test automation to projects can guarantee a high level of data quality in any business intelligence / analytics initiative. Introduction According to a CIO.com article, Gartner Group recently stated that between 70 and 80 percent of business intelligence initiatives

Read More

Foundations of Data Extraction Transform Load (ETL)

Data extraction, transformation, and loading processes enable many activities in information technology projects. Understanding the concepts and practices of ETL is essential for all data and technology professionals IntroductionData extract, transform, load (ETL) is a process of copying data from

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

Introduction to Data Warehouse Testing

An Overview of Data Warehouse Testing Data warehouse and data integration testing should focus on ETL processes, BI engines, and applications that rely on data from the data warehouse and data marts. Introduction There is little that casts doubt on a data warehouse and BI project more quickly than incorrectly

Read More

Building a Rock Solid Data and Analytics Strategy

Every organization’s analytics strategy should be connected to its data strategy; and every organization should have a data strategy that supports its business strategy Introduction Like the lyrics in the children’s song Dem Bones, “the hip bone’s connected to the

Read More