Building a Data Warehouse: 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.

這是一本理想的資料倉儲實施指南。本書首先教導您如何建立資料倉儲，包括定義架構、了解方法論、收集需求、設計資料模型和建立資料庫。接著，本書解釋如何填充資料倉儲，並探討如何使用報表和多維數據庫向使用者呈現數據，以及如何將資料倉儲中的數據用於商業智能、客戶關係管理和其他用途。本書還詳細介紹了測試和如何管理資料倉儲操作。