Delivering KPIs with Microsoft SQL Server Analysis Services

Sign in to queue

Description

Key Performance Indicators (KPIs) are important measurements that influence behavior and allow an organization to evaluate whether they are meeting target for specific objectives. This session begins by introducing how KPIs are defined in Analysis Services, in both multidimensional and tabular BI Semantic Models, and then made available for consistent reporting using Microsoft Excel, Excel Services, SQL Server Reporting Services and PerformancePoint Services. Next, consideration is given to where the KPI sources its target data from. The session explores additional capabilities of the multidimensional BI Semantic Model to collect planning data, specifically by using cube write-back, and Data Mining to seed planning values. Finally, the session introduces how the Excel 2010 What-If Analysis feature can be used to support the collection of planning data from users. #TEDBI320
For more information, check out this course on Microsoft Virtual Academy:

Day:

1

Code:

DBI320

Embed

Download

Download this episode

For more information, check out this course on Microsoft Virtual Academy:

The Discussion

Add Your 2 Cents