Video - Delivering KPIs with Microsoft SQL Server Analysis Services

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 and PerformancePoint Services in Microsoft SharePoint Server, and SQL Server Reporting Services. Next, consideration will be given to where the KPI sources its target data from. The session will explore 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 will introduce how the Excel 2013 What-If Analysis feature can be used to support the collection of planning data from users.