Resources and Information
Loading Data
-
What is ETL (3:54)
-
What is Power Query (4:07)
-
Load from Excel Demo (26:58)
-
Load from Folder Demo (9:51)
-
Datasets vs Reports (2:43)
-
Connection Types (8:51)
-
|Challenge| Test my knowledge
-
Advanced Power Query (7:51)
-
Data Quality (4:05)
-
Profiling Data Demo (14:24)
-
Merging in Power Query Demo (17:08)
-
|Task| Load Data
Modelling Data
-
STAR Schema (6:34)
-
Facts and Dimensions (19:00)
-
Linking Tables with Keys (4:39)
-
Designing a STAR Schema (5:43)
-
Types of Dimensions (12:39)
-
Types of fact (3:36)
-
Fact Grain (7:24)
-
Making a STAR Schema (5:02)
-
Create a STAR Schema Demo (15:34)
-
Relationships in Power BI (12:19)
-
Making Relationships Demo (7:36)
-
Tidying Data Models Demo (11:10)
-
|Task| Transform Data
Theory of DAX
-
What is DAX (11:22)
-
Writing DAX Demo (16:49)
-
The CALCULATE Statement (6:21)
-
Introduction to Expanded Tables (3:43)
-
What is Filter Context (8:05)
-
What is Row Context (4:33)
-
Iterators (9:22)
-
Putting Context Together (5:10)
-
Visual Level Filters (12:36)
-
Remove Filters (4:58)
-
Refresh Process (3:57)
-
Many to Many relationships (3:28)
-
Snowflake Schema (9:12)
-
Calculate Revisited (5:49)
-
Context Transition (12:50)
-
Implicit vs Explicit DAX
Writing DAX
-
CALCULATE Demo (11:37)
-
Aggregation Functions (15:50)
-
SELECTEDVALUE (3:55)
-
Informational functions (16:26)
-
Logical functions (24:40)
-
Time intelligence Functions (22:29)
-
Advanced Calculate (15:13)
-
Multiple FACTs (11:37)
-
Role Playing Dimensions (15:20)
-
|Challenge| DAX Quiz
-
|Task| DAX Table
-
|Task| DAX Measures
Power BI Desktop
-
Checking the Version (1:03)
-
Preview Features (2:52)
-
Adding Visuals (11:12)
-
Formatting Visuals (18:59)
-
Further Analysis on Visuals (4:29)
-
Adding Filters (16:56)
-
Format a Page (9:48)
-
Layout a Page (14:51)
-
Conditional Formatting (13:03)
-
Hierarchies (17:29)
-
Create a Date Heirarchy (5:58)
-
Drillthroughs (11:14)
-
Tooltips (7:03)
-
Panes (8:42)
-
Bookmarks (14:23)
-
Bookmark tips
-
Buttons (8:08)
-
Button Navigators (9:09)
-
Custom visuals (9:58)
-
Mobile View (3:20)
Creating Reports
Deploying Content
Microsoft Fabric
