The Microsoft Data Warehouse Toolkit

Best practices and invaluable advice from world-renowned datawarehouse experts In 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 R2,as 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 release,as 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 studies The 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.