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.

Business Intelligence Basics.- Visio Services.- Reporting Services.- Business Connectivity Services.- Excel Services.- PerformancePoint Services.

In this chapter we have looked at the following (see Figure 2–83): • Why we should use Visio and what the new Visio Services in SharePoint Server 2010 are. • The Visio client and its new features. • Integrating Visio with SharePoint using a Visio Web Access (VWA) web part and the JavaScript Mashup API. • Implementing Secure Store Services and using it in conjunction with Visio, SQL server, and SharePoint. • Designing custom data providers with Visio Services. • Administering Visio Services. Figure 2–83. Visio Services in SharePoint 2010 What’s Next? In the next chapter, you will learn about Reporting Services in SQL Server 2008 R2, architecture and installation, Reporting Services Add-in, data source management, Report authoring tools, and integration of Reporting Services with SharePoint. You will also learn about publishing reports in native and SharePoint mode, Access Services, and managing Reporting Services. 138 C H A P T E R 3 ? ? ? Reporting Services One of the most vital aspects of Business Intelligence is reporting. Organizations rely on reporting engines to deliver key information in a timely fashion. These engines need to allow users to create and deliver a variety of reports based on customer requirements. SQL Server 2008 R2 Reporting Services (SSRS) provides a complete range of tools and services to meet those customer requirements.