#### 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