Includes a complete suite of data warehousing and BI tools that are part of SQL Server 2008 R2, as well as Microsoft Office, the author guides you through the full project cycle, including design, deployment of development, and maintenance.Features more than 50 percent new and revised material includes features a rich new set of release of SQL Server 2008 R2, and Office 2010 content releaseIncludes new brand that focuses on PowerPivot for Excel and SharePoint, Master Data Services, and? discuss the updated capabilities of SQL Server Analysis, Integration, and Reporting ServicesShares detailed case examples that clearly illustrate how best to apply the techniques described above bookThe Web site contains all the code samples and sample database used throughout the case studies 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 achieve your most important data warehousing tasks.