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

Master Microsoft's Business Intelligence ToolsBuilding 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. Create a multidimensional store for aggregating business data with SSASMaximize the analysis capabilities of Excel and Excel ServicesCombine data from different sources and connect data for analysis with PowerPivotMove data into the system using SSIS, InfoPath, Streamsight, and SharePoint 2010 External ListsBuild and publish reports with SSRSIntegrate data from disparate applications, using SharePoint 2010 BI featuresCreate scorecards and dashboards with PerformancePoint ServicesSummarize large volumes of data in charts and graphsUse the SSRS map feature for complex visualizations of spatial dataUncover patterns and relationships in data using the SSAS data mining engineHandle master data management with Master Data ServicesPublish the components of your BI solution and perform administrative tasks