Delivering KPIs with Microsoft SQL Server Analysis Services and BISM
Play Delivering KPIs with Microsoft SQL Server Analysis Services and BISM
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.