Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week01a02/Video01-02Files.zip
Pdf notes to read online: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week01a02/01-DAMEMPT.pdf
Alternative link for zipped folder: https://excelisfun.net/files/Video01-02Files.zip
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about ALL the Microsoft Power Tools: Excel, Power Query, Power Pivot, Data Model, Power BI, Dataflow, Worksheet formulas, Dynamic Spilled Array Formulas, M Code formulas, DAX formulas, and much more!
Topics:
1. (00:00) Introduction
2. (00:13) List of MS Power Tools taught in video
3. (00:44) Preview of 7 examples
4. (01:48) Why use Worksheet as a data analysis solution?
5. (03:09) #1 Worksheet Formula solutions: XLOOKUP to do data modeling , PivotTables, dynamic spilled array formulas, and the GROUPBY and PIVOTBY functions
6. (22:41) #2: Power Query to import data (.txt & .xlsx), transform the data create a report.
7. (34:49) #3: Use Power Query to load a table to the PivotTable Cache.
8. (41:07) Fix broken On Premises File Path: Data Source Settings.
9. (43:02) #4: Json data, Power Pivot, Data Model, DAX formulas, Row Context and Filter Context for creating Data Model PivotTable Reports.
10. (01:09:12) #5 Xml data, Power BI Desktop, Data Model, DAX formulas and Interactive Visuals. Visualization tips too.
11. (01:33:58) #6 Power BI Online Services
12. (01:38:57) #7 Dataflow (Online Power Query)
13. (01:45:25) Summary
14. (01:45:55) Conclusion