SSAS Tabular Part 8 : Create KPI (Key Performance Indicators)

Through KPI we can quickly understand a business. It indicates states of business modules success by some graphical indicator . KPIs are used to gauge performance of a value, defined by a Base measure, against a Target value.

We create KPI in top of the measure. To create KPI, we will use the Measure Grid. By default, each table has an empty measure grid.

Steps to create KPI

For example, I am taking Fact Internet Sales  table and going to create a KPI on it.

1. In the model designer, click the Internet Sales table (tab).

2. Click on the Measure Grid and select a cell.

3. In the formula bar, type the following formula and Press ENTER:     TotalOrderQuantity:=SUM([OrderQuantity]) (This measure will serve as the Base  measure for the KPI.)

4. Right-click the TotalOrderQuantity measure, and then click Create KPI.

5. In the Key Performance Indicator (KPI) dialog box, in Target, select the Absolute Value         option.

6. In the Absolute Value field, type 4300, and then press ENTER. (We set this value is the         target value)

7. In the left (low) slider field, type 1720, and then in the right (high) slider field, type 3440.

8. In Select Icon Style, select the first icon type (Circel-Red, Circel-Yellow, Circel-      Green).

9. Click OK.

Output:

1. To see it’s activity click the Model menu, and then click Analyze in Excel. 

2. In Excel, in the PivotTable Field List, notice the KPI’s and  Internet Sales measure    groups appear, as well as the Customer, Date, Geography, Product, Product Category,  Product Subcategory, and Internet Sales tables with all of their respective columns appear.

3. Now go to Product table and click on respective column EnglishColumnName. After that go to KPI’s and expand TotalOrderQuantity and click on Value and Status.

4. Now we can see the try color circle indicator (Red, Yellow, Green) for all Product Name and TotalOrderQuantity based on their value.

Apart from that we can define Target value as some measure name also. In this case STATUS THRESHOLD should be Percentage wise calculation. 
For example Assume TARGET Measure value is 100. Then we have to declare In the left (low) slider field, type 30% (Means 30% of 100), and then in the right (high) slider field, type 70% (Means 70% of 100).