The Microsoft Data Warehouse Toolkit (eBook)

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.