BSC Designer Online provides a wide range of means for managing of KPIs. In the BSC Designer Online you have a "KPIs" tab where you can add all of your performance indicators.
Video Tutorial: Setup KPIs Step-by-Step
Creating a new KPI
Select an indicator that will be a container for a new KPI. Use "Add..." button on the toolbar to create a new indicator. The software will show several options:
New indicator - create a new indicator with data entered manually, via Excel, or via formula.
New imported indicator - create indicator linked to another indicator
New WebSQL indicator - create indicator that is powered by external SQL data source
The properties of an indicator
Select any indicator in the list of KPIs. The software will display properties of the indicator below.
Name. The name of the KPI. Try to keep it short and meaningful, don't overload it with details, and put the details into the description field.
Icon. Next to the "Name" field there is KPI's icon. You can change it by clicking on the icon image.
Description. The description field is for additional information about the KPI; it might be information about the measurement method.
Measure. Use this list to choose one of measurement units that is applicable to the KPI. If there is no measure that fits your needs click the button on the right from the "Measure" drop list to add a new measure.
Video Tutorial: Measure units for indicators
Value. The value field displays the current value of the KPI for the date selected in the calendar. The button next to the "Value" field allows to create indicators with custom formulas.
Max and Min values determine the minimum and maximum possible range for a value. Whereas baseline and target values show your working interval. Normally a baseline is a starting value and the target is a value that you wish to achieve.
Simple input mode. For some indicators the Baseline is always equal to Min value and the Target is always equal to Max value. Check this checkbox and the software will show only the baseline and target fields.
Weight. The relative weight of the indicator shows how this indicator is important compared to other indicators in the same container. The weight is taken into account when the performance of the container is calculated.
Optimization. What do you want to do with the value of a KPI? Would you like to minimize it (for example like a turnover of employees in a company) or you'd like to maximize it (for example profit value). Choose the appropriate optimization. If the dependency is not as simple as just a line function, you can enter a custom formula into BSC Designer Online that the program will use to calculate your performance and progress. To do this click on the "Edit" button next to the "Optimization" drop list.
Raw data indicator. Some indicators on the scorecard are just data storages that are not supposed to have a performance or a progress. Check this checkbox and BSC Designer won't take this indicator into account when calculating the performance of the scorecard.
Respectively to the max/min pair the performance of the KPI is calculated using the formula: Performance = (Value - mn) / (mx - mn). Respectively to the baselines/target pair the progress of the KPI is calculated: Progress = (Value - Baseline) / (Target - Baseline).
Video Tutorial: The difference between Progress and Performance
Indicator type. The type of indicator is defined in the context of its container. Lagging indicators contribute to the calculation of higher level items.
Leading indiators are used for local calculations only.
Glyph 1 and Glyph 2. Glyph settings for the indicator on the strategy map.
Video Tutorial: Indicators on strategy map
In the list of KPIs, there is a column "Initiatives." Click on the button in this column to access initiatives for the KPI.
Video Tutorial: Initiatives for the indicators and goals
Initiatives for the KPIs have the following properties:
Name of the initiative.
Description for the initiative; it can also be assigned to a specific date.
Duration and Budget are useful when you need to specify time and finance resources.
Person responsible option allows to specify the person who will receive email notifications about this indicator. This person should be registered as a user of BSC Designer Online under your account.
Document list - here you can add a link to any document with a detailed action plan. Normally users put a link here to a Word document located in some online file storage, such as Dropbox or a Google Drive.
For any KPI on the scorecard an update interval can be adjusted:
Open any scorecard and go to the KPIs tab
Select a KPI
Select "KPI Update Interval" command in "Tools" menu
Update interval dialog will appear:
Select required update interval and click "OK"
Video Tutorial: Update interval for indicators
In the "Update Interval" dialog you can use the "Select indicators" option to change update interval for many indicators at once.
It is possible to change the update interval that the software use by default for the new indicators, do this via menu "Tools" > "Default KPI update interval"
Manual data entry
To enter data manually follow these steps:
Select or create any indicator
If needed change an update interval as described above
Select appropriate date in the calendar
Enter a new numeric value into the "Value" field
Alternatively, you can select any indicator and click onto the "Values Editor" button on the toolbar.
Video Tutorial: Data input in BSC Designer
Value inheritance defines whether the software will use previous values for the new dates, or if it will use only entered values.
For example: there is a value of 21% for a KPI for September 1. Then user selects September 5th in the calendar.
If the inheritance is active the software will display 21% as a value for September 5, and will calculate the performance;
If the inheritance is disabled the software won't display any data for September 5, and won't calculate the performance;
Video Tutorial: Value inheritance
To adjust inheritance settings:
For specific indicators: select an indicator, click onto the "Values Editor" button on the toolbar, use the "Values inheritance" option.
For global settings: select "Values inheritance" in "Tools" menu.
BSC Designer allows grouping data by time periods.
Video Tutorial: Grouping of indicator values
The way the software groups the data is defined individually for each indicator via the Group by option. To adjust the "Group by" option:
Select an indicator
Click onto the "Values Editor" button on the toolbar
Use the "Group by" drop list.
Stop-lights are cycles of different colors that are displayed next to the performance and progress values.
The stop-lights help to quickly identify the state of the indicators.
Stop-light colors can be customized for an indicator:
Open a scorecard in BSC Designer Online
Go to the KPIs tab and select an indicator
Select "Stop-lights" settings in "Tools" menu
Enter new values for the stop-lights, check "Enabled" checkbox and click "OK":
Containers for KPIs
Any indicator that contains other indicators inside becomes a "container" in BSC Designer.
Video Tutorial: Container performance, leading, and lagging indicators
To create a container:
Select an indicator and create a new indicator inside using the "Add..." button on the toolbar. The selected indicator will become a container.
Drag and drop to place any existing indicator into another indicator, and the target indicator will become a container.
Choose any container indicator to display its properties. Most of the settings will be exactly the same as for the KPI, but there are two properties specific for a container:
Performance - use this property to tell the software how the "Performance" of the container should be calculated.
Value - use this property to tell the software how the "Value" of the container should be calculated.
The following options are available for the "Performance:"
Weighted average - the performance of the container will be calculated as an average of the performance values of the contained KPIs taking into account their weight.
Average - the performance of the container will be calculated as an average of the performance values of the contained KPIs
Max, Min - the software will find the max (or min) performance of the contained KPIs and will use it for the performance of the container
Sum - the performance of the container will be calculated as a sum of the performance values of the contained KPIs
Self-standing - the performance values of the contained indicators won't be taken into account; the performance of the container will be calculated using its own value, min, and max values
The following options are available for the "Value":
Weighted average - the value of the container will be calculated as an average of the values of the contained KPIs taking into account their weight.
Average - the value of the container will be calculated as an average of the values of the contained KPIs
Max, Min - the software will find the max (or min) value of the contained KPIs and will use it for the value of the container
Sum - the value of the container will be calculated as a sum of the values of the contained KPIs
Self-standing - the values of the contained indicators won't be taken into account; the value of the container will be entered manually by user
Performance - the software will use the performance of the container for its value field