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