Microsoft Data Analysis Tools: Excel, Power Query, Power BI, Dataflow, DAX, and M Code

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Dive into a comprehensive video tutorial covering all Microsoft data analysis tools, including Excel, Power Query, Power BI, Data Flow, DAX, and M Code. Learn to leverage worksheet formulas, dynamic spilled array functions, and PivotTables for data modeling. Explore Power Query for data import and transformation, create reports using Power Pivot and DAX formulas, and master interactive visualizations in Power BI Desktop. Gain insights into Power BI Online Services and Dataflow for advanced data analysis. Perfect for aspiring data analysts and professionals looking to enhance their skills across the Microsoft data analysis ecosystem.

Syllabus

1. Introduction
2. List of MS Power Tools taught in video
3. Preview of 7 examples
4. Why use Worksheet as a data analysis solution?
5. #1 Worksheet Formula solutions: XLOOKUP to do data modeling , PivotTables, dynamic spilled array formulas, and the GROUPBY and PIVOTBY functions
6. #2: Power Query to import data .txt & .xlsx, transform the data create a report.
7. #3: Use Power Query to load a table to the PivotTable Cache.
8. Fix broken On Premises File Path: Data Source Settings.
9. #4: Json data, Power Pivot, Data Model, DAX formulas, Row Context and Filter Context for creating Data Model PivotTable Reports.
10. #5 Xml data, Power BI Desktop, Data Model, DAX formulas and Interactive Visuals. Visualization tips too.
11. #6 Power BI Online Services
12. #7 Dataflow Online Power Query
13. Summary
14. Conclusion