Share via

  • Article

Creating a PerformancePoint Services 2010 Dashboard Based on a SQL Server 2012 Tabular BI Semantic Model (RTM Update)

Version: 1.4

Description

In this Hands On Lab you will learn how to create a PerformancePoint Services dashboard based on the Sales Analysis Tabular BI Semantic Model deployed in a previous lab.

Overview

In this lab, you will create a PerformancePoint Services dashboard based on the Sales Analysis Tabular BI Semantic Model deployed in a previous lab.

Objectives

The objectives of this exercise are to:

  • Create a PerformancePoint Data Source based on a Tabular BI Semantic Model
  • Create KPI that binds to a KPI definition in the Tabular BI Semantic Model
  • 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 2012:
    • Database Engine
    • Analysis Services (Tabular mode)
  • Microsoft SharePoint 2010 Enterprise Edition:
    • PerformancePoint Services
  • Silverlight
  • Adventure Works for SQL Server 2012
    • AdventureWorksDW2012

Setup

The setup and configuration for this lab involves running a Setup script included with the training kit. To run all setup tasks for this lab:

Task 1 – Installing the AdventureWorksDW2012 Database

Note:
This process may require administrative privileges.
  1. Open a Windows Explorer window and browse to the lab’s Source folder.
  2. Double-click the Setup.cmd file in this folder to launch the setup script and run all setup tasks for this lab.
  3. If the User Account Control dialog is shown, confirm the action to proceed.
  4. If your instance of SQL Server is other than localhost you will need to modify the connection string in the create_SalesAnalysis.xmla file located under Source\Setup\scripts\Tasks\sql folder of this Lab (line 13529).

    XMLA

    </Annotations>
    <ConnectionString>Provider=SQLNCLI11;Data Source=localhost;Initial Catalog=AdventureWorksDW2012;Integrated Security=SSPI;Persist Security Info=false</ConnectionString>FakePre-e9759d70fcae492f8242807c5935882b-2dbdbb9aa0d04089934b3fa316797b7fFakePre-529b461444eb41c4b0cf2508a8d5756d-967d4ba9b3054fe8aa41925eec9464ec

Task 2 – Creating a Site Collection

  1. To open Central Administration, click the Start button, and then select All Programs | Microsoft SharePoint 2010 Products | SharePoint 2010 Central Administration.
  2. Login using Administrator credentials, if required.
  3. Click Application Management.
  4. Click Create Site Collections.

  5. Configure the new site collection based on the following table.

    Property

    Value

    Title

    AdventureWorksBI

    URL

    /sites/AdventureWorksBI

    Template

    Enterprise | Business Intelligence Center

    Primary Site Collection Administrator

    <Administrator username>

Task 3 – Creating the Sales Analysis Database

  1. Double-click create_SalesAnalysis.xmla file located under the Source\Setup\scripts\Tasks\sql folder of this Lab.
  2. When SQL Server Management Studio opens, in the Connect to Server dialog, select Analysis Services in the Server type combobox.
  3. In the server name, type your SQL Server instance name.
  4. Click Connect.
  5. Click the query window, then click the Query menu, and select Execute.

Cleanup

  1. There is no need to cleanup if you intend to continue the sequence of labs in this training kit.

Task 1 – Dropping the AdventureWorksDW2012 SQL Server Database.

  1. Execute the Cleanup.cmd script located under the Setup folder in the Source folder of this lab.

Task 2 – Deleting the AdventureWorksBI Site Collection

  1. To open Central Administration, click the Start button, and then select All Programs | Microsoft SharePoint 2010 Products | SharePoint 2010 Central Administration.
  2. Login using Administrator credentials, if required.
  3. Click Application Management.
  4. Click Delete a Site Collection.
  5. Click No Selection and select Change Site Collection.
  6. Click the AdventureWorksBI Site Collection, and click OK.
  7. Click Delete.
  8. Click OK to confirm the deletion of the Site Collection.

Task 3 – Dropping Sales Analysis Database

  1. Double-click drop_SalesAnalysis.xmla file located under the Source\Setup\scripts\Tasks\sql folder of this Lab.
  2. When SQL Server Management Studio opens connect to the SQL Server instance running in VERTIPAQ mode.
  3. Click the Query menu, and then Execute.

Feedback

Your feedback is welcome! Please, post it on our UserVoice forums.

Exercises

This Hands-On Lab comprises the following exercise:

  1. Creating the 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