Working through the webinar one module at a time, you will receive instructions from the instructor, be asked to watch the video, complete a practice session and then return to the Zoom meeting for Q&A with the instructor and to review the module. The instructor will be available in the Zoom meeting for the duration of the day to answer questions.

Advisory: Videos are hosted on the video-sharing platform Vimeo - please ensure your computer, internet and browser settings allow you to access and watch videos hosted on Vimeo as this will be an integral part of the course.

Built-in to Microsoft Excel, Power Pivot is a technology that is revolutionizing the way that we look at data. Allowing us to link multiple tables together without a single VLOOKUP statement, it enables us to pull data together from different tables, databases and even external sources, where we never could before.

The capabilities of Power Pivot are amazing, but they require a sound understanding of a concept called “Dimensional Modeling” in order to get started. In this course we will explore what this means, teach you how to design your tables properly as well as link them together in the correct way to set you up for success.  Developed by a CPA with real world experience who is also a renowned Business Intelligence expert, this course is intended to teach you the right way to set up your Dimensional Model in order to make the next stage – writing DAX formulas – easy.

Please note that this course is not a course on writing DAX formulas. This course lays the proper groundwork to prepare for DAX Formulas for Power Pivot .

Accountants and data professionals who are responsible for building business intelligence reports, as well as self-taught Power Pivot users.

MAC users - This course is designed for and led in Windows-based Excel. Power Pivot cannot be installed in any version of Mac Excel.

• importing data to Power Pivot with Power Query
• solving the Un-vlookupable Problem
• understanding facts, dimensions and schemas
• solving common join problems
• dealing with slowly changing dimensions
• performance considerations

Live webinars have varying levels of expected interaction, with some requiring microphone and camera capabilities to support a proper learning experience – please email pdreg@bccpa.ca if you have concerns. 

In general, we encourage participants to have their cameras turned on to enhance their virtual learning experience. This practice promotes a stronger connection with the instructor and fellow participants, and fosters improved communication and collaboration.

Live Webinar FAQs can be found here.  

Registration terms and conditions, including the cancellation policy can be found here. If you require further assistance, please contact the PD Department.