Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010

by Philo Janus, Stacia Misner

Master Microsoft's Business Intelligence Tools Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 explains how to take full advantage of Microsoft's collaborative business intelligence (BI) tools. A variety of powerful, flexible technologies are covered, including SQL Server Analysis Services (SSAS), Excel, Excel Services, PowerPivot, SQL Server Integration Services (SSIS), Server Reporting Services (SSRS), SharePoint Server 2010, PerformancePoint Services, and Master Data Services. This practical guide focuses on deveoloping end-to-end BI solutions that foster informed decision making. Authoritative content written by a senior technology specialist at Microsoft who has presented to thousands of users and developers on Microsoft's BI technologies A foreword by Thierry D'Hers, Business Intelligence Group Program Manager at Microsoft Real-world exercises that enable you to build practical solutions for your own business problems Detailed illustrations depicting sophisticated reporting results Tips on visually representing data, creating KPI's, and business metrics About the AuthorPhil Janus is a senior technology specialist with Microsoft. Stacia Misner, MCITP, MCTS, is a consultant, trainer, and author specializing in Microsoft BI technologies.Table of ContentsChapter 1 What Is Business Intelligence? Chapter 2 Collaboration Meets Business Intelligence Chapter 3 SQL Server Analysis Services Chapter 4 Excel & Excel Services Chapter 5 PowerPivot Chapter 6 Getting Data In Chapter 7 SQL Server Reporting Services Chapter 8 SharePoint Chapter 9 Scorecards & Dashboards Chapter 10 Charts and Graphs Chapter 11 Maps Chapter 12 Data Mining Chapter 13 Master Data Services Chapter 14 Publishing and Administration Appendix: Chart Types Index

496 pages, Paperback

First published December 22, 2010