This 39-minute tutorial from ExcelIsFun explores Power Pivot functionality in MS 365 Excel, teaching how to build effective reports and visuals using data models. Learn to enable Power Pivot, understand its purpose, import data using Power Query, create relationships between tables, and develop DAX measures using functions like SUM, AVERAGE, and COUNTROWS. Master creating multiple PivotTables from a single data model, understand filter context for DAX measures, recognize the dangers of implicit measures and automatic date grouping, and discover the advantages of data model PivotTables. Downloadable practice files are available, and the video includes subtitles in multiple languages and translated audio tracks in several languages. The tutorial concludes with a practice problem and a preview of Power BI Desktop covered in the next video.
Excel Basics - Power Pivot, Data Model, Relationships, DAX Measures, and Filter Context - Lesson 11
ExcelIsFun via YouTube
Overview
Syllabus
1. 00:00 Introduction
2. 00:45 Emable Power Pivot in Excel
3. 01:51 What is Power Pivot?
4. 03:01 Understanding the data that we use in this example
5. 04:55 Visual to help understand Relationships
6. 06:01 Power Query to import data into Power Pivot Data Model
7. 12:44 Data Modeling: Add Relationships
8. 14:48 Data Modeling: Hide Fields
9. 16:20 Data Modeling: Create DAX Measures. See the DAV Functions: SUM, AVERAGE and COUNTROWS
10. 22:00 Finished Data Model
11. 23:06 Create Multiple Data Model PivotTables from the Data Model
12. 27:34 Sort By Column Feature for Data Field in Data Table
13. 29:13 Filter Context: How DAX Measures work
14. 33:52 Implicit Measures and Automatic Date Grouping: Dangers of Data Models
15. 36:01 Show Implicit Measures
16. 37:35 Mark Table as Data Table
17. 38:24 Advantages of Data Model PivotTables
18. 38:57 Preview of next video: Excel Basics 12: Power BI Desktop
19. 38:26 Practice Problem on the worksheet: HW4
20. 39:15 Closing
Taught by
ExcelIsFun
