Tuesday, 30 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]
Mastering the CUBE Functions in Excel - Peter Myers
Author: Darren Gosbell Date Posted: 21/03/2014 8:46:16 AM
This presentation explores the seven CUBE functions that are natively available in Excel 2007, 2010 and 2013. Unknown to many business analysts, these useful functions can be used to retrieve data model members and values to create parameter-driven report designs. The session topics will introduce each of the seven functions. Demonstrations will range from the simple, to the more sophisticated involving dynamic expressions, MDX expressions, Apps for Office, integration of data from multiple data models, and a macro-driven layout. This session is a must for those looking to drive more from Excel when reporting from the BI Semantic Model – multidimensional (cube) or tabular (including Power Pivot).
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, 15 April 2014