Report Warns Of Data Warehouse 'Bottleneck' In Real-Time Analytics

In a report entitled "Really Urgent Analytics: The Sweet Spot for Real-Time Data Warehousing," Forrester advises intelligence and knowledge management professionals to familiarize themselves with the various approaches for adapting a data warehouse to meet real-time requirements, and, if necessary, consider bypassing the data warehouse altogether.

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.

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