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

Joy Mundy, Warren Thornthwaite

  • 出版商: Wiley
  • 出版日期: 2006-02-13
  • 定價: $1,650
  • 售價: 2.4$399
  • 語言: 英文
  • 頁數: 792
  • 裝訂: Paperback
  • ISBN: 0471267155
  • ISBN-13: 9780471267157
  • 相關分類: MSSQLSQL
  • 立即出貨(限量)




This groundbreaking book is the first in the Kimball Toolkit series to be product-specific. Microsoft’s BI toolset has undergone significant changes in the SQL Server 2005 development cycle. SQL Server 2005 is the first viable, full-functioned data warehouse and business intelligence platform to be offered at a price that will make data warehousing and business intelligence available to a broad set of organizations. This book is meant to offer practical techniques to guide those organizations through the myriad of challenges to true success as measured by contribution to business value.

Building a data warehousing and business intelligence system is a complex business and engineering effort. While there are significant technical challenges to overcome in successfully deploying a data warehouse, the authors find that the most common reason for data warehouse project failure is insufficient focus on the business users and business problems. In an effort to help people gain success, this book takes the proven Business Dimensional Lifecycle approach first described in best selling The Data Warehouse Lifecycle Toolkit and applies it to the Microsoft SQL Server 2005 tool set.

Beginning with a thorough description of how to gather business requirements, the book then works through the details of creating the target dimensional model, setting up the data warehouse infrastructure, creating the relational atomic database, creating the analysis services databases, designing and building the standard report set, implementing security, dealing with metadata, managing ongoing maintenance and growing the DW/BI system. All of these steps tie back to the business requirements. Each chapter describes the practical steps in the context of the SQL Server 2005 platform.

Intended Audience

The target audience for this book is the IT department or service provider (consultant) who is:

  • Planning a small to mid-range data warehouse project;
  • Evaluating or planning to use Microsoft technologies as the primary or exclusive data warehouse server technology;
  • Familiar with the general concepts of data warehousing and business intelligence.

The book will be directed primarily at the project leader and the warehouse developers, although everyone involved with a data warehouse project will find the book useful. Some of the book’s content will be more technical than the typical project leader will need; other chapters and sections will focus on business issues that are interesting to a database administrator or programmer as guiding information.

The book is focused on the mass market, where the volume of data in a single application or data mart is less than 500 GB of raw data. While the book does discuss issues around handling larger warehouses in the Microsoft environment, it is not exclusively, or even primarily, concerned with the unusual challenges of extremely large datasets.

About the Authors

JOY MUNDY has focused on data warehousing and business intelligence since the early 1990s, specializing in business requirements analysis, dimensional modeling, and business intelligence systems architecture. Joy co-founded InfoDynamics LLC, a data warehouse consulting firm, then joined Microsoft WebTV to develop closed-loop analytic applications and a packaged data warehouse.

Before returning to consulting with the Kimball Group in 2004, Joy worked in Microsoft SQL Server product development, managing a team that developed the best practices for building business intelligence systems on the Microsoft platform. Joy began her career as a business analyst in banking and finance. She graduated from Tufts University with a BA in Economics, and from Stanford with an MS in Engineering Economic Systems.

WARREN THORNTHWAITE has been building data warehousing and business intelligence systems since 1980. Warren worked at Metaphor for eight years, where he managed the consulting organization and implemented many major data warehouse systems. After Metaphor, Warren managed the enterprise-wide data warehouse development at Stanford University. He then co-founded InfoDynamics LLC, a data warehouse consulting firm, with his co-author, Joy Mundy. Warren joined up with WebTV to help build a world class, multi-terabyte customer focused data warehouse before returning to consulting with the Kimball Group. In addition to designing data warehouses for a range of industries, Warren speaks at major industry conferences and for leading vendors, and is a long-time instructor for Kimball University. Warren holds an MBA in Decision Sciences from the University of Pennsylvania's Wharton School, and a BA in Communications Studies from the University of Michigan.

RALPH KIMBALL, PH.D., has been a leading visionary in the data warehouse industry since 1982 and is one of today's most internationally well-known authors, speakers, consultants, and teachers on data warehousing. He writes the "Data Warehouse Architect" column for Intelligent Enterprise (formerly DBMS) magazine.


Table of Contents


1. Defining Business Requirements.

2. Designing the Business Process Dimensional Model.

3. The Toolset.


4. Setup and Physical Design.

5. Designing the ETL System.

6. Developing the ETL System.

7. Designing the Aanalysis Services OLAP Database.


8. Business Intelligence Applications.

9. Building the BI Application in Reporting Services.

10. Incorporating Data Mining.


11. Working with an Existing Data Warehouse.

12. Security.

13. Metadata.

14. Deploying the BI System.

15. Operations and Maintenance.


16. Managing Growth.

17. Real-Time Business Intelligence.

18. Present Imperatives and Future Outlook.






這本開創性的書籍是Kimball Toolkit系列中第一本針對特定產品的書籍。在SQL Server 2005的開發週期中,Microsoft的商業智能工具組經歷了重大變革。SQL Server 2005是第一個具有完整功能的數據倉庫和商業智能平台,其價格使得數據倉庫和商業智能對廣泛的組織可行。本書旨在提供實用技巧,引導這些組織克服眾多挑戰,實現真正的成功,以貢獻於商業價值。

構建數據倉庫和商業智能系統是一項複雜的業務和工程工作。儘管在成功部署數據倉庫時需要克服重大技術挑戰,但作者發現數據倉庫項目失敗最常見的原因是對商業用戶和商業問題的關注不足。為了幫助人們取得成功,本書將在Microsoft SQL Server 2005工具組中應用已證實的商業維度生命周期方法,該方法首次在暢銷書《數據倉庫生命周期工具包》中描述。

本書首先詳細描述了如何收集業務需求,然後逐步介紹了創建目標維度模型、設置數據倉庫基礎設施、創建關聯原子數據庫、創建分析服務數據庫、設計和構建標準報表集、實施安全性、處理元數據、管理持續維護和發展DW/BI系統的細節。所有這些步驟都與業務需求相關聯。每一章都描述了在SQL Server 2005平台上的實際步驟。




本書專注於大眾市場,其中單個應用程序或數據集的數據量少於500 GB原始數據。雖然本書討論了在Microsoft環境中處理更大的倉庫的問題,但它並不專門或主要關注極大數據集的不尋常挑戰。


JOY MUNDY自20世紀90年代初以來一直專注於數據倉庫和商業智能,專注於業務需求分析、維度建模和商業智能系統架構。Joy共同創辦了InfoDynamics LLC,一家數據倉庫咨詢公司,然後加入Microsoft WebTV開發封閉循環```