Data Modeling: Power Bi Data Modeling Essentials

Data Modeling: Power Bi Data Modeling Essentials
Published 3/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

Learn and Master Data Modeling for Advanced Power BI Development

What you’ll learn

Get strong foundation of data modeling useful in other data fields like Analytics Engineering & Data Engineering

Learn modeling techniques used by database designers

Learn all about managing and troubleshooting data models in Power BI

Understand the business logic of Facts and Dimension Tables

Design and Implement Star Schema Models for Power BI

Understand Snowflake Schema in Power BI

Dive into the world of M Language to create Data Tables with Power Query

Learn from a 5x Microsoft MVP and Creator of Udemy Best Selling Power BI Course

Requirements

Power BI Desktop

Description

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Understanding Data Normalization

Lecture 5 Understanding Facts & Dimension Fields

Lecture 6 Eliminating Redundancy with Normalized Data

Lecture 7 Understanding the requirements for Normalizing data

Lecture 8 Creating plan for Normalization

Lecture 9 Mapping out Data for Normalization

Lecture 10 Mapping the Fact Fields

Lecture 11 Creating an Entity Relationship Diagram (ERD)

Section 2: Normalizing Data with Power Query

Lecture 15 Organizing Queries into Folders in Power Query

Section 3: Working with Normalized Data in Power BI

Lecture 23 Understanding Star and Snowflake Schema

Lecture 24 Converting a Snowflake Schema to Star Schema

Section 4: Creating Date Tables with DAX in Power BI

Lecture 25 Introduction to Date Dimension Table

Lecture 26 Intro to creating Date Tables with DAX

Lecture 27 Creating Date Table with CALENDARAUTO function

Lecture 28 Validating Date Tables & Connecting to Fact Table

Lecture 29 Creating Year Column with YEAR function

Lecture 31 Creating Month Name column with FORMAT function

Lecture 32 Fixing month sorting order

Lecture 33 Creating Day of Week Column

Lecture 34 Fixing Day of Week Sorting

Lecture 35 Creating week of year column

Section 5: Creating Date Tables with M in Power Query

Lecture 36 Intro to creating date tables with Power Query

Lecture 37 Step 1 of Power Query Dates – Extract Data Dates

Lecture 38 Step 2 of Power Query Dates – Get first and last data dates

Lecture 41 Step 5 of Power Query Date – Create duration step and flesh out date table

Section 6: Working with multiple Fact Tables

Lecture 42 Intro to working with multiple fact tables

Lecture 43 Preparing Target Data

Lecture 44 Create relationships for Target Data

Lecture 45 Understanding and Managing Many to Many Relationships

Lecture 46 Managing Many to Many relationships with bridge tables

Section 7: Troubleshooting Data Models in Power BI

Lecture 47 Intro to Data Modeling Troubleshooting

Lecture 48 Troubleshoot when all report categories display the same values

Lecture 49 Troubleshoot when all report categories are not displaying any values

Lecture 50 Troubleshoot when date categories are blank

Lecture 53 Troubleshoot when to show categories with no data and when categories are blank

Beginner to Intermediate Data Modeling Experience,Power BI Beginners to Intermediate Users,Need to learn Power BI Model troubleshooting,Looking to earn the Power BI Certification,Business Intelligence enthusiasts,Data Science enthusiasts,Interested in Data Modeling,Looking to understand ERDs,Want to understand Star and Snowflake Model Schema,Need to understand Power BI Model relationships