Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Power BI Advanced Tutorial

Learnit Training via YouTube

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
This course covers advanced concepts in Power BI for Business Analysts and Data Analysts. Participants will learn to build queries, prep data, create relationships across databases, use Power Pivot, and develop live dashboards and interactive reports. The course includes topics such as creating calculated tables and columns, using DAX functions, time intelligence functions, key performance indicators, optimizing model performance, and more. The teaching method involves hands-on exercises and practical demonstrations.

Syllabus

Start
Introduction
Creating Calculated Tables
Creating Calculated Columns - DATEDIFF
Creating Calculated Columns - RANKX Highest
Creating Calculated Columns - RANKX Lowest
Creating Calculated Columns - RANKX Dense
Creating Quick Measures
Creating Measures
Creating Date Tables
Time Intelligence Functions
Key Performance Indicators
Additional Key Performance Indicators
DAX Recap
Introduction to Optimizing Model Performance
Publishing Dataset to Service
Using DirectQuery on Power BI Dataset
DirectQuery vs Import File Size Comparison
Importance of Variables
Building a Measure to Use in a Measure
Building a Measure with Variables and Comments
Adding Measures to Multi-Row Card
Other Optimization Techniques
Conclusion

Taught by

Learnit Training

Reviews

Start your review of Power BI Advanced Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.