The Microsoft data warehouse toolkit : with SQL Server 2005 and the Microsoft Business Intelligence toolset /

Saved in:
Bibliographic Details
Author / Creator:Mundy, Joy, 1961-
Imprint:Indianapolis, IN : Wiley Pub., ©2006.
Description:1 online resource (xliii, 746 pages) : illustrations
Language:English
Subject:
Format: E-Resource Book
URL for this record:http://pi.lib.uchicago.edu/1001/cat/bib/13592680
Hidden Bibliographic Details
Other authors / contributors:Thornthwaite, Warren, 1957-
Kimball, Ralph.
ISBN:9780470007365
0470007362
9780470342916
0470342919
0471267155
9780471267157
Digital file characteristics:text file
Notes:Print version record.
Summary:"As longtime data warehousing practitioners and former Microsoft insiders, authors Joy Mundy and Warren Thornthwaite have extensive experience in building and managing data warehouse (DW) and business intelligence (BI) systems. With this book, they share best practices for using SQL Server 2005 to build a successful DW/BI system. Covering the complete suite of data warehousing tools that accompanies SQL Server 2005, they focus on full project lifecycle, including design, development, deployment, and maintenance."--Jacket
Other form:Print version: Mundy, Joy, 1961- Microsoft data warehouse toolkit. Indianapolis, IN : Wiley Pub., ©2006 9780471267157
Standard no.:9780471267157
Table of Contents:
  • Contents
  • Foreword
  • Preface
  • Acknowledgments
  • Introduction
  • 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