BI 348: Data Analysis with Microsoft Power Tools:  

PivotTables, Power Query, M Code Formulas, Power Pivot Data Model, DAX Formulas, Power BI

Weeks 1 -2
Video link:  Visualizing Data and Building Dashboards in Excel & Power BI - 365 MECS 11   (1 hour 42  mins)
Download zipped folder with all files for this video: 11-M365ExcelClassVideoFiles.zip
Click to view pdf notes:  11-M365ExcelClass.pdf  (pdf also in zipped folder)
Project 1: Project01
Project 1 Source Files: Project01SourceFiles.zip

 

Weeks 3-4
Video link:  M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12   (1 hour 42  mins)
Download zipped folder with all files for this video: 12-M365ExcelClassVideoFiles.zip
Click to view pdf notes:  12-M365ExcelClass.pdf (pdf also in zipped folder)
Project 2: Project02

 

Weeks 5-6
Video link:  Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13    (1 hour 49  mins)
Download zipped folder with all files for this video: 13-M365ExcelClassVideoFiles.zip
Click to view pdf notes:   13-M365ExcelClass.pdf (pdf also in zipped folder)
Project 3: Project03ZippedFolder

 

Week 7  (3 Videos, 1 Project)
Video link:  Power Query UnPivot to Convert Cross Tabulated Table into Proper Data Set. 365 MECS Class 14   (03:37  mins)
Download zipped folder with all files for this video: 14-M365ExcelClassVideoFiles.zip
Click to view pdf notes:   14-M365ExcelClass.pdf (pdf also in zipped folder)

Video link:  7 Types of Joins in Power Query Merge. 9 Examples. 365 MECS Class 15   (22:01  mins)
Download zipped folder with all files for this video: 15-M365ExcelClassVideoFiles.zip
Click to view pdf notes:   15-M365ExcelClass.pdf (pdf also in zipped folder)

Video link:  Power Query Group By: Complete Lesson. 10 Examples. 365 MECS Class 16    (33:48  mins)
Download zipped folder with all files for this video: 16-M365ExcelClassVideoFiles.zip
Click to view pdf notes:   16-M365ExcelClass.pdf (pdf also in zipped folder)

Project 4: Project04

 

Weeks 8-9
Video link:  Fundamentals of DAX in Power BI & Power Pivot. 365 MECS Class 17   (2 hour 26  mins)
Download zipped folder with all files for this video: 17-M365ExcelClassVideoFiles.zip
Click to view pdf notes:  17-M365ExcelClassDAX.pdf   (pdf also in zipped folder)

Project 5: Project05 (pdf file in zipped folder has project description)

 

Weeks 10-11  (2 Videos, 2 Projects)
Video link:   Solution for Two Fact Tables: Power Query or DAX formulas or Worksheet Formulas? 365 MECS Class 18  (37:29  mins)
Download zipped folder with all files for this video: 18-M365ExcelClassVideoFiles.zip
Click to view pdf notes:  18-M365ExcelClass.pdf    (pdf also in zipped folder)

Video link:   Budget Vs. Actual Variance Analysis: Data Modeling, DAX, or Worksheet Formulas? 365 MECS Class 19   (14:55  mins)
Download zipped folder with all files for this video: 19-M365ExcelClassVideoFiles.zip
Click to view pdf notes:  19-M365ExcelClass.pdf    (pdf also in zipped folder)

Project 6: Project06 (pdf file in zipped folder has project description)

 

End Of Class