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 on Microsoft's data analysis tools, including Excel, Power Query, Power BI, Data Flow, DAX, and M Code. Learn from Excel MVP and Highline College Professor Mike Girvin as he guides you through seven practical examples. Explore worksheet formulas, dynamic spilled array functions, data modeling techniques, and PivotTables. Master Power Query for data import and transformation, understand DAX formulas in Power Pivot and Power BI Desktop, and discover the capabilities of Power BI Online Services and Dataflow. Gain valuable insights into handling various data formats, creating interactive visuals, and optimizing your data analysis workflow using Microsoft's powerful suite of tools.

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