Sunday, 20 August 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
Delivering KPIs with Analysis Services - Peter Myers
Author: Darren Gosbell Date Posted: 12/05/2013 7:54:21 PM
Key Performance Indicators (KPIs) are important measurements that influence behaviour and allow an organization to evaluate whether they are meeting target for specific objectives.

This presentation will demonstrate how KPIs can be defined in Analysis Services, in both multidimensional and tabular BI Semantic Models, and then made available for consistent reporting using Excel, Excel Services, Reporting Services and PerformancePoint Services.


Consideration will be given to where the KPI sources its target data from, and 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. The presentation will also show how the Excel 2013 What-If Analysis feature can be used to collect planning data from users.

About the Speaker:
==============

Peter Myers from BizData has worked with Microsoft database and development products since 1997. Today he specializes in Microsoft Business Intelligence and provides mentoring, technical training, and course content authoring for SQL Server and Microsoft Office. His focus is on SQL Server Integration Services, SQL Server Analysis Services (data modeling and data mining), SQL Server Reporting Services, Microsoft 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. He has been an MVP since 2007. Peter is also an established speaker and enjoys sharing his enthusiasm for Microsoft products by presenting in classrooms and at user group meetings, technical events, and conferences.

Venue: Microsoft Level 5, Building 4, Freshwater Place, Southbank , Melbourne, VIC | Duration 5:30PM pizzas & drinks for 6:00 start, approx 7:45pm finish | On: Tuesday, 21 May 2013