The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset

Customers who bought this, also bought: The Data Warehouse Toolkit : The Complete Guide to Dimensional Modeling 2nd edition The Data Warehouse ETL Toolkit : Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data Delivering Business Intelligence with Microsoft SQL Server 2005 Microsoft SQL Server 2005 Reporting Services 2005 Professional SQL Server 2005 Integration Services MCTS Self-Paced Training Kit (Exam 70-431): Microsoft® SQL Server 2005-Implementation and Maintenance MCITP Self-Paced Training Kit (Exams 70-431,70-443,70-444): Database Administrator Core Requirements !The Data Warehouse Lifecycle Toolkit, 1st Edition (This is an OLD EDITION. To order the new edition, please perform a new search using the following ISBN: 0470149779) MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase (2nd Edition) Microsoft SQL Server 2005 Analysis Services

by: Joy Mundy, Warren Thornthwaite

On-line Price: $53.95 (includes GST) Paperback package 792 17%Off Retail Price You save: $11.00 In Stock - Available for immediate delivery! _____________________ N.Sydney : In Stock	Retail Price: $64.95 Publisher: John Wiley & Sons,15.2.2006 Category: DATA WAREHOUSING Level: ISBN: 0471267155 ISBN13: 9780471267157
Add to Shopping Cart

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

Table of Contents

PART I: REQUIREMENTS, REALITIES, AND ARCHITECTURE.
1. Defining Business Requirements.

2. Designing the Business Process Dimensional Model.

3. The Toolset.

PART II: DEVELOPING AND POPULATING THE DATABASES.

4. Setup and Physical Design.

5. Designing the ETL System.

6. Developing the ETL System.

7. Designing the Aanalysis Services OLAP Database.

PART III: DEVELOPING THE BI APPLICATIONS.

8. Business Intelligence Applications.

9. Building the BI Application in Reporting Services.

10. Incorporating Data Mining.

PART 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.

PART V: EXTENDING THE DW/BI SYSTEM.

16. Managing Growth.

17. Real-Time Business Intelligence.

18. Present Imperatives and Future Outlook.

Index.