Power BI Advanced 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/3K9MMfh

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
Creating Calculated Tables 2:08
Creating Calculated Columns - DATEDIFF 6:03
Creating Calculated Columns - RANKX Highest 9:32
Creating Calculated Columns - RANKX Lowest 12:54
Creating Calculated Columns - RANKX Dense 18:50
Creating Quick Measures 20:40
Creating Measures 26:54
Creating Date Tables 31:38
Time Intelligence Functions 41:59
Key Performance Indicators 46:13
Additional Key Performance Indicators 49:59
DAX Recap 53:44
Introduction to Optimizing Model Performance 54:41
Publishing Dataset to Service 57:16
Using DirectQuery on Power BI Dataset 59:48
DirectQuery vs Import File Size Comparison 1:01:46
Importance of Variables 1:05:09
Building a Measure to Use in a Measure 1:07:11
Building a Measure with Variables and Comments 1:09:06
Adding Measures to Multi-Row Card 1:16:59
Other Optimization Techniques 1:19:53
Conclusion 1:21:23

#PowerBI