Various powerful, flexible technology is covered, including SQL Server Analysis Services (SSAS), Excel, Excel Services, PowerPivot, SQL Server Integration Services (SSIS), Reporting Services Server (SSR), SharePoint Server 2010, PerformancePoint Services, and Master Data Services . Create a multidimensional store to combine business data with analytical skills SSAS Maximize Excel and Excel Services Combining data from different sources and data to connect to analysis with PowerPivot Move data into the system using SSIS, InfoPath, Streamsight, and SharePoint 2010 External List Build and publish a report Integrating with SSR data from different applications, using SharePoint 2010 BI features Create scorecards and dashboards with PerformancePoint Summarize large volumes of data services in charts and graphs Use the SSR features a map for the visualization of complex spatial data reveal patterns and relationships in data using SSAS data mining engine handle master data management with Master Data Services Publish your BI solution components and perform administrative tasks