Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Power BI Super Users Workshop
Power BI Super Users Workshop
Course Overview
Let's get started
Definition of Terms
Goals for this training (3:16)
Resources we will be using in this course (5:48)
Power BI Workshop Resource Pack
Introduction
Power BI explained (4:23)
Why reporting in Power BI is better than in excel (7:10)
Why you are now building analytical solutions (4:41)
4 Pillars of high quality Power BI solutions (4:36)
Review Question
Review Question Feedback
Querying and Transforming Data
What is the query editor? (2:09)
The essential way to source data for Power BI (4:12)
Fundamentals of using the query editor (9:22)
Querying multiple data sources in the same model (3:00)
Best practices for transforming data in the query editor (4:34)
Row & Column transformations (15:00)
Making sure data types are correct (2:34)
Create groups for your queries (3:20)
What is 'M' and why do you need to have an understanding (7:39)
Query dependencies (6:33)
Importance of date tables (9:06)
Review Question
Review Question Feedback
Data Modeling
Introduction to the importance of the data model (4:08)
Where to manage relationships for your data model (2:55)
Understanding what types of tables you have & setup techniques (5:46)
Setting up relationships in your models (7:56)
Difference between active and inactive relationships (5:06)
Building out additional dimensions in your data (7:32)
Review Questions
Review Question Feedback
DAX Calculations
DAX explained & key techniques to learning it (4:19)
Getting started & naming conventions tips (4:59)
Calculated columns versus measures (6:38)
Creating a measure table & organising your measures (3:56)
Context! - What is this? (4:12)
Evaluation (initial) context (5:44)
Aggregating formulas or filter context (7:58)
Iterating formula or row context (11:11)
Main table functions (10:26)
Building measures on measures (measure branching) (6:00)
CALCULATE function - the most important function in DAX (6:06)
Simple Time Intelligence functions (7:33)
More advanced DAX formula examples (10:43)
What you can achieve if you learn DAX well (4:44)
Review Question
Review Question Feedback
Reports and Data Visualizations
Design best practice tips (6:04)
Developing visualizations in Power BI (14:30)
How to create colour themes for your reports (5:02)
Visualization and report formatting (12:23)
Managing interactions between visuals (7:26)
Additional filtering across your reports (5:55)
Analytics automation features (8:18)
Importing custom visuals (3:55)
Review Question
Review Question Feedback
Power BI Online Service
How to publish your data to the web (3:05)
Power BI service explained (7:26)
Apps & Workspaces explained (7:06)
Reports vs Dashboards (9:04)
Email subscriptions, comments and other compelling features (5:30)
Q+A feature in-depth (7:15)
Admin settings within the online service (8:32)
Review Question
Review Question Feedback
Tips for using Power BI within an organisation
Enterprise architecture recommendations for Power BI (3:34)
Develop Power BI desktop templates to scale reporting requirements (3:28)
Row level security (8:52)
The Microsoft Power Platform (7:06)
Why Power BI is going to be huge! (4:51)
Your Feedback
Course Survey
End-of-Course Assessment
Take final assessment here!
Certification
Certificate & Badge
Creating a measure table & organising your measures
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock