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://people.highline.edu/mgirvin/AllClasses/218M365/Content/MECS04DownloadFiles.zip Free YouTube Excel & Data Analysis class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo The Only App That Matters book by Mike Girvin at Amazon: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ccs_id=70eb6de0-afb4-4979-a9a7-a1bdc0089ad3 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