Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

Managing SharePoint Business

Intelligence

In the previous lessons of this section of the book, you learned how each Business Intelligence

tool built into SharePoint is configured and then used to provide solutions to your end users.

In this lesson, you will walk through some of the management tools available to monitor your

Business Intelligence solutions.

The SharePoint 2010 Central Administration site is where these management tools are avail-

able. If you go to the Central Administration site and select General Application Settings,

you will find two sections for managing Business Intelligence, shown in Figure 40-1. Notice

that although there is a Reporting Services section here it does not help with managing day-

to-day usage. The purpose of this section, which was discussed in Lesson 36, is to configure

Reporting Services integration with SharePoint. The section that you should focus on from a

management perspective is the PowerPivot section.

Figure 40-1

40

889633c40.indd 371 8/16/10 9:11:26 PM

372



LeSSON 40 Managing SharePoint BuSineSS intelligence

The PowerPivot Management Dashboard enables you to monitor PowerPivot usage, failures, and

general server health. The first graph on the top of the page, Infrastructure — Server Health, initially

shows the query response time by day fo ...