Hands On Lab: Building Your First Dashboard with SharePoint 2010 PerformancePoint Services Version: 1.0 Description This Hands On Lab shows how to build a complete solution with SharePoint 2010 PerformancePoint Services that includes KPI's, reports, scorecards and dashboards. Overview This lab will create a PerformancePoint Services dashboard based on the Analysis Services Reseller Sales cube. Objectives The objectives of this exercise are to: Create a PerformancePoint Data Source Import an Analysis Services KPI Create a PerformancePoint Scorecard, Report, Filter and Dashboard Deploy a PerformancePoint Dashboard Explore the PerformancePoint Dashboard System Requirements You must have installed the following items to complete this lab: Microsoft SQL Server 2008 R2: Database Engine Analysis Services SQL Server AdventureWorks2008 R2 sample databases AdventureWorksDW2008R2 Microsoft SharePoint 2010 (Enterprise Edition): PerformancePoint Services Setup All the requisites for this lab are verified using the Configuration Wizard. To make sure that everything is correctly configured, follow these steps. Note: To perform the setup steps you need to run the scripts in a command window with administrator privileges. Launch the Configuration Wizard for this lab by double-clicking the Dependencies.dep file located under the Source\Setup folder of this lab. Install any pre-requisites that are missing (rescanning if necessary) and complete the wizard. The PerformancePoint Services service application must have its Unattended Service Account configured, and the Analysis Services database created during setup must grant this account at least read access to the Reseller Sales cube. Cleanup There is no need to cleanup if you intend to continue the sequence of labs in this training kit. To restore the original state of the AdventureWorksDW2008R2 SQL Server database and delete the Sales Analysis Analysis Services database, execute the Cleanup.cmd script located under the Setup folder in the Source folder of this lab. Delete all PerformancePoint content saved in the SharePoint Data Connections library and PerformancePoint Content list. Delete the Reseller Sales Dashboard dashboard created in the SharePoint Dashboards library. Exercises This Hands-On Lab comprises the following exercise: Creating the Reseller Sales Dashboard Estimated time to complete this lab: 30 minutes. next >

Downloads Download The Offline Training Kit Download Hands-on Lab Document (DOCX) Download Hands-on Lab Source Files Contents Overview Exercise 1: Creating the Reseller Sales Dashboard Summary