Section 1 : Introduction to Course
Lecture 1 DAX Power Pivot Data Modelling in Excel E6 User Guide 00:05:35 Duration

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

Section 3 : Group Work 2 Creating Pivot Tables Relationships
Lecture 1 Adding a Pivot Table From the Data Model 00:12:04 Duration
Lecture 2 Hiding Tables ANDOR Fields From the Pivot Table Field List 00:07:12 Duration
Lecture 3 Practice Ex2 Pivot Tables Relationships 00:08:26 Duration
Lecture 4 Group Work 2 Recap of Objectives 00:03:07 Duration

Section 4 : Group Work 3 Adding Excel Data to the Data Model
Lecture 1 Group Work 3 Linking Excel Tables to the Data Model 00:11:04 Duration
Lecture 2 Group Work 3 Importing an Excel File into the Data Model 00:04:34 Duration
Lecture 3 Practice Ex3 Linked Tables 00:08:00 Duration
Lecture 4 Group Work 3 Recap of Objectives 00:03:08 Duration

Section 5 : Group Work 4 Creating a Hierarchy
Lecture 1 Group Work 4 Creating a Hierarchy 00:10:57 Duration
Lecture 2 Practice Ex4 Creating a Hierarchy
Lecture 3 Group Work 4 Recap of Objectives 00:01:39 Duration

Section 6 : Group Work 5 Calculated Columns Measures
Lecture 1 Group Work 5 Creating Calculated Columns in the Data Model 00:07:34 Duration
Lecture 2 Group Work 5 Creating Measures in the Data Model 00:08:51 Duration
Lecture 3 Group Work 5 Displaying Measure in Pivot Tables 00:06:21 Duration
Lecture 4 Practice Ex5 Calculated Columns Measures 00:08:04 Duration
Lecture 5 Group Work 5 Recap of Objectives 00:09:29 Duration

Section 7 : Group Work 6 Measures in Excel
Lecture 1 Group Work 6 Adding Measures in Excel 00:15:26 Duration
Lecture 2 Practice Ex6 Measures in Excel 00:08:09 Duration
Lecture 3 Group Work 6 Recap of Objectives 00:03:01 Duration

Section 8 : Group Work 7 RELATED() RELATEDTABLE()
Lecture 1 Group Work 7 RELATED() 00:07:42 Duration
Lecture 2 Group Work 7 RELATED() Part 2- 00:06:10 Duration
Lecture 3 Group Work 7 RELATEDTABLE() 00:09:22 Duration
Lecture 4 Practice Ex7 RELATED() RELATEDTABLE 00:12:44 Duration
Lecture 5 GW 7 Recap of Objectives 00:04:10 Duration

Section 9 : Group Work 8 COUNT() DISTINCTCOUNT()
Lecture 1 Group Work 8 Aggregator Function COUNT() 00:07:32 Duration
Lecture 2 Group Work 8 DISTINCTCOUNT() 00:07:50 Duration
Lecture 3 Group Work 8 Date Fields in Calculated Columns
Lecture 4 Practice Ex8 COUNT() DISTINCTCOUNT() DATE Fields 00:08:28 Duration
Lecture 5 Initial Filter Context Filter Propagation 00:11:01 Duration
Lecture 6 Group Work 8 Recap of Objectives 00:02:03 Duration

Section 10 : Group Work 9 CALCULATE()
Lecture 1 Group Work 9 CALCULATE() Part 1
Lecture 2 Group Work 9 CALCULATE() with AND OR 00:12:50 Duration
Lecture 3 Group Work 9 CALCULATE() with Comparison Operators 00:06:10 Duration
Lecture 4 Group Work 9 CALCULATE() with DATE () MONTH() 00:10:38 Duration
Lecture 5 Practice Ex9 CALCULATE() Month() DATE() 00:12:14 Duration
Lecture 6 Group Work 9 Recap of Objectives 00:03:47 Duration

Section 11 : Group Work 10 CALCULATE() with ALL()
Lecture 1 Group Work 10 CALCULATE() with ALL() 00:10:00 Duration
Lecture 2 Group Work 10 CALCULATE() with ALL() Pt2
Lecture 3 Practice Ex10 CALCULATE() 00:06:09 Duration
Lecture 4 Group Work 10 Recap of Objectives 00:02:14 Duration

Section 12 : Bonus Creating an Excel Calendar Table
Lecture 1 Creating an Excel Calendar Table Farewell 00:15:17 Duration