Data Modeling: Power Bi Data Modeling Essentials

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

In this Data Modeling course, you will learn all you need to know to create and Manage Data Models in Power BI. You will be able to troubleshoot Power BI Data Models when things are broken in your reports. Taught by 5x Microsoft MVP for Data Platform and creator of Udemy's Power BI Best Seller Course.This course is deigned to allow you gain mastery of the heart and engine of Power BI Solutions: The Power BI Data Model. You will learn about Data Modeling Concepts valuable in other data fields like Database Administration, Analytics Engineering, Data Engineering and Data Warehousing.Below is a list of the topics covered in this Power BI Data Modeling Essentials Course:Understanding Data Normalization ConceptUnderstanding Fact and Dimension TablesCreating your own Fact and Dimension Tables from a De-Normalized DataUsing Power Query and simple M Language Technique to Normalize a Data TableUnderstanding Model Relationships Cardinality and Cross Filter DirectionUnderstanding One to One, Many to One and Many to Many RelationshipsUsing DAX to create and Configure Date Tables in Power BI Data ModelsUsing simple Power Query M Language technique to create Date Tables for Power BI Data ModelsWorking with Multiple Fact Tables in a Power BI ModelTroubleshooting Data Models in Power BIBy the end of this course, you will be confident with Models in Power BI and will be on-course to Advance your Power BI knowledge, especially Data Analysis Expressions (DAX).Enroll now and get started on your journey to Masting Data Modeling for Advanced Power BI Development.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Understanding Data Normalization

Lecture 3 Understanding Transactional data and normalization (part 1)

Lecture 4 Understanding Transactional data and normalization (part 2)

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 12 Data Normalization with Power Query (part 1)

Lecture 13 Data Normalization with Power Query (part 2)

Lecture 14 Data Normalization with Power Query (part 3)

Lecture 15 Organizing Queries into Folders in Power Query

Section 3: Working with Normalized Data in Power BI

Lecture 16 Confirming model relationships (part 1)

Lecture 17 Confirming model relationships (part 2)

Lecture 18 Understanding Cardinality and Cross-filter direction (part 1)

Lecture 19 Understanding Cardinality and Cross-filter direction (part 2)

Lecture 20 Explaining Cross filter direction (part 1)

Lecture 21 Explaining Cross filter direction (part 2)

Lecture 22 Explaining Cross filter direction (part 3)

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 30 Create Quarter and Month Number Columns

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 39 Step 3 of Power Query Date - Get Start and End Dates

Lecture 40 Step 4 of Power Query Dates - Create Difference of start and end date

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 51 Troubleshoot when unable to create relationships (part 1)

Lecture 52 Troubleshoot when unable to create relationship (part 2)

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