Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Power BI Super Users Workshop
Introduction
Goals for this training (4:23)
Power BI explained (7:11)
Why reporting in Power BI is better than in excel (10:08)
Current pricing and purchasing considerations (4:43)
Where has Power BI come from? (2:54)
Key components of Power BI (4:22)
Power BI Desktop features explained (8:42)
Power BI online service features explained (11:56)
Why you are now building analytical solutions (5:23)
What is a data model? (4:52)
Data we will be using for all our examples (2:25)
Why naming conventions are so important in Power BI (7:38)
4 pillars of high quality Power BI solutions (3:45)
Querying and Transforming Data
What is the query editor? (2:19)
Query editor ribbon (10:12)
Data transformations and shaping features (3:51)
How to query data from excel (4:53)
Querying data from a database (3:50)
Query data from the web (7:12)
Other ways to retrieve data (Saas, Files, Folders, Azure) (3:41)
Import vs DirectQuery mode (5:41)
Querying multiple data sources in the same model (11:04)
Create groups for your queries (2:23)
Query staging (5:55)
What happens when you make a transformation (5:29)
Best practice tips for cleaning and shaping data (5:20)
Transforming data in the query editor (4:48)
Row & Column transformations (7:01)
Transforming Text, Dates, Numbers (4:26)
Making sure data types are correct (4:13)
What is 'M' and why do you need to have an understanding (2:51)
Query dependencies (5:05)
Importance of date tables (12:19)
Custom date table code
Data Modeling
Introduction to data modelling (3:31)
Where to manage relationships for your data model (6:58)
Why is data modeling so important? (2:34)
How quality data models bring immense scale to you analytical capabilities (2:06)
How to learn data modeling from an excel background (6:38)
Thinking in tables and columns (2:19)
Relationship types (4:47)
Difference between active and inactive relationships (3:41)
Getting the data model setup right (3:03)
Building out additional dimensions in your data (4:11)
How to use hierarchies (3:06)
DAX Calculations
DAX explained (1:20)
Best practice tips for naming conventions (2:55)
Calculated columns versus measures (4:03)
The key techniques to learning DAX (3:44)
Creating a measure table (4:19)
Context! (3:15)
Evaluation (initial) context (5:00)
Filter context (4:07)
Row context (7:12)
Types of DAX functions (1:11)
Aggregations (5:14)
Iterations (8:37)
Main table functions (17:15)
Start writing DAX functions! (6:41)
Building measures on measures (measure branching) (4:47)
CALCULATE function - the most important function in DAX (3:24)
Time Intelligence functions (18:57)
More advanced DAX formula examples (5:15)
What you can achieve if you learn DAX well (2:13)
Reports and Data Visualizations
Data visualization palette (1:49)
Analysis automation features (4:52)
How to use custom visuals (4:22)
Design best practice tips (5:59)
Dynamic visuals (8:18)
Dynamic visual titles (7:04)
Removing BLANKS() when zero values (2:40)
Visualization and report formatting (3:15)
Managing interactions between visuals (4:03)
In-built forecasting features (6:57)
Theme colours - use this tool (5:32)
Power BI Online Service
How to publish your data to the web (1:54)
Power BI service explained (2:52)
Using the 'Get Insights' feature (4:40)
Group workspaces explained (2:04)
Data alerts (4:04)
Reports vs Dashboards (4:16)
Why and when to use dashboards (5:42)
Content Packs (4:04)
Email Subscriptions (3:42)
Q+A feature in-depth (7:44)
Admin settings within the online service (4:13)
Various ways to distribute your analysis (6:23)
Tips for using Power BI within an organisation
Enterprise architecture recommendations for Power BI (5:20)
Developers & analysts vs consumer requirements (2:50)
Develop Power BI desktop templates to scale reporting requirements (3:45)
Data security overview (10:03)
Row level security (6:20)
The Power BI roadmap within the business application platform (5:47)
Why Power BI is going to be huge! (8:01)
Group workspaces explained
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock