Lesson 7: Defining Key Performance Indicators (KPIs)

 

Applies To: SQL Server 2016

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) in Multidimensional Models.

System_CAPS_ICON_note.jpg Note


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. Click here 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.

Lesson 8: Defining Actions

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

Community Additions

ADD
Show: