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

Have a Promotion Code?

Please enter it here:

Great deals and more!

Sign up for special offers, exclusive discounts, and new product announcements from McGraw-Hill Professional.



February 22, 2011


Electronic book text, 512 pages

Other Formats


0071716742 / 9780071716741

Adobe Digital Editions® is required to view your downloaded eBooks.
Click here to get Adobe Digital Editions
To learn more about eBooks please see our eBook FAQ.

If you're having problems installing due to firewall issues please go here:


Your Price



Main description

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

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 Introducing PowerPivot
Chapter 6 Getting Data In
Chapter 7 SQL Server Reporting Services
Chapter 8 SharePoint Server 2010
Chapter 9 Scorecards & Dashboards
Chapter 10 Data Visualization
Chapter 11 Mapping
Chapter 12 Data Mining
Chapter 13 Master Data Services
Chapter 14 Publishing and Administration

Author comments

Philo Janus, BSEE, JD, is a senior technology specialist with Microsoft. He has presented before thousands of users and developers on various topics from InfoPath to SQL Server and business intelligence. Janus has also worked with large organizations on BI implementations. He was previously in the U.S. Navy.

Copyright 2014 McGraw-Hill Global Education Holdings, LLC


Before you can enjoy free downloads from McGraw-Hill Professional, we ask that you please provide your email address and country.

Yes, I want to receive other special offer.