Dimensional Modeling for the Excel and Power BI Pro

$69.00 / year and a $120.00 sign-up fee

**IMPORTANT NOTE: This course is in active development and will be released in three phases over the next two months as the new lessons are produced. Only Phase 1 content is currently available.

We will be offering a series of discounts as we progress through the release phases – the pricing above reflects the current phase discount. Please see the SUBSCRIPTION & PRICING DETAILS section below more information.

Specs

SKU: DIMENSIONAL_MODELING Category:

Description

Dimensional Modeling for the Excel 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.

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

SUBSCRIPTION & PRICING DETAILS

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. However, because of the phased release the first year’s price will be discounted as we progress through the phases.

Our targeted release schedule is as follows:

  • Phase 1 (first 3 modules) – June 11, 2020
    • Price = $189 USD for the first year (30% off), and then $69/year after that
  • Phase 2 (next 6 modules) – July 2020
    • Price = $216 USD for the first year (20% off), and then $69/year after that
  • Phase 3 (final 3 modules) – August 2020
    • Price = $270 USD for the first year (no discount), and then $69/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

  • Review of the core data model benefits
  • Dimensional modeling terminology and theory
  • Dimensional modeling design and architecture
  • Recommended modeling practices
  • Wireframing report requirements
  • How to solve common join problems
  • Patterns to get your data in the correct format
  • Creating calendar tables on the fly
  • Linking tables with different date granularities
  • Case studies for industry issues
  • Dealing with slowly changing dimensions
  • Data optimization rules to keep your models performant

What you get with the course

8+ Hours of Video Content (once all phases are released)

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.

Renewals:
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.

Cancellations:
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.

This course is currently in active development and so will be released on a phased basis. Our targeted release schedule is as follows (please note that it is subject to change):

  • Phase 1 (first 3 modules) – June 11, 2020
  • Phase 2 (next 6 modules) – July 2020
  • Phase 3 (final 3 modules) – August 2020

Reviews

There are no reviews yet.

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