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.

Table of Contents

CHAPTER 1 Introduction to Data Warehousing

CHAPTER 2 Data Warehouse Architecture

CHAPTER 3 Data Warehouse Development Methodology

CHAPTER 4 Functional and Nonfunctional Requirements

CHAPTER 5 Data Modeling

CHAPTER 6 Physical Database Design

CHAPTER 7 Data Extraction

CHAPTER 8 Populating the Data Warehouse

CHAPTER 9 Assuring Data Quality

CHAPTER 10 Metadata

CHAPTER 11 Building Reports

CHAPTER 12 Multidimensional Database

CHAPTER 13 Using Data Warehouse for Business Intelligence

CHAPTER 14 Using Data Warehouse for Customer Relationship Management

CHAPTER 15 Other Data Warehouse Usage

CHAPTER 16 Testing Your Data Warehouse

CHAPTER 17 Data Warehouse Administration

APPENDIX Normalization Rules