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

Book Description

Master 's Business Intelligence Tools

Building Integrated Business Intelligence Solutions with SQL 2008 R2 & 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), , Services, PowerPivot, SQL Server 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 SSAS
  • Maximize the analysis capabilities of Excel and Excel Services
  • Combine data from different sources and connect data for analysis with PowerPivot
  • Move data into the system using SSIS, , Streamsight, and SharePoint 2010 External Lists
  • Build and publish reports with SSRS
  • Integrate data from disparate applications, using SharePoint 2010 BI features
  • Create scorecards and dashboards with PerformancePoint 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

Book Details

  • Title: Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010
  • Author: ,
  • Length: 496 pages
  • Edition: 1
  • Language: English
  • Publisher:
  • Publication Date: 2011-02-03
  • ISBN-10: 0071716734
  • ISBN-13: 9780071716734