Delivering KPIs with Analysis Services
Presenter: Peter Myers, Solid Quality Mentors
Session 12: September 15 at 23:00 GMT
Key Performance Indicators (KPIs) are important measurements that allow organizations to evaluate whether they are meeting targets for specific objectives. This session will begin by introducing how KPIs are defined in Analysis Services cubes and made available for consistent reporting through Excel, Reporting Services, and PerformancePoint Services. Next, we’ll look at where the KPI sources its target data and explore additional capabilities of Analysis Services to collect planning data, specifically by using cube write-back and data mining to seed planning values. Then we’ll see how you can use the new Excel 2010 What-If Analysis feature to support the collection of planning data from users.
About the Speaker
Peter Myers, a Mentor with Solid Quality Mentors, has 13 years of experience working in OLTP database design and development, DBA support, and data warehousing/Business Intelligence with SQL Server. Specializing in Microsoft BI, he provides mentoring, technical training, and course content authoring for SQL Server and Office, working with Integration Services, Analysis Services (cubes and data mining), Reporting Services, Excel, PowerPivot, and PerformancePoint Services.
Peter has a broad business background supported by a bachelor’s degree in applied economics, and he extends this with current MCITP and MCT certifications. A Microsoft MVP since 2006, he is an established presenter and enjoys sharing his enthusiasm for Microsoft technologies by presenting at user group meetings, technical events, and conferences.
Register now for 24 Hours of PASS!