Section 1 : Getting Started

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

Section 2 : Intro to “Power Excel

Lecture 1 Understanding the “Power Excel” Workflow 00:03:50 Duration
Lecture 2 Power Query + Power Pivot Best Thing to Happen to Excel in 20 Years 00:08:18 Duration
Lecture 3 When to use Power Query & Power Pivot 00:00:45 Duration
Lecture 4 HOMEWORK Intro to Power Excel

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

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

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

Lecture 1 Introduction 00:00:29 Duration
Lecture 2 Meet Excel's Data Model 00:03:38 Duration
Lecture 3 The Data Model Data vs
Lecture 4 Principles of Database Normalization 00:04:15 Duration
Lecture 5 Understanding Data Tables vs 00:05:40 Duration
Lecture 6 Benefits of Relationships vs 00:02:08 Duration
Lecture 7 Creating Table Relationships in Excel's Data Model 00:06:55 Duration
Lecture 8 Modifying Data Model Table Relationships 00:02:07 Duration
Lecture 9 Managing Active vs 00:03:55 Duration
Lecture 10 Understanding Relationship Cardinality 00:05:46 Duration
Lecture 11 Connecting Multiple Data Tables in the Data Model 00:05:59 Duration
Lecture 12 Understanding Filter Flow 00:05:08 Duration
Lecture 13 Hiding Fields from Excel Client Tools 00:05:00 Duration
Lecture 14 Defining Hierarchies in a Data Model 00:03:54 Duration
Lecture 15 Excel Data Model Best Practices 00:01:38 Duration
Lecture 16 HOMEWORK Building Table Relationships with Excel's Data Model

Section 5 : Analyzing Data with Power Pivot & DAX

Lecture 1 Introduction 00:00:29 Duration
Lecture 2 Creating a Power Pivot Table 00:05:27 Duration
Lecture 3 Power Pivots vs 00:02:49 Duration
Lecture 4 Introducing Data Analysis Expressions (DAX) 00:01:12 Duration
Lecture 5 Understanding DAX Calculated Columns 00:08:39 Duration
Lecture 6 Understanding DAX Measures 00:02:24 Duration
Lecture 7 Creating Implicit DAX Measures 00:02:00 Duration
Lecture 8 Creating Explicit DAX Measures with AutoSum
Lecture 9 Creating Explicit DAX Measures with Power Pivot 00:07:42 Duration
Lecture 10 Understanding DAX Filter Context 00:09:18 Duration
Lecture 11 Step-by-Step DAX Measure Calculation 00:12:07 Duration
Lecture 12 RECAP Calculated Columns vs 00:02:29 Duration
Lecture 13 Excel Power Pivot & DAX Best Practices 00:01:51 Duration
Lecture 14 HOMEWORK Analyzing Data with Power Pivot & DAX

Section 6 : Common DAX Formulas & Functions

Lecture 1 Introduction 00:00:28 Duration
Lecture 2 Understanding DAX Formula Syntax & Operators 00:04:05 Duration
Lecture 3 Common DAX Function Categories
Lecture 4 DAX Demo Basic Math & Stats Functions 00:12:46 Duration
Lecture 5 DAX Demo COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS 00:10:36 Duration
Lecture 6 HOMEWORK Math & Stats Functions
Lecture 7 DAX Demo Logical Functions (IFANDOR) 00:16:49 Duration
Lecture 8 DAX Demo SWITCH & SWITCH(TRUE) 00:10:33 Duration
Lecture 9 DAX Demo Common Text Functions 00:10:54 Duration
Lecture 10 HOMEWORK Logical & Text Functions
Lecture 11 DAX Demo CALCULATE 00:14:39 Duration
Lecture 12 DAX Demo Adding Filter Context with FILTER (Part 1) 00:09:20 Duration
Lecture 13 DAX Demo Adding Filter Context with FILTER (Part 2) 00:14:24 Duration
Lecture 14 DAX Demo Removing Filter Context with ALL 00:09:06 Duration
Lecture 15 HOMEWORK CALCULATE, FILTER & ALL
Lecture 16 DAX Demo Joining Data with RELATED 00:03:39 Duration
Lecture 17 DAX Demo Iterating with SUMX 00:12:21 Duration
Lecture 18 DAX Demo Iterating with RANKX 00:05:33 Duration
Lecture 19 HOMEWORK Iterator (X) Functions
Lecture 20 DAX Demo Basic Date & Time Functions 00:04:59 Duration
Lecture 21 DAX Demo Time Intelligence Formulas 00:17:02 Duration
Lecture 22 HOMEWORK Time Intelligence
Lecture 23 DAX Speed & Performance Considerations 00:03:03 Duration
Lecture 24 DAX Best Practices 00:02:03 Duration

Section 7 : Wrapping Up

Lecture 1 Introduction 00:00:53 Duration
Lecture 2 Data Visualization Options in Excel
Lecture 3 Sneak Peek Microsoft Power BI 00:05:56 Duration