Business Intelligence (BI) software is everywhere. It is the code and tools that allow you to view different components of a business using a single visual platform, making comprehending mountains of data easier. With SharePoint 2010, Microsoft has married one of the most-used team collaboration tools with its business intelligence products, including PerformancePoint Services and Excel Services. Now, users of SharePoint can have a single place to get a view of their business, its organization and processes, and its financial performance.

Constructing this type of portal is a process unique to each business. With Pro SharePoint 2010 Business Intelligence Solutions, authors Sahil Malik and Srini Sistla take you through the different tools, services, and frameworks available for building a BI portal atop SharePoint 2010. With comprehensive coverage of Visio Services, PerformancePoint, Excel Services, and a practical look at building scorecards, dashboards, and other reporting solutions, this book answers the fundamental questions about why and how BI can work for your business.

What you’ll learn

• Understand the fundamentals and framework of BI.
• 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 BI.

Table of Contents

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