Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Power BI DAX
Case Study
Download Practice files
INTRODUCTION TO DATA MODELLING
An Introduction to Data Modelling mindset – Think in multiple tables (5:16)
Primary Key in Tables and Foreign Key in Tables (5:03)
Normalization of Datasets (5:03)
First Normal Form – single value and not repeating groups – Rule 1 (5:16)
Second Normal Form – composite primary key – Rule 2 (6:19)
Third Normal Form – dependency between non-key fields – Rule 3 (5:37)
Normalization of dummy Datasets using normalization rules (13:13)
Quick Recap – Three important Normalisation rules (3:01)
Differences in the Table types – Data / Fact table and Lookup / Dimension Table (5:58)
An Introduction to Relationship Cardinality (1:50)
Define ‘One to Many relationship’ (2:48)
Define ‘Many to Many relationship’ (2:22)
Define ‘One to One relationship’ (1:45)
Quick Recap –Relationship cardinality (1:46)
Differences in the Relationship in Power BI – Active / In-active, one / both way filter propagation (14:50)
Introducing Diagram view: Top Down, Star Schema, Snow Flakes – managing table presentation (5:49)
DATA PREPARATION FOR DASHBOARD
Differences in Table view, Rename, Hide / Delete in the Tables related options (5:47)
Differences between – Width, Rename, Sort / Sort by, Hide / Delete, Filters, Groups for the Columns related (17:38)
Power BI Desktop – Valid Data Types (4:27)
Column Data Formatting (5:38)
Power BI Desktop – Data categorizing (2:49)
Power BI Desktop – Applying default summarization to a column (3:42)
Marking table as Date Table inside Power BI Desktop and why is it required (2:46)
POWER BI DESKTOP – DAX FUNDAMENTALS
DAX language fundamentals- Introduction (3:02)
Difference between Data Types, DAX Operators and DAX Syntax (9:44)
Difference in DAX Functions list by categories – Table and Scalar values (6:41)
Define Calculated Columns (9:38)
Define Calculated Measures (13:59)
Define Calculated Columns vs Measure (3:19)
Difference Filter Context and Row Context (11:36)
What are the Golden rules of Measures and other important things? (8:29)
POWER BI – BASIC DAX FUNCTION EXAMPLES
Common DAX functions – Introduction (2:06)
Difference in Related and Related Table function (6:48)
Difference in Date and Time functions (8:13)
DAX functions and Operators – Fundamental Math Operation (12:11)
Power BI – Numbers Round off (6:11)
Define Statistical DAX Functions (5:43)
What is DISTINCTCOUNT function in DAX to count unique customers, etc. (7:13)
What is Text function (5:16)
SWITCH function / nested IF functions – Best alternative (6:29)
INTRODUCTION TO CALCULATE – BOSS OF DAX FUNCTIONS
Introduction to CALCULATE (4:56)
Introduction to CALCULATE syntax (6:41)
CALCULATE function – Examples (6:17)
FILTER function – Syntax introduction, Usage and Working (7:03)
FILTER function inside CALCULATE function – Case Study (6:37)
How to Context Transition using CALCULATE and FILTER function (7:08)
Case study – ALL and ALLEXCEPT function – single table (11:30)
Case study – ALL and ALLEXCEPT function – multiple tables (3:31)
How to remove filter context and keep selected filter context – ALLSELECTED function (7:08)
What are the Differences and Similarities in CALCULATE, FILTER, ALL functions (7:54)
Download Practice files
Download
AW Returns.xlsx
Download
De-normalised datasets - Final.xlsx
Download
Adventure Works Database - New.xlsx
Download
Row Context.xlsx
Download
Import Excel Data Models.xlsx
Complete and Continue