Pro SharePoint 2010 Business Intelligence Solutions

By Sahil Malik , Srini Sistla , Steve Wright

Business intelligence (BI) software is everywhere. Our book provides the seminal reference for developers building business intelligence portals on top of the SharePoint 2010 platform.

Full Description

  • ISBN13: 978-1-4302-3285-8
  • 432 Pages
  • User Level: Intermediate to Advanced
  • Publication Date: December 13, 2010
  • Available eBook Formats: EPUB, MOBI, PDF
  • Print Book Price: $64.99
  • eBook Price: $45.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

What differentiates good organizations from bad? The good ones are those that take advantage of the data they already have and use the feedback that business intelligence gives them to improve their processes. SharePoint is now the delivery platform of choice for Microsoft’s business intelligence products, and in this book we reveal how to get the most from developing business intelligence solutions on SharePoint 2010.

To understand the various business intelligence offerings in SharePoint 2010, you need to understand the core SQL Server business intelligence concepts, and the first part of the book presents a comprehensive tutorial on those fundamentals. Pro SharePoint 2010 Business Intelligence Solutions then focuses on specific SharePoint business intelligence investments including:

  • Visio Services
  • Excel Services
  • SQL Server Reporting Services
  • Business Connectivity Services
  • PerformancePoint Services
All of this is done using a practical, hands-on format, with enough examples to empower you to use these products in your real-life projects. As compelling as SharePoint and SQL Server business intelligence are together, the challenge always has been finding people who understand both SharePoint and SQL Server well enough to deliver such business intelligence solutions. With this book in hand, you become part of that select group.

What you’ll learn

  • Understand the fundamentals and framework of business intelligence.
  • Learn how to integrate Visio Services, and discover the developer story.
  • Practice working with the Secure Store Service.
  • Experience authoring and publishing reports using Report Builder and how to re-purpose published reports in Reporting Services.
  • Glean practical advice about deploying and developing for PerformancePoint Services in SharePoint 2010.
  • Learn about the advances in Excel Services and PowerPivot, and their application within SharePoint to practical situations.
  • Gain a deep understanding of the Business Data Services featureset in SharePoint 2010.

Who this book is for

This book offers SharePoint developers an essential BI foundation experience and an introduction to SQL Server 2008 tools for business intelligence. This book will also benefit SQL Server developers and administrators who require knowledge of setting up the basic infrastructure on the SharePoint platform for business intelligence.

Table of Contents

Table of Contents

  1. Business Intelligence Basics
  2. Visio Services
  3. Reporting Services
  4. Business Connectivity Services
  5. Excel Services
  6. PerformancePoint Services
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

Please Login to submit errata.

On page 371:

The filters are not set after step 15. The Screen shot does not match the results at this point.

Solution: Add the filter edits to match the screen shot or change the screen shot to match the results of step 15.