Delivering KPIs with Microsoft SQL Server Analysis Services
- Date: June 11, 2012 from 4:45PM to 6:00PM
- Day 1
- DBI320
- Speakers: Peter Myers
- 7,507 Views
- 1 Comment
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
Comment on this Session
Already have a Channel 9 account? Please sign in
Follow the Discussion
Very interesting session, thank you !
Remove this comment
Remove this thread
close