The CALCULATE Statement | Training.tips

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Power BI: Masterclass

Resources and Information

Prerequisites
Tasks Data

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

Choosing a Visual (9:46)
Effective Visualization (14:56)
Designing a Report (1:50)
Audience (3:56)
Report Type (4:22)
Report Style (3:05)
The Report Design Process (5:53)
Examples (8:42)
|Task| Update your DAX Measures
|Task| Create a report page
|Task| Add a second page
|Task| Format your page

Deploying Content

Create a workspace (5:38)
Publish a Report (3:34)
Explore a Semantic Model (13:50)
Semantic Model Settings (14:48)
Reusing Semantic Model (9:48)
Creating Apps (9:48)
Sharing Workspaces (3:52)
Sharing Semantic Models (4:36)
Sharing Reports (5:41)
Sharing Best Practices (3:24)
Large datasets (10:19)

Microsoft Fabric

Data Lakehouse (14:47)
Column Store (13:20)
Parquet (2:46)
Delta (6:42)
Optimizing Delta (6:42)
Microsoft Fabric (5:55)
OneLake (3:04)
Direct Lake (7:57)
Direct Lake Refresh (3:27)

Teach online with

The CALCULATE Statement

Complete and Continue