Lesson 4 of 22
DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis)
Lessons22 lessons
- 1DAME 01: Data Analysis Terms & the Awesome Microsoft Power Tools!
- 2DAME 2 (Updated): MS Data Analysis Tools: Excel, Power Query, Power BI, Data Flow, DAX & M Code!
- 3DAME 03: PivotTables Rule for Quick & Easy Reports! 34 Amazing PT Tricks.
- 4DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis)
- 5DAME 06: DAX Fundamentals in Power BI & Power Pivot: 2.5 Hour Free Class
- 6DAME 04: Data Analysis with Excel Worksheet Formulas: 4 Comprehensive examples.
- 7DAME 07: How to Make Effective Dashboard. Three Examples in Power BI
- 8MSPTDA 22: DAX Data Modeling to Create Date & Time Dimension Tables, Server Downtime Visualizations
- 9MSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database Size
- 10MSPTDA 23: Two Fact Tables? DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table
- 11MSPTDA 24: DAX Multiply / Divide Data Types Discrepancies Solved!
- 12MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH
- 13MSPTDA 26: Budget vs Actual in Power Pivot & Power BI Desktop, DAX & Data Model
- 14MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships
- 15MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship
- 16MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas
- 17MSPTDA 30: Order & Ship Dates in Fact Table: DAX Formulas and Data Modeling to Create Reports
- 18MSPTDA 32: Slowly Changing Dimensions Team-Employee Report with Worksheet Formulas
- 19MSPTDA 33: Data Modeling for Slowly Changing Dimensions with Power Query & PivotTable
- 20MSPTDA 33 Part 2: Power Query & Standard PivotTable To Show All Employees Sales Or Not
- 21MSPTDA 34: Data Modeling for Slowly Changing Dimensions with Power Query & Power Pivot
- 22MSPTDA 35: Power BI & DAX Formula for Data Modeling with a Slowly Changing Dimensions