Sunday, 28 May 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]
How to build an Activity based modelling system with SSAS Tabular and Power Pivot | Grant Paisley
Author: Grant Paisley Date Posted: 9/03/2015 1:51:53 PM
Grant Paisley

The ability to distribute costs, including overheads, to activities in an organisation allows profitability to be calculated down to an individual activity, hence the ability to calculate the *real* client and product profitability.

In this session we take a look how you can create an Activity Based Modelling system using SSAS Tabular for the allocation model, and Power Pivot (over the Tabular Model) for end-user reporting.

Having the final report model in Power Pivot gives the end user the ultimate control over reporting, including adding other information possibly not even held with Information Technology.

I'll show you an example health care model where we replaced an expensive, difficult to understand and maintain SAS system, with a simple elegant solution (auditable) based on the Microsoft stack. The rules are table driven with allocated costs handling built in. Having build the model with one of the finance team power users, they now own and understand the new system.

Venue: Mechanics School of Arts, Level 1, 280 Pitt St, Sydney | Duration 5:30 pm Pizza and drinks | 6 pm - 8pm Session | On: Tuesday, 12 May 2015