Create integrated business intelligence solutions using the newest releases of the Microsoft BI stack Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 explains how to use the entire Microsoft BI stack--SQL Server 2008 R2, SharePoint 2010, and Office 2010 components, including Excel/Gemini--to create integrated, practical, business intelligence solutions. An overview of SQL Server Analysis Services sets the stage for broad coverage of Excel as a front end for "self-service analysis," using SharePoint features for collaboration and workgroup BI, and leveraging Reporting Services for enterprise dashboards and reports. This practical guide focuses on building end-to-end BI solutions that solve real business data dilemmas. Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 features: * 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 Complete coverage of Microsoft business intelligence solutions: What Is Business Intelligence?; Collaboration Meets Business Intelligence; Excel & Excel Services; Analysis Services & Cubes; Introducing PowerPivot; Getting Data In; Reporting Services; SharePoint; Charts & Graphs; Mapping; Data Mining; Scorecards & Dashboards; Master Data Services; Publishing and Administration