Building a Data Warehouse, 1st ed.
With Examples in SQL Server

Here is the ideal field guide for data warehousing implementation. This book first teaches you how to build a data warehouse, including defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Coverage then explains how to populate the data warehouse and explores how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. It also details testing and how to administer data warehouse operation.

The only book that shows how to implement a data warehouse using SQL Server

Interest in this topic for SQL Server is high and poorly understood

The code in the book will save companies hundreds of hours of development time and many wrong turns

Despite the intensity of the code, managers to programmers will find the book extremely useful

This book will be good for SQL Server 2005 and SQL Server 2008