Power BI Intermediate Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join

Exercise Files: https://bit.ly/2W9iMvZ

Who it's for: Business Analysts, Data Analysts, and everyone in between looking to take the next step in data processing and visualization.

What it is: Power BI is Microsoft’s business analytics platform. It’s designed from the ground up to take mass sets of data and organize, analyze, and visualize it using live dashboards and interactive reports.

What you'll learn: In this series, users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
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

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

(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.