Microsoft® SharePoint® Server 2007 Bible

Creating Dashboards

Dashboards are an integral part of the Report Center functionality as they allow you to tie the components of your Report Center together in a meaningful format for your users. You can embed KPIs, Excel spreadsheets, and reporting services reports on a dashboard page so that the information is provided in context. You can also insert filters that can be used by multiple components on page and configure Excel web services filters to allow users to drill to the information that they need to see.

The dashboard page helps you to create this functionality by suggesting web parts, KPI creation, and layout but these web parts can also be used on other Web Part pages as well.

Creating your dashboard page

To create your dashboard page, follow these steps:

1.	Browse to your Report Center site.
2.	From the Site Actions menu in the top-right corner, select Create Dashboard.
3.	Type the filename and title of your dashboard page in the File Name: and Page Title fields. Type a description of your dashboard page if you want to display descriptive information at the top of your dashboard page.
4.	Select the document library and folder for your dashboard.
5.	In the Create Link in Current Navigation Bar, select whether or not you want a link inserted into the Quick Launch navigation and select the section it will be in from the pull-down menu.
6.	Select your page layout in the Dashboard layout section.
7.	In the Key Performance Indicators section, select whether you want to create ...