SERVICE
Advanced Power BI: Data Modeling (self-paced)
What to know
Prerequisites
This is an advanced course and is geared towards Power BI users who are already familiar with intermediate topics such as data modeling and basic DAX expressions or familiarity with other coding/ programmatic languages (i.e. R, Python, SQL).
Completion of Data Academy’s Intro to Power BI and Intermediate Power BI courses is required. This course assumes a good working knowledge of Power BI. Heavy use is made of the query editor and familiarity is assumed. This course is not designed as a refresher course, but as the next stage in training for advanced Power BI analysts.
About this course
The goal of the video course is to teach through examples of increasing complexity how to solve business scenarios by adapting the data model, so that the required DAX code becomes easier, faster and more robust. All the demos and the exercises are based on Power BI examples. The course is provided through the SQLBI online portal and made available by DataSF.
Duration: Includes over 15 hours of recorded lectures, plus another 15-20 hours of individual exercises. You will have access to this course for two weeks.
Location: The course is fully self-paced and online.
What to know
Prerequisites
This is an advanced course and is geared towards Power BI users who are already familiar with intermediate topics such as data modeling and basic DAX expressions or familiarity with other coding/ programmatic languages (i.e. R, Python, SQL).
Completion of Data Academy’s Intro to Power BI and Intermediate Power BI courses is required. This course assumes a good working knowledge of Power BI. Heavy use is made of the query editor and familiarity is assumed. This course is not designed as a refresher course, but as the next stage in training for advanced Power BI analysts.
About this course
The goal of the video course is to teach through examples of increasing complexity how to solve business scenarios by adapting the data model, so that the required DAX code becomes easier, faster and more robust. All the demos and the exercises are based on Power BI examples. The course is provided through the SQLBI online portal and made available by DataSF.
Duration: Includes over 15 hours of recorded lectures, plus another 15-20 hours of individual exercises. You will have access to this course for two weeks.
Location: The course is fully self-paced and online.
What to do
1. Review the course learning objectives
This course is aimed at users of Power BI Desktop or Power Pivot for Excel, and at Analysis Services developers who want to learn how to build the optimal data model for their reporting needs. You will learn:
- Introduction to data modeling
- Header/detail tables
- Multiple fact tables
- Working with date and time
- Tracking historical attributes
- Using snapshots
- Analyzing date and time intervals
- Many-to-many relationships
- Working with different granularities
- Segmentation date models
- Working with multiple currencies
2. Join the interest list
Fill out our Course Interest form to get a notification email when courses open for enrollment.
This email will include a short Enrollment Form that you will need to fill out to get on the waitlist for that scheduled class. Seats are granted on a first-come, first-served basis so please complete the enrollment form as soon as you can.
Note that filling out the course interest form does NOT guarantee enrollment in any course.
More details
Resources
- Review our Enrollment Process before signing up for a class
- Find relevant Course Materials in our Google Drive
- Review our No-Show Policy