Data Modeling Content:
Video/Class Project
20:
Video to watch: MSPTDA
20: Data Source Folder Path Query Parameter, Power Query & Power BI, Dynamic
Folder Location
( 11 min)
Download all 6 files and folders with text
files used in video as zipped
folder:
MSPTDA-20-DownloadAllFiles.zip
13 individual files available here:
Start files for Video/Class Project to download:
MSPTDA-20-TextFiles.zip
(Folder with Text Files)
NewLocationsFoprMSPTDA-20_TextFiles.zip
020-MSPTDA-PQParameterDataSource-Start.xlsx (Excel File)
020-MSPTDA-PQParameterDataSource-Start.pbix (Power BI File)
Finished files (completed after video done):
020-MSPTDA-PQParameterDataSource-Finished.xlsx (Excel File)
020-MSPTDA-PQParameterDataSource-Finished.pbix (Power BI File)
pdf Notes Handout to download:
020-MSPTDA-PQParameterDataSource.pdf
Assigned Homework: NONE
Video/Class Project
21:
Video to watch: MSPTDA
21: Power Query: Reduce Data Model Size, Transformations to Columnar Database
Size
( 25 min)
Download all 4 files and folders with text
files used in video as zipped
folder:
MSPTDA-21-DownloadAllFiles.zip
3 individual files available here:
Start files for Video/Class Project to download: 021-MSPTDA-ReduceDataModelSize-Start.xlsx
Finished files (completed after video done):
021-MSPTDA-ReduceDataModelSize-Finished.xlsx
pdf Notes Handout to download:
021-MSPTDA-ReduceDataModelSize.pdf
Assigned Homework:
Download pdf file and read:
HomeworkVideo021.pdf
No solution given for this one.
Video/Class Project
22:
Video to watch: MSPTDA
22: DAX Data Modeling to Create Date & Time Dimension Tables, Server Downtime
Visualizations ( 20 min)
Download all 7 files and folders with text
files used in video as zipped
folder:
MSPTDA-22-DownloadAllFiles.zip
4 individual files available here:
Start files for Video/Class Project to download:
021-MSPTDA-downtime.csv
(CSV File for data import - it says #21, but it is the correct data import file
for this video #22)
022-MSPTDA-DateTimeDimTable-Start.pbix (Start Power BI File)
Finished files (completed after video done):
022-MSPTDA-DateTimeDimTable-Finished.pbix (Finished Power BI File)
pdf Notes Handout to download:
022-MSPTDA-DateTimeDimTable.pdf
Assigned Homework:
Download pdf file and read: HomeworkVideo022.pdf
Homework Source Data File:
HomeworkSourceData022.xlsx
Solution: Homework-022-Finished.pbix
Video/Class Project
23:
Video to watch: MSPTDA
23: Two Fact Tables? Converted into One? DAX, Power Query or Excel Worksheet
Formulas? ( 1
hour 9 min)
Download all 10 files and folders with text
files used in video as zipped
folder:
MSPTDA-23-DownloadAllFiles.zip
Individual files available here for each section of the video:
Excel Section of Video:
EMT1493Start.xlsx
EMT1493Finished.xlsx
DAX Section of Video:
EMT1494Start.xlsx
EMT1494Finished.xlsx
Power Query Section of Video:
EMT1498-SourceModel.xlsx (Model in Excel File must be imported into new
Power BI Desktop file)
EMT-1498-PowerBIDesktopPowerQuery.pbix (Finished)
pdf Notes Handout to download:
023-MSPTDA-TwoFactTables.pdf
Assigned Homework:
Download pdf file and read: HomeworkVideo023.pdf
Homework Source Data File: HomeworkVideo023-SourceTables.xlsx
Solution: No Solution
Video/Class Project
24:
Video to watch: MSPTDA
24: DAX Multiply / Divide Data Types Discrepancies Solved! ( 6.5 min)
Individual files available here for each section of the video:
Start:
024-MSPTDA-NumberDataTypesMath-Start.xlsx
Finished:
024-MSPTDA-NumberDataTypesMath-Finished.xlsx
pdf Notes Handout to download:
024-MSPTDA-MultiplyDivideAndDataTypes.pdf
Assigned Homework: NONE
Video/Class Project
25 & 26:
Video to watch: MSPTDA
25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH ( 6.3 min)
Video to watch: MSPTDA
26: Budget vs Actual in Power Pivot & Power BI Desktop, DAX & Data Model ( 10:50 min)
Download all 4 files and folders with text
files used in video as zipped
folder:
MSPTDA-25-26-DownloadAllFiles.zip
Individual files available here for each section of the video:
Excel Example (#25):
MSPTDA-25-ActualVsBudget-Excel.xlsx
Data Model &
DAX Example (#26):
Start:
MSPTDA-26-ActualVsBudget-DAXAndDataModel-Start.xlsx
Finished:MSPTDA-26-ActualVsBudget-DAXAndDataModel-Finished.xlsx
pdf Notes Handout to download: 025-26-MSPTDA-BudgetVsActual.pdf
Assigned Homework: NONE
Video/Class Project
29 & 30:
Video to watch: MSPTDA
29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with
Worksheet Formulas ( 10:19 min)
Video to watch: MSPTDA
30: Order & Ship Dates in Fact Table: DAX Formulas and Data Modeling to Create
Reports
( 10:18 min)
Download all 6 files and folders with text
files used in video as zipped
folder:
MSPTDA-29-30-DownloadAllFiles.zip
Individual files available here for each section of the video:
Worksheet Formula Example (#29): MSPTDA-29-Worksheet-OrderShipDates.xlsx
Data Model &
DAX Example (#30):
Start:
Excel Power Pivot:
MSPTDA-30-1-DAX-Start-SideBySideReport-OneDateTable.xlsx
Power BI Desktop:
MSPTDA-30-2-DAX-Start-CrossTabReport-TwoDateTables.pbix
Finished:
Excel Power Pivot:
MSPTDA-30-1-DAX-Finished-SideBySideReport-OneDateTable.xlsx
Power BI Desktop:
MSPTDA-30-2-DAX-Finished-CrossTabReport-TwoDateTables.pbix
pdf Notes Handout to download: 029-30-MSPTDA-OrderShipDates.pdf
Assigned Homework: NONE
Video/Class Project 32-35:
Video to watch:
MSPTDA 32: Data Modeling for Slowly Changing
Dimensions with Worksheet Formulas (8:33 mins)
Video to watch:
MSPTDA 33: Data Modeling for Slowly Changing
Dimensions with Power Query & PivotTable (12:45) mins
Video to watch:
MSPTDA 33 Part 2: Power Query & Standard
PivotTable To Show All Employees Sales Or Not (7.09 mins)
Video to watch:
MSPTDA 34: Data Modeling for Slowly Changing
Dimensions with Power Query & Power Pivot (11:29
mins)
Video to watch:
MSPTDA 35: Data Modeling for Slowly Changing
Dimensions with Power BI & DAX (10:30 mins)
Download All Files In Zipped Folder: MSPTDA32-35Files.zip
Download Invidual files:
MSPTDA32:
MSPTDA-032-ChangingDimensions-PQAndWorksheetFormula.xlsx
MSPTDA33:
MSPTDA-033-ChangingDimensions-PQAndStandardPivotTableStart.xlsx and
MSPTDA-033-ChangingDimensions-PQAndStandardPivotTableFinished.xlsx
MSPTDA 33 Part 2:
MSPTDA-033-Part02-ChangingDimensions-PQAndStandardPivotTableStart.xlsx
and
MSPTDA-033-Part02-ChangingDimensions-PQAndStandardPivotTableFinished.xlsx
MSPTDA 34:
MSPTDA-034-ChangingDimensions-PQAndPowerPivotStart.xlsx and
MSPTDA-034-ChangingDimensions-PQAndPowerPivotFinished.xlsx
MSPTDA 35:
MSPTDA-035-ChangingDimensions-PowerBIAndDAXStart.pbix
MSPTDA-035-ChangingDimensions-PowerBIAndDAXFinished.pbix
pdf notes:
032-35-MSPTDA-ChangingDimensions.pdf
Assigned Homework: NONE