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, Power Pivot, SQL Server Integration Services (SSIS), Server Reporting Services (SSRS), Share Point Server 2010, Performance Point Services, and Master Data Services. This practical guide focuses on deveoloping end-to-end BI solutions that foster informed decision making. Create a multidimensional store for aggregating business data with SSASMaximize the analysis capabilities of Excel and Excel Services Combine data from different sources and connect data for analysis with Power Pivot Move data into the system using SSIS, Info Path, Streamsight, and Share Point 2010 External Lists Build and publish reports with SSRSIntegrate data from disparate applications, using Share Point 2010 BI features Create scorecards and dashboards with Performance Point Services Summarize large volumes of data in charts and graphs Use the SSRS map feature for complex visualizations of spatial data Uncover patterns and relationships in data using the SSAS data mining engine Handle master data management with Master Data Services Publish the components of your BI solution and perform administrative tasks