Lesson 7: Defining Key Performance Indicators (KPIs)

Applies to: SQL Server Analysis Services Azure Analysis Services Power BI Premium

In this lesson, you learn to define Key Performance Indicators (KPIs) in your SQL Server 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) in Multidimensional Models.


Completed projects for all of the lessons in this tutorial are available online. You can jump ahead to any lesson by using the completed project from the previous lesson as a starting point. See Analysis Services samples to download the sample projects that go with this tutorial.

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.

Next Lesson

Lesson 8: Defining Actions

See Also

Analysis Services Tutorial Scenario
Multidimensional Modeling (Adventure Works Tutorial)
Key Performance Indicators (KPIs) in Multidimensional Models