Pub. Date:
McGraw-Hill Professional Publishing
Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 / Edition 1

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

by Stacia Misner, Philo Janus
Current price is , Original price is $50.0. You

Temporarily Out of Stock Online

Please check back later for updated availability.

14 New & Used Starting at $1.99


Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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

Product Details

ISBN-13: 9780071716734
Publisher: McGraw-Hill Professional Publishing
Publication date: 02/03/2011
Pages: 496
Product dimensions: 7.30(w) x 9.10(h) x 1.10(d)

About the Author

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 technologies. She has written several books and articles on SQL Server and is a frequent speaker at SQL Server conferences.

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


Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews