Delivering KPIs with Microsoft SQL Server Analysis Services and BISM

Sign in to queue

Description

Key Performance Indicators (KPIs) are important measurements that influence behavior and allow an organisation to evaluate whether they are meeting targets 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.
For more information, check out this course on Microsoft Virtual Academy:

Day:

2

Code:

DBI202

Embed

Download

Download this episode

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

The Discussion

Add Your 2 Cents