Define and display key performance indicators

$!.$ IMPORTANT You must enable the Power Pivot add$-$in before you can complete this practice task. For information about Power Pivot and enabling the add$-$in$,$ see Chapter $15.$ "Perform business intelligence analysis."

Open the CreateKPIs workbook in Excel, and then perform the following tasks:

Open Power Pivot and display the Data Model.

Create a KPI named Status based on the Average of SuccessRate measure with the following characteristics:

An absolute value of $9925$

A green lower limit of $9900$

A yellow lower limit of $9825$

The black$-$bordered traffic$-$light icon set

From the Library of G

Chapter $16$

From Power Pivot, create a PivotTable on a new worksheet.

In the PivotTable Fields pane, add the Year and Month columns to the Rows area, and add the Success Rate and Status fields to the Values area.k