The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business... at Dominant Systems Book Store

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.

Customer Reviews & Comments
I've enthusiastically referenced Kimball publications for business intelligence projects over the years; everything from how to manage history in slowly changing dimensions to fact-less fact tables to creating an initial data warehouse project plan, always with outstanding results. Mundy, Thornthwaite, and Kimball achieve two key milestones with The Microsoft Data Warehouse Toolkit. First, they successfully apply many years of data warehousing scholarship and expertise to a real-world platform. This is accomplished from a practical perspective with respect to MS SQL Server, as the authors are realistic of both the strengths and weaknesses of the platform and tailor their approach accordingly. Second, this publication recognizes modern incarnations of the MS SQL Server as a viable platform for data warehousing. Microsoft has addressed the stability issues associated with earlier releases of the SQL Server. If you're considering an MS SQL warehouse deployment, I would strongly encourage you and your staff to read this book.

Back To Top