Section 1 : Introduction

Lecture 1 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
Lecture 2 What you should know 0:28
Lecture 3 Using the exercise files 1:4
Lecture 4 Our project Creating an advanced Power BI dashboard 0:44

Section 2 : How the Power BI Platform Works

Lecture 5 Understanding the Microsoft update process and Power BI Desktop vs 1:21
Lecture 6 Comparing Power BI to Tableau 2:15

Section 3 : Working with Data

Lecture 7 Employing efficient data strategies 2:26
Lecture 8 Importing and transferring data imported from an Excel, CSV, or TXT file 1:26
Lecture 9 Importing online data sources 2:0
Lecture 10 Uploading from a folder of data 4:17
Lecture 11 Querying a database 1:18
Lecture 12 Uploading a PDF 2:13

Section 4 : Query Editor

Lecture 13 Introducing Query Editor steps 3:1
Lecture 14 Transposing data tables 2:14
Lecture 15 Unpivoting data 3:44
Lecture 16 Appending data 2:13
Lecture 17 Splitting fields and columns 3:5
Lecture 18 Formatting data with text formulas 2:34
Lecture 19 Creating conditional formulas 3:32
Lecture 20 Filling up or filling down functionality 1:23
Lecture 21 Creating calculated formulas 4:7
Lecture 22 Introducing the M language 3:28
Lecture 23 Joining data tables

Section 5 : DAX Language

Lecture 24 Introducing DAX 1:54
Lecture 25 Introducing DAX measures 2:35
Lecture 26 Understanding DAX measure logic 3:12
Lecture 27 Evaluating DAX measures
Lecture 28 Leveraging the CALCULATE functionality 5:48
Lecture 29 Understand how filters work in CALCULATE function 12:10
Lecture 30 Leveraging the ALL function 4:57
Lecture 31 Understanding the FILTER functionality 6:40

Section 6 : Introduction to DAX Formulas

Lecture 32 Creating a separate table for measures 3:58
Lecture 33 Creating a table using GENERATESERIES formula 3:24
Lecture 34 Leveraging the POWER function 5:9
Lecture 35 Leveraging the DIVIDE function 5:9
Lecture 36 Introducing parameter-harvesting functions 8:9
Lecture 37 Introducing the X-factor functions 5:12
Lecture 38 Utilizing the X factor (SUMX, COUNTX, etc 5:38
Lecture 39 Utilizing quick measures 2:57

Section 7 : Advanced DAX Calculations

Lecture 40 Creating a date table using a formula 2:41
Lecture 41 Filtering between tables 4:47
Lecture 42 Utilizing IF statements with conditional functions 6:25
Lecture 43 Creating dynamic measures 4:38
Lecture 44 Introducing the DATEDIFF measure 2:24
Lecture 45 Working with disconnected tables
Lecture 46 Leveraging the BLANK function 4:54
Lecture 47 Using variables in formulas 13:41
Lecture 48 DATESBETWEEN and the X functions
Lecture 49 Introducing the DATEADD date calculations 2:46
Lecture 50 Introducing the MTD, QTD, and YTD date calculations 3:7

Section 8 : Graphing and Dashboard Design

Lecture 51 Leveraging chart design
Lecture 52 Sharing your work with others 1:9

Section 9 : Conclusion

Lecture 53 Next steps 0:25