Extracting from the Data Model with Cube Functions

Have you ever wanted to use information from your Excel data model without needing to put it into a pivot table? Are you frustrated by the limited formatting options that are available in Pivot Tables?
Maybe cube functions are for you!
This session will introduce cube functions, a powerful way to extract data from the Excel data model without needing a Pivot Table! There will be some basic DAX functions used, but most of the session will be focused on the 4 cube functions needed to build a non-pivot data-driven dashboard in Excel.

About the Speaker: Brent Allen
Brent Allen is a freelance Excel consultant based in Toronto, blogging from his company website at Macrordinary. He has a CPA designation, as well as an MBA from Queen’s University.
Prior to starting his consultancy, he worked in financial and business analysis roles in financial and real estate firms primarily focusing on improving spreadsheet processes through automation.
He has taught courses on financial spreadsheets and spreadsheet automation on the e-learning sites Pluralsight and DataCamp.

Find more about Brent's work and connect with him on the links below:
LinkedIn: https://www.linkedin.com/in/brentalleninto/
Blog: https://macrordinary.ca/blog/
Twitter: https://twitter.com/MacrordinaryCA

AGENDA: (Eastern Time)

5:30 PM - 5:40 - Introduction
5:40 - 6:40 PM - "Extracting from the Data Model with Cube Functions" by Brent Allen
6:40 PM - 7:00 PM - Q&A + Closing by Celia Alves and MS Excel Toronto Team

We are looking forward to meeting you there!