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.