Create PerformancePoint scorecards by using a wizard

We are in the process of combining the SharePoint Server 2013 and SharePoint Server 2016 content into a single content set. We appreciate your patience while we reorganize things. See the Applies To tag at the top of each article to find out which version of SharePoint an article applies to.


Applies to: SharePoint

Topic Last Modified: 2015-03-09

Summary: Learn how to create a PerformancePoint Services scorecard for your dashboard by using a wizard.

You can create scorecards for your dashboards by using Dashboard Designer. A scorecard is a report type that shows organizational performance by displaying a collection of key performance indicators (KPIs) together with performance targets for those KPIs.

When you create a PerformancePoint scorecard, you can use a wizard to guide you through the process. When you use a wizard, you begin by selecting a template. The template that you select corresponds to the kind of data source that you plan to use for your scorecard.

Make sure that Dashboard Designer is configured to use a scorecard wizard. For more information, see Turn on or off the scorecard wizard in Dashboard Designer.
To select a scorecard template
  1. Identify the kind of data source that you want to use for your scorecard. The data source that you want to use will help you determine which scorecard template to select, as described in the following table.


    Data source Scorecard template

    SQL Server Analysis Services

    Analysis Services

    Tabular data source, such as one of the following:

    • An Excel Services file

    • An Excel workbook

    • A SharePoint list

    • A table that is stored in a SQL Server database

    Excel Services, Excel Workbook, SharePoint List, or SQL Server Table

    No particular data source

    Blank Scorecard or Fixed Values Scorecard

  2. Make sure that the data source that you want to use is available. Do this by using the following procedure:

    1. In Dashboard Designer, click the Home tab, and then click Refresh.

    2. In the Workspace Browser, click Data Connections.

    3. In the center pane of the workspace, review the list of data sources on the Server and Workspace tabs.

    4. Confirm that the data source that you want to use is available. If it is not listed, then you might have to create a data connection. For information about how to create a data source, see Create data connections by using PerformancePoint Services.

  3. Select the template that corresponds to your data source and follow the wizard.