For example, the sales department of an organization might use a KPI to measure monthly gross profit against projected gross profit. ![]() More about KPIsĪ KPI is a quantifiable measurement for gauging business objectives. Learn more about KPIs below, and then continue reading in the section that follows to see how easy it is to create your own KPI. Here's a PivotTable with Employee Full Name in rows and Sales KPI in values. If your model has no measures, see Create a measure. ![]() The KPI gauges the performance of the value, defined by a Base measure (also known as a calculated field in Power Pivot in Excel 2013), against a Target value, also defined by a measure or by an absolute value. Supported by a specific calculated field, a KPI is designed to help users quickly evaluate the current value and status of a metric against a defined target. Key performance indicators (KPIs) are visual measures of performance.
0 Comments
Leave a Reply. |