Fables and Facts

Do you know the difference between dimensional modeling truth and fiction? According to Merriam-Webster, fables are fictitious statements. Unfortunately, fables about dimensional modeling circulate throughout our...

Differences of Opinion

The Kimball bus architecture and the Corporate Information Factory: What are the fundamental differences? Based on recent inquiries, many of you are in the midst...

Design Tip #51: Latest Thinking On Time Dimension Tables

Virtually every fact table has one or more time related dimension foreign keys. Measurements are defined at specific points of time and most measurements are...

Data Warehouse Dining Experience

I worked at a company called Metaphor back in the early 1980s. As part of a startup software company introducing then-cutting-edge concepts (such as folders,...

Fistful of Flaws

People often engage us to conduct dimensional model design reviews. In this column, I’ll provide a laundry list of common design flaws to scout...

Design Tip #46: Another Look At Degenerate Dimensions

We are often asked about degenerate dimensions in our modeling workshops. Degenerate dimensions cause confusion since they don’t look or feel like normal dimensions. It’s...

The Soul of the Data Warehouse, Part 2: Drilling Across

The three fundamental themes that make up the soul of every data warehouse are drilling down, drilling across, and handling time. In Part One...

The Soul of the Data Warehouse, Part 1: Drilling Down

Although data warehouses come in many shapes and sizes and deal with many different subject areas, every data warehouse must embody a few fundamental...

Design Tip #41: Drill Down into a More Detailed Bus Matrix

Many of you are already familiar with the data warehouse bus architecture and matrix given their central role in building architected data marts. The corresponding...

Two Powerful Ideas

There are two powerful ideas at the foundation of most successful data warehouses. First, separate your systems. Second, build stars and cubes. In my previous...