Lesson 7: Defining Key Performance Indicators (KPIs)

In this lesson, you learn to define Key Performance Indicators (KPIs) in your Analysis Services project. KPIs provide a framework for defining server-side calculations that measure your business, and they standardize how the resulting information is displayed. KPIs can be displayed in reports, portals, and dashboards, through data access APIs, and through Microsoft tools and third-party tools. KPIs are metadata wrappers around regular measures and other Multidimensional Expressions (MDX) expressions. For more information, see Key Performance Indicators (KPIs).


A completed project through Lesson 6 is available by downloading and installing the samples. For more information, see Considerations for Installing SQL Server Samples and Sample Databases.

This lesson contains the following task:

  • Defining and Browsing KPIs
    In this task, you define KPIs in the Form view and then switch to the Browser view to browse the cube data by using the KPIs.