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