SSRS TUTORIAL : 04 (KPI REPORT)

preview_player
Показать описание
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.
Рекомендации по теме