Using PowerPivot for SharePoint 2013 - Business Intelligence in Microsoft SharePoint 2013 - page 203

In the Log On Credentials section, choose the authentication method (in the example, we use
Windows Authentication) and then click Next. On the Select Database And Table page of the wizard,
the workbook is shown as a Model of type Cube, as illustrated in Figure 7-20.
FIGURE 7-20 Selecting the data model from the workbook.
The actions to complete creating a connection to a data source are no different from the actions
described in Chapter 4, in the section “Creating the Data Model” (see also Figure 4-5).
Monitoring with PowerPivot for SharePoint
The PowerPivot Management Dashboard provides administrators who are responsible for the server
side of PowerPivot with the capabilities they need to understand usage patterns of the PowerPivot
workbooks in SharePoint and to take appropriate actions. For example, the growing size of a par-
ticular workbook might indicate the need to acquire more memory. You can access the PowerPivot
Management Dashboard by going to the SharePoint Central Administration page and then clicking
General Application Settings, as depicted in the Figure 7-21.
Note To view some of the Dashboard controls, you need Silverlight installed on the com-
puter on which you are browsing. If you do not have it installed, your browser should
prompt you to install it from the web.