Completed
1. 00:00 Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Basics - Power Pivot, Data Model, Relationships, DAX Measures, and Filter Context - Lesson 11
Automatically move to the next video in the Classroom when playback concludes
- 1 1. 00:00 Introduction
- 2 2. 00:45 Emable Power Pivot in Excel
- 3 3. 01:51 What is Power Pivot?
- 4 4. 03:01 Understanding the data that we use in this example
- 5 5. 04:55 Visual to help understand Relationships
- 6 6. 06:01 Power Query to import data into Power Pivot Data Model
- 7 7. 12:44 Data Modeling: Add Relationships
- 8 8. 14:48 Data Modeling: Hide Fields
- 9 9. 16:20 Data Modeling: Create DAX Measures. See the DAV Functions: SUM, AVERAGE and COUNTROWS
- 10 10. 22:00 Finished Data Model
- 11 11. 23:06 Create Multiple Data Model PivotTables from the Data Model
- 12 12. 27:34 Sort By Column Feature for Data Field in Data Table
- 13 13. 29:13 Filter Context: How DAX Measures work
- 14 14. 33:52 Implicit Measures and Automatic Date Grouping: Dangers of Data Models
- 15 15. 36:01 Show Implicit Measures
- 16 16. 37:35 Mark Table as Data Table
- 17 17. 38:24 Advantages of Data Model PivotTables
- 18 18. 38:57 Preview of next video: Excel Basics 12: Power BI Desktop
- 19 19. 38:26 Practice Problem on the worksheet: HW4
- 20 20. 39:15 Closing
