filmov
tv
SSRS TUTORIAL : 04 (KPI REPORT)
Показать описание
This tutorial video describes how to careate KPI reports using ssrs.
A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a goal. Key Performance Indicators are valuable for teams, managers, and businesses to evaluate quickly the progress made against measurable goals.
By using KPIs in SQL Server 2016 Reporting Services, you can easily visualize answers to the following questions:
What am I ahead or behind on?
How far ahead or behind am I?
What is the minimum I have completed?
Creating a Dataset:
A KPI will only use the first row of data from a shared dataset. Make sure that the data you want to use is located on that first row. To create a shared dataset, you can use either Report Builder or SQL Server Data Tools.
Placement of KPIs:
KPIs can be created in any folder in your report server. Before you create a KPI, you will want to think about where is the right location to place it in. You will want to place it in a folder that will be visible to the users, at the same time being relevant to other reports, and KPIs, around it.
Adding a KPI
Refreshing a KPI:
To refresh the KPI, you will need to configure a caching for the shared dataset.
A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a goal. Key Performance Indicators are valuable for teams, managers, and businesses to evaluate quickly the progress made against measurable goals.
By using KPIs in SQL Server 2016 Reporting Services, you can easily visualize answers to the following questions:
What am I ahead or behind on?
How far ahead or behind am I?
What is the minimum I have completed?
Creating a Dataset:
A KPI will only use the first row of data from a shared dataset. Make sure that the data you want to use is located on that first row. To create a shared dataset, you can use either Report Builder or SQL Server Data Tools.
Placement of KPIs:
KPIs can be created in any folder in your report server. Before you create a KPI, you will want to think about where is the right location to place it in. You will want to place it in a folder that will be visible to the users, at the same time being relevant to other reports, and KPIs, around it.
Adding a KPI
Refreshing a KPI:
To refresh the KPI, you will need to configure a caching for the shared dataset.