addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1light-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Peter Myers: Mastering the CUBE Functions in Excel

You'll learn and see live demos of the seven CUBE functions that are natively available in Excel since the Office 2007 release. Unknown to many business analysts, these useful functions can be used to retrieve data model members and values to create parameter-driven report designs.

This session is a must for those looking to drive more from Excel when reporting from the BI Semantic Model, whether it be a PowerPivot data model, a tabular database or multidimensional cube.

This is an alternative approach to reporting from Analysis Services data models that provides control and customization opportunities not (easily) supported by conventional data model reporting tools such as PivotTable, Power View, Reporting Services, etc.
You Will Learn

• About each of the seven CUBE functions

• Practical uses and considerations for building creative reports and dashboards.

• How to create dynamic parameters to produce dynamic reporting content

• When to use, and when not to use, the CUBE functions

• How to describe common and advanced scenarios for using the CUBE functions in report designs
Aussie Peter Myers specializes in Microsoft Business Intelligence (BI) and provides mentoring, technical training and course content authoring for Microsoft SQL Server and Microsoft Office.  Specifically, he works with SQL Server BI and Office BI, including Power BI.

Join or login to comment.

  • supattra

    Please advise where can I find the slide show/presentation?

    February 8, 2015

  • James S.

    That presentation was so well done. Prepared, well timed, worth following, and lots of little gems along the way. I also want to see the slide show again. Thank you Peter.

    May 13, 2014

  • Lisa

    Thanks so much for the presentation. It was awesome! The event is great!

    May 9, 2014

  • Elena S.

    Excellent presentation. I'll be using the material for work within weeks. Now to go learn how to build the data map in excel as we don't have SQL server.

    May 9, 2014

  • Angella J.

    excellent event!

    May 9, 2014

  • Amara James M.

    I love the presentation.

    May 9, 2014

  • Erik R.

    Great content and looking forward to the materials being posted.

    1 · May 8, 2014

  • Danqi Z.

    Anyone driving from San Francisco?

    May 8, 2014

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy