Building a scorecard

Contents[Hide]

1. Overview

This walkthrough shows you how to use the Dundas BI Scorecard Designer to create a basic scorecard which shows columns of measures for each product. Each of the measures is displayed using a different type of data visualization control.

A scorecard in Dundas BI is another type of 'view' which is similar to a report. Both scorecards and reports are based on the idea of repeating sets of controls. However, the layout for a scorecard is simpler than that of a report because there are no page header or footer regions, for example.

Instead of viewing a scorecard by itself, you typically use a scorecard by adding it to an existing dashboard just like you would with any data visualization control.

An example scorecard showing measures for each product
An example scorecard showing measures for each product

Related video: Introduction to Scorecards

2. Scorecard layout

The following figure shows the logical design or layout for the example scorecard.

Logical design for the example scorecard
Logical design for the example scorecard

Elements within the Group Body region are repeated according to the Product hierarchy level which is added to the Grouping hierarchy region. (In other words, the Group Body repeats for every product value.)

3. Data preparation

For this walkthrough, create a data connector for a SQL Server Analysis Services (SSAS) database such as AdventureWorks.

Data connector for AdventureWorks OLAP cube
Data connector for AdventureWorks OLAP cube

4. Designing the scorecard

4.1. Create a new scorecard

Go to the main menu, click New, and then click Scorecard.

Create a new scorecard from main menu
Create a new scorecard from main menu

The Scorecard Designer canvas is displayed. By default, the scorecard is 1024 units wide which is too large for this example.

To change the width of the scorecard, click on the white canvas area outside of any scorecard regions, go to the Properties window, click the Layout tab, and then change the Width property to 700.

Change the scorecard width
Change the scorecard width

Tip
You can also use the resize icon at the bottom right corner to resize a scorecard.

Here's what the initial scorecard looks like in the Scorecard Designer:

Initial scorecard in the designer
Initial scorecard in the designer

4.2. Add a hierarchy for grouping

Go to the Explore window, locate your AdventureWorks cube and expand it. Drag the Product level under the Product hierarchy and drop it onto the Grouping hierarchy region (Drag a column or hierarchy here...).

This will cause the controls in the Group Body region to be repeated once for each product. The controls will be added to the region later.

Add a column for grouping
Add a column for grouping

4.3. Add controls to the Group Header

Elements in the Group Header region appear only once, they are not repeated. Before adding controls here, set the background color of this region by clicking inside the region. Go to Properties and change the background color to Gainsboro.

Set the background color of the Group Header
Set the background color of the Group Header

Next, go to the toolbar, click Components, and add four static text labels to the region. Make them bold and set the label text to match the column headings from the scorecard layout shown earlier. 

Add labels to the Group Header
Add labels to the Group Header

4.4. Display the Product Name

Elements in the Group Body region are repeated once for every product.

From your AdventureWorks cube, drag the Product level under the Product hierarchy to the Group Body region. A corresponding data label is created for you automatically.

Drag the Product level to the Group Body
Drag the Product level to the Group Body

Switch to View mode to see the scorecard with product names displayed along the rows.

Switch to View mode to see the scorecard so far
Switch to View mode to see the scorecard so far

4.5. Display the Sales by Date

In the Explore window, expand the Measures for your AdventureWorks cube, and then drag the Internet Sales Amount measure to the Group Body region. A corresponding data label is created for you automatically.

Right click on the data label and open its Data Binding Panel. Drag the Date.Calendar hierarchy from the AdventureWorks cube to the ROWS field of the Data Binding Panel.

Right click on the data label again and re-visualize it as a Line Chart.

Since there is not much real estate for the line chart, hide its axes by going to the Properties window. Click Bottom Axis 1 and uncheck the Visible property. Do the same for Left Axis 1.

Hide the bottom axis
Hide the bottom axis

Here's the line chart with its Data Binding Panel open:

Use a line chart to show Sales by Date
Use a line chart to show Sales by Date

This is basically a sparkline but there's an easier way to set this up. Go to the toolbar and click Data Visualization. Under the RECOMMENDED heading, click Sparkline which will add a pre-configured line chart. Then drag your measure and hierarchy onto this chart as before. This method saves you from having to adjust the properties of the line chart to hide axes, etc.

Add a sparkline to the scorecard
Add a sparkline to the scorecard

Besides Sparkline, there are other convenient options such as Data Bar and Bullet Graph.

4.6. Display the Order Count

In the Explore window, expand the Measures for your AdventureWorks cube, and then drag the Order Count measure to the Group Body region. A corresponding data label is created for you automatically.

Use a data label to show the Order Count
Use a data label to show the Order Count

4.7. Display the Sales by Territory

For the last measure, drag the Internet Sales Amount measure to the Group Body region. A corresponding data label is created for you automatically. Right click on the data label and re-visualize as a Bar Chart.

Right click on the chart and open its Data Binding Panel. Drag the Sales Territory Group level from the AdventureWorks cube to the ROWS field of the Data Binding Panel.

Use a bar chart to show Sales by Territory
Use a bar chart to show Sales by Territory

Next, go to the Properties window for the bar chart. Hide the bottom and left axis to remove the axes from the chart and gain some space. Then invert the axes so that the bars are horizontal.

Properties of the bar chart to set
Properties of the bar chart to set

4.8. Add a line separator

To add a separator between each row (product) of the scorecard, click inside the body region and go to Properties. Under the Look properties, click the plus sign to add a Separator Line style. Click the style to set its appearance and change the Stroke Width to 2 pixels (2px).

Add a line separator between products
Add a line separator between products

4.9. View the final scorecard

Switch to View mode to see the completed scorecard.

The completed scorecard
The completed scorecard

5. Using the scorecard in a dashboard

While editing a dashboard, drag the scorecard from the Explore window to your canvas. Then reposition and resize the scorecard like you would with any other data visualization control.

Embedding a scorecard view on an existing dashboard
Embedding a scorecard view on an existing dashboard

6. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri