One of the advantages of using IT Analytics is the ability to use an intuitive reporting framework that lets you quickly translate large data volumes with the goal of making informed business decisions. Microsoft SQL Analysis Services leverages this capability through Key Performance Indicators (KPIs). KPIs are defined as quantifiable measures that represent a critical success factor in an organization. The emphasis is on the action of quantifying something in the environment. For example, the KPIs must be measurable to successfully be monitored and compared against a given objective.
In this article we will look at the native capabilities for easily creating a KPIs in the IT Analytics Data Loss Prevention Content Pack. Using the DLP Incidents Summary Cube we will create a KPI that will allow for the monitoring of incident trends over time.
To complete this exercise, you should have IT Analytics with the Data Loss Prevention Content Pack already installed. For more information, please refer to the Connect article for installing IT Analytics.
For the purposes of creating a KPI, the Status Expression is defined as a number between 1 and -1. While we defined this as Percentage of Goal in the previous exercise, the most flexible and granular way of defining how these values are populated is through an MDX string. This comes into play when we want to explicitly set an acceptable threshold for a certain metric.
This procedure is an example of enhancing the KPI that was previously created above.
CASE WHEN KPIValue("DLP High Severity Incidents Trend") > 2 * KPIGoal("DLP High Severity Incidents Trend") THEN -1 WHEN KPIValue("DLP High Severity Incidents Trend") < KPIGoal("DLP High Severity Incidents Trend") THEN 1 ELSE 0 END