Section 1 : Introduction

Lecture 1 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM

Section 2 : Getting Started

Lecture 1 Important Versions and compatibility 00:03:15 Duration
Lecture 2 Set expectations 00:01:46 Duration

Section 3 : Power Pivot and DAX 101

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

Section 4 : Common DAX Functions

Lecture 1 Introduction to DAX functions 00:00:27 Duration
Lecture 2 DAX formula syntax and operators 00:04:05 Duration
Lecture 3 Common DAX function categories 00:03:54 Duration
Lecture 4 Basic math and stats functions 00:12:45 Duration
Lecture 5 COUNT, COUNTA, DISTINCTCOUNT, and COUNTROWS
Lecture 6 Logical Functions (IF, AND, and OR) 00:16:49 Duration
Lecture 7 Switch and Switch (TRUE)
Lecture 8 Text functions 00:10:53 Duration
Lecture 9 The CALCULATE function 00:14:39 Duration
Lecture 10 Add filter context with FILTER Part 1 00:09:20 Duration
Lecture 11 Add filter context with FILTER Part 2 00:14:23 Duration
Lecture 12 Remove filter context with ALL 00:09:06 Duration
Lecture 13 Join data with RELATED 00:03:39 Duration
Lecture 14 Iterator (X) functions SUMX 00:12:20 Duration
Lecture 15 Iterator (X) functions RANKX 00:05:33 Duration
Lecture 16 Basic date and time functions 00:04:58 Duration
Lecture 17 Time intelligence formulas 00:17:02 Duration
Lecture 18 Speed and performance considerations
Lecture 19 DAX best practices

Section 5 : Conclusion

Lecture 1 Final section 00:00:53 Duration
Lecture 2 Data visualization options 00:04:24 Duration