Mastering the Excel CUBE Functions
This session explores the seven CUBE functions that are natively available in Excel since Office 2007. Unknown to many business analysts, these useful functions can be used to retrieve data model members and values to create cell-by-cell report and dashboard 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. 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 – tabular or multidimensional.
Sorry, there are no downloads available for this session.
Peter Myers has been working with Microsoft database and development products since 1997. Today he specializes in Microsoft Business Intelligence and provides mentoring, technical training and course content authoring for Microsoft SQL Server and Microsoft Office. Specifically, he works with SQL Server Integration Services, SQL Server Analysis Services (data modeling and data mining), SQL Server Reporting Services, Microsoft Excel, PowerPivot and PerformancePoint Services.
He has a broad business background supported by a Bachelor degree in applied economics, and he extends this with current MCITP and MCT certifications. He has been a SQL Server MVP since 2007.
Peter is an established presenter and enjoys sharing his enthusiasm for Microsoft products by presenting in classrooms and at user group meetings, technical events and conferences.
The video is not available to view online.