• Sponsored Content

  • 
    

• Marketplace

  • Find DW Basics products & services on
    DM Review Marketplace

• Channel Resources

  Articles from this Site

  • Navy Exchange Service Command Selects Netezza

  • Netezza Enters Location Intelligence Market

  • St.George Bank Upgrades Enterprise Data Warehousing with Teradata

  • Kalido Strengthens New Ministry Information Library

  • Getting Started on Your Enterprise Business Intelligence and Data Warehousing Journey

  • More Articles from this Site

  White Papers

  • Spend Data Warehouse on Steroids

  • An Architected Approach to Integrated Information

  • KALIDO Business Modeling

  • Data Warehouse Lifecycle Management

  • Data Warehousing Ensuring Data Integrity

  • More White Papers

  Books

  • The Enterprise Data Warehouse: Planning, Building, and Implementation

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

  • Data Warehousing Advice for Managers

  • The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing, and Deploying Data Warehouses

  • 90 Days to the Data Mart

  • More Books

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

Channel Sponsored by

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

Data Warehousing and Business Intelligence Strategies for Small and Medium Businesses

This article discusses some key strategies that SMBs could take advantage of to institute a simple business intelligence and data warehousing program

A Generalized Approach to the Creation of Bridge Records

Applied to data warehousing, a bridge table relates a fact record to one or more dimension records. Where a fact has a one-to-many relationship with a dimension, or many-to-many, you may choose to handle that with a bridge table

Real Time Data Warehousing, Part 3

This third and final article of the series addresses the questions “What causes the biggest headaches?” and “What can do you do about it?”

10 Mistakes to Avoid in a Business Intelligence Delivery

Every data warehousing and business intelligence project teaches us something. It is generally on failures, however, that we base our new success. You can learn from other’s failures, 10 of which are discussed in this article.

Real-Time Data Warehousing, Part 2

This article addresses the question “How is real time achieved?”

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.

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?

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

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