PowerPivot KPI Setup – Excel

PowerPivot KPI - arrows

PowerPivot is an added functionality in Excel that offers a dynamic way to display information from other sources. A KPI (Key Performance Indicator) allows a user to dynamically create visuals for data being displayed in the PowerPivot table. Once you have a PowerPivot table setup, which requires a number of steps that include activating the PowerPivot contextual tab, ensuring the data you want to display is added to the PowerPivot model, and creating at least one Measurement.

Watch our video on setting up KPIs for your PowerPivot table:

If you are not familiar with these items, a great place to learn about PowerPivot is by taking our Excel Dashboards class. MCT is now offering some of its Excel training online. Check it out!