CHAPTER 4

image

Designing a Data Warehouse

Organizing is what you do before you do something, so that when you do it, it is not all mixed up.

—A. A. Milne

Designing a data warehouse is one of the most important aspects of a business intelligence solution. If the data warehouse is designed correctly, all other aspects of the solution will benefit. Conversely, if it is created incorrectly, it will cause no end of problems.

In this chapter, we show techniques for designing a data warehouse, including different designs and terms used in the creation process and their proper use. Our focus is on simple practical designs that will get you building your first ...

Get Pro SQL Server 2012 BI Solutions now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.