Power BI Intermediate Tutorial
Exercise Files: https://bit.ly/2W9iMvZ
For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com
Enroll in our live, instructor-led Power BI classes:
https://bit.ly/3r73rY8
For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops
Join our online community! - https://www.offsitebylearnit.com
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Data Shaping - Renaming Tables 0:42
Data Shaping - Promoting the First Row 2:21
Data Shaping - Duplicating Column Replace Values 4:41
Data Shaping - Removing Columns 7:29
Data Shaping - Filtering, Sorting, and Applying Changes 9:36
Introduction to Enhancing Data Structure 13:52
Enhancing Data Structure - Join Types Merge Queries 16:25
Data Profiling Recap 21:16
Introduction to Designing a Data Model 26:03
Working with Tables 27:09
Fact vs Dimension 33:04
Breaking Down Tables 34:30
Creating Hierarchy 41:10
Relationships aka Cardinality 43:26
Creating Relationships 45:20
Reviewing the Model Interface 51:26
Creating RLS Roles in Desktop 55:10
Assigning Users to RLS Roles in Service 59:34
Conclusion 1:01:59
#PowerBI