Dimensional Modeling for the Excel and Power BI Pro

$270 USD for the first year, $69 USD/year after that

At the core of every good Power Pivot or Power BI solution is the Data Model. But do you really know how to work with it properly? What shape your tables should have? When you should split tables up, when you should flatten them, and how to manipulate the data on the fly to do so?

This on-demand course is intended to teach you the right way to build solid and scalable dimensional models.

This a subscription-based product, please see the SUBSCRIPTION & PRICING DETAILS section below for more information.




Dimensional Modeling for the Excel and Power BI Pro was created by Matt Allington, Ken Puls, and Miguel Escobar, three of the world’s leading business intelligence experts.

Built by business professionals, for business professionals, this course is intended to teach you the right way to build solid and scalable dimensional models. Whether you are already building data models regularly, or are new to the concept of dimensional modeling, this course will give you all the tools you need to build the best self service business intelligence models possible.

This is an exciting course, as it pairs two of self service business intelligence’s most powerful features (Power Query and the Data Model) together in one place, using each for what they were designed to do. You’ll leave armed with not only the experience, but handy reference cards to apply these techniques to your own data, and to determine, “Is this a Power Query job, or a DAX job?”

Plus, every registration will include both the Excel and Power BI versions of the course, so we’ve got you covered no matter which platform you are using.

Read the full course description on the main course page.

Product Details

  • Format: On-demand streaming videos, plus downloadable example files and handouts
  • Publisher: Skillwave Training (June 2020)
  • Language: English


The course will be on an annual subscription basis, with a list price of $270 USD for the first year ($69 annual subscription + a $201 sign-up fee) and then $69 USD/year after that. 

On your annual renewal date, your subscription will be automatically renewed with the credit card information on file unless you cancel your subscription beforehand. You will be emailed a renewal reminder about 4 weeks before the renewal date. Please see the FAQs below for more information about subscription renewals and cancellations.

What you’ll learn

What you get with the course

12+ Hours of Video Content

Downloadable Files and Handouts

Enrollment in both the Excel and Power BI versions of this course

Premium Content and Instructors

Support and Discussions Group

Course Certificate of Completion

Frequently Asked Questions

The videos are streamed on-demand and may be watched as often as you like. However, they are not downloadable. The example files and handouts for each lesson are downloadable.

All the videos for the course are hosted on Vimeo. Please note that some networks block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that your network allows access to Vimeo before registering in the Academy, to ensure that you will be able to see the videos.

We offer unlimited support from our trainers on the course materials. You may post your questions on the Discussion Forum for the course, or email us directly.

Please note that help with questions that arise from projects outside of the course materials is not included. We do offer private consulting and mentoring services for these types of questions.

Our system will automatically renew your subscription for another year on your expiry date using the billing information on file. About 4 weeks before your current expiry date, you will receive an email from us reminding you that the renewal is coming up and to confirm your billing details.

You may cancel your subscription at any time, and you will continue to have access to all of the course materials until your expiry date. To cancel your subscription, go to the Subscriptions of the your Account Dashboard and select the subscription to cancel.


There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.