FREE DM Review Site Registration!
Sign-up today and access DM Review on the Web!

Your FREE registration entitles you to:
FREE email newsletters

FREE access to all DM Review content

FREE access to web seminars, resource portals, our white paper library and more!

   

DW Basics Channel

Data warehousing is a foundational practice that supports enterprise reporting, business intelligence and decision support. Data warehouses and data marts are created across levels of sophistication and different philosophical approaches, but typically involve extracting and transforming data from operational/transactional databases and loading it to a repository for shared use and analysis. The DW Basics channel has been created to capture and aggregate stories related to fundamental approaches and practices for creating, managing, utilizing and maintaining a data warehouse.

Articles

Real-Time Data Warehousing, Part 1

Decision-makers in an organization must answer four questions when considering real-time data warehousing

Data Warehouse Capacity Planning as Capacity Enforcement

Daily, millions of cars and trucks use a shared resource - the street. We can take some principles from street traffic and apply them to capacity planning in a data warehouse.

Murphy’s Laws of Data Warehousing: What Goes Bump in the Night?

Murphy’s Law tells us that whatever can go wrong will go wrong. This axiom applies to all aspects of life, including data warehousing.

Using Data Virtualization to Maximize Return on Data Warehousing Investments

Today’s enterprises rely on the information in their data warehouses more than ever.

Essential Steps for the Integrated Enterprise Data Warehouse, Part 2

This article describes what the dimension manager and fact provider do, and how to configure business intelligence tools to use the integrated EDW.

More Articles

Columns

Getting Started on Your Enterprise Business Intelligence and Data Warehousing Journey

Here are a few more things to consider before getting started or going too far down the path of developing an enterprise business intelligence and data warehouse capability.

Technologies to Take Your Enterprise-Wide BI and DW Program to the Next Level

This column addresses the role of technologies that can take enterprise BI/DW architecture to the next level.

The Song Remains the Same - Data Shadows Systems Continue to be Pervasive for Reporting and Analytics: BI and DW Trends, 8 for ’08

BI may not be pervasive, but spreadsheets are.

Data Warehousing Meets Data Archiving in Information Lifecycle Management

Data warehousing without archiving is like a garage that a family has used for several generations.

The Role of Packaged BI Applications in Delivering Enterprise-Wide BI and DW

This column explores addressing the role of packaged BI applications in an enterprise BI/DW architecture.

More Columns

Ask the Experts

Can anyone share some experience as to how to test a data warehouse?

When is it better to have normalized data to create data marts and when is it better to have dimensional data?

How do I convince my reluctant boss to begin work on a data warehouse?

Where is the best place for a BI application to reside?

How can I enhance the productivity of my fact table load?

More Ask the Experts

White Papers

Spend Data Warehouse on Steroids

By Zycus

An Architected Approach to Integrated Information

By David Waddington

KALIDO Business Modeling

By Bruce Ottmann

Data Warehouse Lifecycle Management

By Cliff Longman

Data Warehousing Ensuring Data Integrity

By Cindy Maurer

More White Papers

Books

The Enterprise Data Warehouse: Planning, Building, and Implementation

By Eric Sperley

Enterprise One to One: Tools for Competing in the Interactive Age

By Don Peppers, Martha Rogers

Data Warehousing Advice for Managers

By Patricia L. Ferdinandi
More Books



Industry Vendors