Offering practical examples implemented in Microsoft's Business Intelligence toolset, this book is structured around the major phases of a data warehouse project plan: design, development, deployment, and maintainence

Includes many detailed examples of how to use BI tools, such as MDX, DTS, and the SQL Server database to accomplish various data warehousing tasks

A case study used throughout the book provides examples of the various techniques presented in the book

The companion Web site contains all code samples, the sample database used throughout the case study, and sample templates and other job aids



Contents

Introduction

I. Requirements, Realities, and Architecture

1. Defining Business Requirements

2. Designing the Business Process Dimensional Model

3. The Toolset



II. Developing and Populating the Databases

4. Setup and Physical Design

5. Designing the ETL System

6. Developing the ETL System

7. Designing the Analysis Services OLAP Database



III. Developing the BI Applications

8. Business Intelligence Applications

9. Building the BI Application in Reporting Services

10. Incorporating Data Mining



IV. Deploying and Managing the DW/BI System

11. Working with an Existing Data Warehouse

12. Security

13. Metadata

14. Deploying the BI System

15. Operations and Maintenance



V. Extending the DW/BI System

16. Managing Growth

17. Real-Time Business Intelligence

18. Present Imperatives and Future Outlook

Index