Power BI Intermediate Tutorial

Power BI Intermediate Tutorial

Get Ad-Free Training by becoming a member today!

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:

Enroll in our live, instructor-led Power BI classes:

For Private Group Trainings please visit:

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.

[alinaqvi]

Amazing, I have complete the beginner and intermediate PBi tutorial, and now heading toward the Advance, best PBi course ever came a cross, very clear accent and structured instruction. Well done Trish

[senorbenny]

I will watch all 8 hours of this, Trish is so eloquent and informative, thank you Learnit Training for these amazing insightful videos and I express my gratitude for keeping these videos free, I would highly recommend these videos to anyone who wants to learn PowerBI, onto the Advanced Tutorial! Cheers

[LaxmikantMaheshjiKabra]

The best tutorial for Power BI on YouTube. I watched the series between 1.75x to 2x speed and the instructions were clear. Topics covered are well planned and this being free is a positive step to open learning. Thanks!

[ehsanreghabi]

i can't believe this is FREE ! great job... it's simple yet complex. perfectly balanced ! thank you !

[oluwaseunshogbamu]

Thank you for taking the time to explain and demonstrate how it works

[harryanderson]

First, I'm grateful for this free course. However, I've just spot an issue in 40:11. You need to remove duplicate first before assigning index for the primary key or there'll be different index with the same product name

[LosoIAm]

This is the most comprehensive and free tutorial - Gold, THANK YOU!

[RobiyaAxmedova-fh]

This is really amazing 🤩🤩🤩. I am absolutely grateful for the Learnit, thank the Learnit team and Trish. I have just finished the Intermediate course, and I am ready to dive into the next course.

[liaroy]

Trish, you're absolutely amazing. Thank you for all the efforts !

[jaitiwari]

I want to give one suggestion .please zoom the screen while explaining the concept..Amazing tutorial

[joseernestosabatercalvet]

Thank you Trish for the tutorial. I really like the way you explained it all. Moving to Advanced now!

[giftkay]

At 47:20 where the relationships were created by pbi. I dont know why my relationships and the ones in the video are not same. example my order to managers relationship line is 1:*.

[writerconnect]

been watching the videos from the first one that you had posted. this is eloquent and really nice

[manishnaik]

God Bless such content creators who put so much efforts and put it out there for free .... typical king/Queen behavior 👑

[TrangNguyen-yony]

best ever Power bi trainning, thanks so much

[newtestamentharp]

Excellent, this is the best Power BI tutorial I have ever seen, great

[diaashaaban-jx]

there`s no words can describe how is this useful to me, thank you so much ♥

[mfundokhumalo]

You're the best!. You try by all means to make it simple for us. Thank you very much !

[Somya_bhardwaj]

Thanks for the video ❤..Is there any online platform like leetcode where i can practice power bi .

[harshiniadusumilli]

Just now done with Beginner tutorial, it was easy peasy apart from the last part about cloud and local, it was not working out for me.