Skip to content
Dashboard
Menu
Dashboard
Courses
Discussions
My Account
Contact Us
Course Overview
Dimensional Modeling for the Power BI Pro
Course Content
Expand All
Course Introduction (PBI)
2 Lessons
Expand
Module Content
0% Complete
0/2 Steps
Getting Started
What is This Course All About? (PBI)
Overview of the Data Model (PBI)
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Where PivotTables Fail (PBI)
Enter the Data Model (PBI)
Relating the Tables (PBI)
Aggregating Data with DAX (PBI)
Filtering, Ordering and Sorting (PBI)
Architecting Business Intelligence Solutions (PBI)
9 Lessons
Expand
Module Content
0% Complete
0/9 Steps
Steps to Successful Business Intelligence (PBI)
Identifying the Business Process (PBI)
Wireframing Report Requirements (PBI)
Determining the Model Grain (PBI)
Structuring Data for Self Service BI (PBI)
Exercise: Designing Tables From Wireframes (PBI)
Solution: Designing Tables From Wireframes (PBI)
Determining Unique Columns Required for the Model (PBI)
Collecting and Normalizing Model Data (PBI)
Dimensional Modeling Terminology and Techniques (PBI)
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Facts and Dimensions (PBI)
Preparing For Dimensional Modeling (PBI)
Designing Dimension Tables (PBI)
Designing Fact Tables (PBI)
Extracting Facts with Measures (PBI)
Relating Tables (PBI)
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Relationship Types (PBI)
Relationship Schemas (PBI)
Relationship Issues (PBI)
Preventing Filtering Issues (PBI)
Methodology for Creating a Data Model (PBI)
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Designing a Data Model – Model-Driven Approach (PBI)
Assess Datasets (PBI)
Categorize Fields and Discover and Analyze (PBI)
Sketch and Prototype in Power BI
Dimensional Modeling Recipes (PBI)
11 Lessons
Expand
Module Content
0% Complete
0/11 Steps
Composite Key Joins (PBI)
Bridge Tables (PBI)
Flattening Snowflaked Dimensions (PBI)
Creating Calendar Dimensions (PBI)
Creating Calendar Boundaries (PBI)
Creating Calendars from StartDate to EndDate (PBI)
Fiscal Periods for 12-Month Standard Year Ends (PBI)
Adjustments for 12-Month Non-Standard Year Ends (PBI)
Fiscal Periods for 12-Month Non-Standard Year Ends (PBI)
Adjustments for 364-Day Calendars (PBI)
Fiscal Periods for 364-Day Calendars (PBI)
Slowly Changing Dimensions (PBI)
7 Lessons
Expand
Module Content
0% Complete
0/7 Steps
The Slowly Changing Dimension Issue (PBI)
Filling Blanks with Dates (PBI)
Option 1: Surrogate Keys Without Meaning (PBI)
Option 2: Surrogate Keys With Meaning (PBI)
Creating the Merging Bridge Table (PBI)
Replacing the Fact Table’s Primary Key (PBI)
Storing Dimensions on Fact Tables (PBI)
Many to Many Joins (PBI)
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Many to Many Patterns (PBI)
Many to Many with 1:Many in Power BI
Many to Many Physical Relationships in Power BI
Many to Many Virtual Relationships in Power BI
Solving Specific Business Issues (PBI)
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Header Detail Tables (PBI)
Stock on Hand Count Reporting (PBI)
Status Reporting (PBI)
Custom Time Intelligence (PBI)
Performance and Stability (PBI)
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Model Performance & Stability (PBI)
How the Vertipaq Engine Works (PBI)
6 Tips for Data Model Optimization (PBI)
Power Query Optimization (PBI)
Tools for Testing Model Performance (PBI)
Rate the Course
1 Lesson
Expand
Module Content
0% Complete
0/1 Steps
Course Feedback