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
MS 365 Excel Basics 12: Power BI Desktop & Interactive Visuals / Dashboards, Import Excel Data Model
Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)
Data Models, PivotTables, and Power Query in Excel
How to use Power Pivot in Excel | Full Tutorial
Master Power Query in Excel – Complete Tutorial Beginner to Advanced
MS 365 Excel Basics #13: Power BI Dashboard from 7 Million Rows of SQL Data and DAX Formulas
Learn to Automate Everything with Power Query in Excel (Download Files)
How to Model and Analyze Data in EXCEL using POWER PIVOT
Try The DGET Function Instead of INDEXMATCH & XLOOKUP
How and where to write DAX Measures for Power BI and Excel
The Ultimate LOOKUP Guide (XLOOKUP, VLOOKUP, HLOOKUP and more)
13 Mind Blowing Power Query Features to Automate Your Excel Work (Beginners Tutorial Part II)
Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)
Power Query was HARD until I learned these 7 Tips
You Don't Need VLOOKUP & XLOOKUP, You Need This | Excel
Stop Sending Ugly Pivot Tables to Your Boss
Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)
Python in Excel: The Smarter Way to Use External Data
Intermediate Excel Skills, Tips, and Tricks Tutorial
