Essential Steps for the Integrated Enterprise Data Warehouse, Part 1

This article provides guidance to what an integrated EDW is and what design elements are needed to achieve integration.

Date Dimension

Here is a simple script that I use to create a Date Dimension table.

Interview with Chuck Kelley - Part II

Part two of the interview looks at some design decisions in building a warehouse as well as some of the tools available.

Interview with Chuck Kelley - Part I

An interview with a data warehousing expert Chuck Kelley with some views about the careers in data warehousing.

Column-Store Databases and DW Appliances

With data volumes exploding, conventional enterprise data warehouses are fast running out of headroom. Data warehouse appliances are starting to fill the gap, but the emerging category of column-oriented databases may offer a better option. The key to success is matching your application to the right product.

Hubs, Spokes and Buses: How to Get to a Better Data Warehouse

Are you frustrated by the inefficiency, rigidity and latency of a first-generation, hub-and-spoke-architecture data warehouse? Here's a six-step guide to evolving to a streamlined, robust Kimball Dimensional Bus Architecture that will reduce time to reporting, lower data latency, and deliver more detailed, analytically useful information.

Master Data

Data Stores

Kimball University: Handling Arbitrary Restatements of History

How do you cope with an executive's request to "bring back a time series of activity for all subscribers who were in platinum status as of X date," or "show me a time series of orders by sales region according to the sales organization as of Y"? Here's how data warehouse pros can cope with the common requirement to look back in time.

Implementing Common Reference Data in a Data Warehouse

This article provides an architecture and process framework for implementing common reference data in a data-warehousing environment.