Section 1 : Getting Started

Lecture 1 Course Structure & Outline 1:30
Lecture 2 IMPORTANT Versions & Compatibility 3:16
Lecture 3 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
Lecture 4 Introducing the Course Project 1:16
Lecture 5 DOWNLOAD Course Resources Text
Lecture 6 Setting Expectations 1:54

Section 2 : Intro to “Power Excel

Lecture 7 Understanding the “Power Excel” Workflow 3:50
Lecture 8 Power Query + Power Pivot Best Thing to Happen to Excel in 20 Years 8:18
Lecture 9 When to use Power Query & Power Pivot 0:45
Lecture 10 HOMEWORK Intro to Power Excel Text

Section 3 : Connecting & Transforming Data with Power Query in Excel

Lecture 11 Introduction 0:27
Lecture 12 Getting to Know Power Query in Excel 2:41
Lecture 13 Exploring Excel's Power Query Editor 3:17
Lecture 14 Power Query Data Loading Options 1:40
Lecture 15 IMPORTANT Updating Locale Settings
Lecture 16 Applying Basic Table Transformations with Power Query 8:6
Lecture 17 Power Query Demo Text Tools 10:18
Lecture 18 Power Query Demo Number & Value Tools 7:42
Lecture 19 Power Query Demo Date & Time Tools
Lecture 20 PRO TIP Creating a Rolling Calendar with Power Query 5:2
Lecture 21 Power Query Demo Generating Index & Conditional Columns 7:44
Lecture 22 Power Query Demo Grouping & Aggregating Records 7:10
Lecture 23 Power Query Demo Pivoting & Unpivoting Data 8:53
Lecture 24 Modifying Excel Workbook Queries 4:18
Lecture 25 Merging Queries with Power Query 7:43
Lecture 26 Appending Queries with Power Query 5:49
Lecture 27 Power Query Demo Connecting to a Folder of Files 9:33
Lecture 28 Excel Power Query Best Practices 2:44
Lecture 29 HOMEWORK Connecting & Transforming Data with Power Query in Excel Text

Section 4 : Building Table Relationships with Excel's Data Model

Lecture 30 Introduction 0:29
Lecture 31 Meet Excel's Data Model 3:38
Lecture 32 The Data Model Data vs
Lecture 33 Principles of Database Normalization 4:15
Lecture 34 Understanding Data Tables vs 5:40
Lecture 35 Benefits of Relationships vs 2:8
Lecture 36 Creating Table Relationships in Excel's Data Model 6:55
Lecture 37 Modifying Data Model Table Relationships 2:7
Lecture 38 Managing Active vs 3:55
Lecture 39 Understanding Relationship Cardinality 5:46
Lecture 40 Connecting Multiple Data Tables in the Data Model 5:59
Lecture 41 Understanding Filter Flow 5:8
Lecture 42 Hiding Fields from Excel Client Tools 5:0
Lecture 43 Defining Hierarchies in a Data Model 3:54
Lecture 44 Excel Data Model Best Practices 1:38
Lecture 45 HOMEWORK Building Table Relationships with Excel's Data Model Text

Section 5 : Analyzing Data with Power Pivot & DAX

Lecture 46 Introduction 0:29
Lecture 47 Creating a Power Pivot Table 5:27
Lecture 48 Power Pivots vs 2:49
Lecture 49 Introducing Data Analysis Expressions (DAX) 1:12
Lecture 50 Understanding DAX Calculated Columns 8:39
Lecture 51 Understanding DAX Measures 2:24
Lecture 52 Creating Implicit DAX Measures 2:0
Lecture 53 Creating Explicit DAX Measures with AutoSum
Lecture 54 Creating Explicit DAX Measures with Power Pivot 7:42
Lecture 55 Understanding DAX Filter Context 9:18
Lecture 56 Step-by-Step DAX Measure Calculation 12:7
Lecture 57 RECAP Calculated Columns vs 2:29
Lecture 58 Excel Power Pivot & DAX Best Practices 1:51
Lecture 59 HOMEWORK Analyzing Data with Power Pivot & DAX Text

Section 6 : Common DAX Formulas & Functions

Lecture 60 Introduction 0:28
Lecture 61 Understanding DAX Formula Syntax & Operators 4:5
Lecture 62 Common DAX Function Categories
Lecture 63 DAX Demo Basic Math & Stats Functions 12:46
Lecture 64 DAX Demo COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS 10:36
Lecture 65 HOMEWORK Math & Stats Functions Text
Lecture 66 DAX Demo Logical Functions (IFANDOR) 16:49
Lecture 67 DAX Demo SWITCH & SWITCH(TRUE) 10:33
Lecture 68 DAX Demo Common Text Functions 10:54
Lecture 69 HOMEWORK Logical & Text Functions Text
Lecture 70 DAX Demo CALCULATE 14:39
Lecture 71 DAX Demo Adding Filter Context with FILTER (Part 1) 9:20
Lecture 72 DAX Demo Adding Filter Context with FILTER (Part 2) 14:24
Lecture 73 DAX Demo Removing Filter Context with ALL 9:6
Lecture 74 HOMEWORK CALCULATE, FILTER & ALL Text
Lecture 75 DAX Demo Joining Data with RELATED 3:39
Lecture 76 DAX Demo Iterating with SUMX 12:21
Lecture 77 DAX Demo Iterating with RANKX 5:33
Lecture 78 HOMEWORK Iterator (X) Functions Text
Lecture 79 DAX Demo Basic Date & Time Functions 4:59
Lecture 80 DAX Demo Time Intelligence Formulas 17:2
Lecture 81 HOMEWORK Time Intelligence Text
Lecture 82 DAX Speed & Performance Considerations 3:3
Lecture 83 DAX Best Practices 2:3

Section 7 : Wrapping Up

Lecture 84 Introduction 0:53
Lecture 85 Data Visualization Options in Excel
Lecture 86 Sneak Peek Microsoft Power BI 5:56