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

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

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.