Pro SharePoint 2010 Business Intelligence Solutions

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 Microsofts business intelligence products, and in this book we reveal how to get the most from developingbusiness intelligencesolutions on SharePoint 2010.

To understand the variousbusiness intelligenceofferings in SharePoint 2010, you need to understand the core SQL Serverbusiness intelligenceconcepts, andthe first part of the book presentsa comprehensive tutorial on those fundamentals. Pro SharePoint 2010 Business Intelligence Solutions then focuseson 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 Serverbusiness intelligenceare together, the challenge always has been finding people who understand both SharePoint and SQL Server well enough to deliver suchbusiness intelligencesolutions. With this book in hand, you become part of that select group.

What youll learn

• Understand the fundamentals and framework of business intelligence.
• Learn how tointegrateVisio Services, and discoverthe 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 practicaladvice about deploying and developing forPerformancePoint Services in SharePoint 2010.
• Learn about the advances in Excel Services and PowerPivot, and their application within SharePoint to practical situations.
• Gaina deep understandingof the Business Data Services featureset in SharePoint 2010.

Who this book is for

This book offersSharePoint developersanessential BI foundation experience andan introduction toSQL Server 2008 tools for business intelligence. This book will also benefit SQL Server developersand administrators who require knowledge of setting up the basic infrastructure on the SharePoint platform for business intelligence.

Table of Contents

Business Intelligence Basics

Visio Services

Reporting Services

Business Connectivity Services

Excel Services

PerformancePoint Services