Скачать или смотреть MS 365 Excel Basics 11: Power Pivot, Data Model, Relationships & DAX Measures, & Filter Context Too!

Download Excel Zipped Folder with all files (including pdf notes): https://excelisfun.net/files/MECS04Do...
Free YouTube Excel & Data Analysis class:    • Excel 365 Basics Free Course: Learn to Eff...  
The Only App That Matters book by Mike Girvin at Amazon: https://www.amazon.com/stores/Mike-ex...
In this video learn about the Excel Tool Power Pivot to build reports and visuals.
Topics:
1. (00:00) Introduction
2. (00:45) Enable 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: HW(4)
20. (39:15) Closing

Using the gear icon setting button below the video, you can watch subtitles in these languages: Afrikaans, Arabic, Bengali (some videos), Bangla, Dutch, Filipino, French, Hindi, Indonesian, Khmer, Malay, Malayalam, Nepali, Persian, Polish, Spanish, Swahili, Tamil, Telugu, Thai, Tibetan, Urdu, Vietnamese.
Using the gear icon setting button below the video, you can listen to an audio track in these translated languages: French, German, Hindi, Indonesian, Italian, Japanese, Portuguese, and Spanish.

#excel #excelisfun #groupby #dataanalysis #Sort #powerpivot #dax #datamodeling #datamodelling #datamodel #dataanalysis #


#excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions