The Microsoft Data Warehouse Toolkit

Best practices and invaluable advice from world-renowned data warehouse experts In this book, leading data warehouse experts from the Kimball Group share best practices for using the upcoming Business Intelligence release of SQL Server, referred to as SQL Server 2008 R2. In this new edition, the authors explain how SQL Server 2008 R2 provides a collection of powerful new tools that extend the power of its BI toolset to Excel and SharePoint users and they show how to use SQL Server to build a successful data warehouse that supports the business intelligence requirements that are common to most organizations. Covering the complete suite of data warehousing and BI tools that are part of SQL Server 2008 R2, as well as Microsoft Office, the authors walk you through a full project lifecycle, including design, development, deployment and maintenance. Features more than 50 percent new and revised material that covers the rich new feature set of the SQL Server 2008 R2 release, as well as the Office 2010 release Includes brand new content that focuses on PowerPivot for Excel and SharePoint, Master Data Services, and discusses updated capabilities of SQL Server Analysis, Integration, and Reporting Services Shares detailed case examples that clearly illustrate how to best apply the techniques described in the book The accompanying Web site contains all code samples as well as the sample database used throughout the case studies The Microsoft Data Warehouse Toolkit, Second Edition provides you with the knowledge of how and when to use BI tools such as Analysis Services and Integration Services to accomplish your most essential data warehousing tasks.

Best practices and invaluable advice from world-renowned datawarehouse expertsIn this book, leading data warehouse experts from the KimballGroup share best practices for using the upcoming "BusinessIntelligence release" of SQL Server, referred to as SQLServer 2008 R2. In this new edition, the authors explain howSQL Server 2008 R2 provides a collection of powerful new tools thatextend the power of its BI toolset to Excel and SharePoint usersand they show how to use SQL Server to build a successful datawarehouse that supports the business intelligence requirements thatare common to most organizations. Covering the complete suite ofdata warehousing and BI tools that are part of SQL Server 2008 R2as well as Microsoft Office, the authors walk you through a fullproject lifecycle, including design, development, deployment andmaintenance.* Features more than 50 percent new and revised material thatcovers the rich new feature set of the SQL Server 2008 R2 releaseas well as the Office 2010 release* Includes brand new content that focuses on PowerPivot for Exceland SharePoint, Master Data Services, and discusses updatedcapabilities of SQL Server Analysis, Integration, and ReportingServices* Shares detailed case examples that clearly illustrate how tobest apply the techniques described in the book* The accompanying Web site contains all code samples as well asthe sample database used throughout the case studiesThe Microsoft Data Warehouse Toolkit, Second Editionprovides you with the knowledge of how and when to use BI toolssuch as Analysis Services and Integration Services to accomplishyour most essential data warehousing tasks.

Foreword xxviiIntroduction xxixPart 1 Requirements, Realities, and Architecture 1Chapter 1 Defining Business Requirements 3Chapter 2 Designing the Business Process Dimensional Model 29Chapter 3 The Toolset 79Chapter 4 System Setup 99Part 2 Building and Populating the Databases 133Chapter 5 Creating the Relational Data Warehouse 135Chapter 6 Master Data Management 165Chapter 7 Designing and Developing the ETL System 187Chapter 8 The Core Analysis Services OLAP Database 245Chapter 9 Design Requirements for Real-Time BI 305Part 3 Developing the BI Applications 321Chapter 10 Building BI Applications in Reporting Services 323Chapter 11 PowerPivot and Excel 375Chapter 12 The BI Portal and SharePoint 403Chapter 13 Incorporating Data Mining 429Part 4 Deploying and Managing the DW/BI System 491Chapter 14 Designing and Implementing Security 493Chapter 15 Metadata Plan 523Chapter 16 Deployment 545Chapter 17 Operations and Maintenance 583Chapter 18 Present Imperatives and Future Outlook 613Conclusion 623Index 625