Section 1 : Introduction to Course

Lecture 1 DAX Power Pivot Data Modelling in Excel E6 User Guide 5:35

Section 2 : Group Work 1 Creating the Data Model

Lecture 2 Importing External Data into the Power Pivot Data Model window 12:3
Lecture 3 Removing and Filtering Fields WHEN Importing Data 13:46
Lecture 4 Removing and Filtering Fields AFTER Importing Data 8:59
Lecture 5 Practice Ex1 Editing the Data Source 8:28
Lecture 6 Group Work 1 Recap of Objectives

Section 3 : Group Work 2 Creating Pivot Tables Relationships

Lecture 7 Adding a Pivot Table From the Data Model 12:4
Lecture 8 Hiding Tables ANDOR Fields From the Pivot Table Field List 7:12
Lecture 9 Practice Ex2 Pivot Tables Relationships 8:26
Lecture 10 Group Work 2 Recap of Objectives 3:7

Section 4 : Group Work 3 Adding Excel Data to the Data Model

Lecture 11 Group Work 3 Linking Excel Tables to the Data Model 11:4
Lecture 12 Group Work 3 Importing an Excel File into the Data Model 4:34
Lecture 13 Practice Ex3 Linked Tables 8:0
Lecture 14 Group Work 3 Recap of Objectives 3:8

Section 5 : Group Work 4 Creating a Hierarchy

Lecture 15 Group Work 4 Creating a Hierarchy 10:57
Lecture 16 Practice Ex4 Creating a Hierarchy
Lecture 17 Group Work 4 Recap of Objectives 1:39

Section 6 : Group Work 5 Calculated Columns Measures

Lecture 18 Group Work 5 Creating Calculated Columns in the Data Model 7:34
Lecture 19 Group Work 5 Creating Measures in the Data Model 8:51
Lecture 20 Group Work 5 Displaying Measure in Pivot Tables 6:21
Lecture 21 Practice Ex5 Calculated Columns Measures 8:4
Lecture 22 Group Work 5 Recap of Objectives 9:29

Section 7 : Group Work 6 Measures in Excel

Lecture 23 Group Work 6 Adding Measures in Excel 15:26
Lecture 24 Practice Ex6 Measures in Excel 8:9
Lecture 25 Group Work 6 Recap of Objectives 3:1

Section 8 : Group Work 7 RELATED() RELATEDTABLE()

Lecture 26 Group Work 7 RELATED() 7:42
Lecture 27 Group Work 7 RELATED() Part 2- 6:10
Lecture 28 Group Work 7 RELATEDTABLE() 9:22
Lecture 29 Practice Ex7 RELATED() RELATEDTABLE 12:44
Lecture 30 GW 7 Recap of Objectives 4:10

Section 9 : Group Work 8 COUNT() DISTINCTCOUNT()

Lecture 31 Group Work 8 Aggregator Function COUNT() 7:32
Lecture 32 Group Work 8 DISTINCTCOUNT() 7:50
Lecture 33 Group Work 8 Date Fields in Calculated Columns
Lecture 34 Practice Ex8 COUNT() DISTINCTCOUNT() DATE Fields 8:28
Lecture 35 Initial Filter Context Filter Propagation 11:1
Lecture 36 Group Work 8 Recap of Objectives 2:3

Section 10 : Group Work 9 CALCULATE()

Lecture 37 Group Work 9 CALCULATE() Part 1
Lecture 38 Group Work 9 CALCULATE() with AND OR 12:50
Lecture 39 Group Work 9 CALCULATE() with Comparison Operators 6:10
Lecture 40 Group Work 9 CALCULATE() with DATE () MONTH() 10:38
Lecture 41 Practice Ex9 CALCULATE() Month() DATE() 12:14
Lecture 42 Group Work 9 Recap of Objectives 3:47

Section 11 : Group Work 10 CALCULATE() with ALL()

Lecture 43 Group Work 10 CALCULATE() with ALL() 10:0
Lecture 44 Group Work 10 CALCULATE() with ALL() Pt2
Lecture 45 Practice Ex10 CALCULATE() 6:9
Lecture 46 Group Work 10 Recap of Objectives 2:14

Section 12 : Bonus Creating an Excel Calendar Table

Lecture 47 Creating an Excel Calendar Table Farewell 15:17