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

Paperback | February 24, 2011

byPhilo Janus, Stacia Misner

not yet rated|write a review

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, 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 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, InfoPath, 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

Pricing and Purchase Info

$39.01 online
$58.95 list price (save 33%)
In stock online
Ships free on orders over $25

From the Publisher

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...

Phil Janus is a senior technology specialist with Microsoft. He has presented before thousands of users and developers on various topics, including SQL Server and BI, and has worked with large organizations on BI implementations. Stacia Misner, MCITP, MCTS, is a consultant, trainer, and author specializing in Microsoft BI techno...

other books by Philo Janus

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

Kobo ebook|Sep 7 2011

$50.59 online$65.62list price(save 22%)
Pro Infopath 2007
Pro Infopath 2007

Paperback|Feb 25 2007

$35.42 online$58.50list price(save 39%)
Pro SQL Server 2008 Analysis Services
Pro SQL Server 2008 Analysis Services

Paperback|Jun 14 2010

$35.42 online$58.50list price(save 39%)
see all books by Philo Janus
Format:PaperbackDimensions:512 pages, 9.2 × 7.3 × 0.97 inPublished:February 24, 2011Publisher:McGraw-Hill EducationLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:0071716734

ISBN - 13:9780071716734

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

Reviews

Extra Content

Table of Contents

Chapter 1 What Is Business Intelligence?
Chapter 2 Collaboration Meets Business Intelligence
Chapter 3 SQL Server Analysis Services
Chapter 4 Excel & Excel Services
Chapter 5 PowerPivot
Chapter 6 Getting Data In
Chapter 7 SQL Server Reporting Services
Chapter 8 SharePoint
Chapter 9 Scorecards & Dashboards
Chapter 10 Charts and Graphs
Chapter 11 Maps
Chapter 12 Data Mining
Chapter 13 Master Data Services
Chapter 14 Publishing and Administration
Appendix: Chart Types
Index