Section 1 : Introduction

Lecture 1 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf

Section 2 : Getting Started

Lecture 2 Important Versions and compatibility 3:15
Lecture 3 Set expectations 1:46

Section 3 : Power Pivot and DAX 101

Lecture 4 Introduction to Power Pivot and DAX 0:29
Lecture 5 Create a Power Pivot table 5:27
Lecture 6 Power Pivots versus normal pivots 2:48
Lecture 7 Introduction to Data Analysis Expressions (DAX) 1:12
Lecture 8 Calculated columns 8:39
Lecture 9 DAX measures 2:24
Lecture 10 Create implicit measures
Lecture 11 Create explicit measures (AutoSum) 7:8
Lecture 12 Create explicit measures (Power Pivot) 7:42
Lecture 13 Understand filter context 9:18
Lecture 14 Step-by-step measure calculation 12:6
Lecture 15 Recap Calculated columns versus measures 2:29
Lecture 16 Power Pivot best practices 1:48

Section 4 : Common DAX Functions

Lecture 17 Introduction to DAX functions 0:27
Lecture 18 DAX formula syntax and operators 4:5
Lecture 19 Common DAX function categories 3:54
Lecture 20 Basic math and stats functions 12:45
Lecture 21 COUNT, COUNTA, DISTINCTCOUNT, and COUNTROWS
Lecture 22 Logical Functions (IF, AND, and OR) 16:49
Lecture 23 Switch and Switch (TRUE)
Lecture 24 Text functions 10:53
Lecture 25 The CALCULATE function 14:39
Lecture 26 Add filter context with FILTER Part 1 9:20
Lecture 27 Add filter context with FILTER Part 2 14:23
Lecture 28 Remove filter context with ALL 9:6
Lecture 29 Join data with RELATED 3:39
Lecture 30 Iterator (X) functions SUMX 12:20
Lecture 31 Iterator (X) functions RANKX 5:33
Lecture 32 Basic date and time functions 4:58
Lecture 33 Time intelligence formulas 17:2
Lecture 34 Speed and performance considerations
Lecture 35 DAX best practices

Section 5 : Conclusion

Lecture 36 Final section 0:53
Lecture 37 Data visualization options 4:24