Mastering the CUBE Functions in Excel 2013
Play Mastering the CUBE Functions in Excel 2013
This session explores the seven CUBE functions that are natively available in Excel 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, Apps for Office and macro-driven layouts. The publication of Excel workbook to SharePoint, and the embedding of reports into web part pages will also be covered. This session is a must for those looking to drive more from Excel when reporting from the BI Semantic Model. Much of the content presented in this session is also applicable to Excel 2007 and Excel 2010.