Tuesday, 26 September 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: Grant Paisley Date Posted: 8/01/2014 8:59:35 PM

NOTE THIS IS ON *WEDNESDAY* NIGHT!

This is a must see session from one of the leading presenters in the world of SQL. Peter will show you techniques that you can apply to create amazingly flexible reports in Excel. "Need that P&L report done just how the board want it", no problem.

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, integration of data from multiple data models, and macro-driven layouts.

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 PowerPivot).

Grant

Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney | Duration 5:30PM Networking (Pizza & Drinks provided) 6:00PM Session | On: Wednesday, 12 February 2014