Power Pivot Content:
Video/Class
Project 13:
Video to watch:
MSPTDA 13: Power Pivot Intro 1: Relationships
rather than VLOOKUP for PivotTable Report ( 15:23 min)
Start files for Video/Class Project to download:
013-MSPTDA-RelationshipsRatherThanVLOOKUPStart.xlsx
Example of file using VLOOKUP Formulas:
013-PivotTablesVLOOKUPFinished.xlsm
Finished files (completed after video done):
013-MSPTDA-RelationshipsRatherThanVLOOKUPFinished.xlsx
pdf Notes Handout to download:
013-MSPTDA-RelationshipsRatherThanVLOOKUP.pdf
Assigned Homework:
Download Excel file and complete the
homework:
013-HomeworkStart.xlsx
Examples of Finished Homework:
013-HomeworkFinished.xlsx
Video/Class
Project 14:
Video to watch:
MSPTDA 14: Power Pivot Into #2: Amazing
Columnar Database for Importing Millions of Rows of Data ( 19 min)
Start files for Video/Class Project to download:
014-MSPTDA-PowerPivotToImportMillionsStart.xlsx
014MSPTDATextData.zip
Finished files (completed after video done):
014-MSPTDA-PowerPivotToImportMillionsFinished.xlsx
014-ImportOneText.xlsx
pdf Notes Handout to download:
014-MSPTDA-ColumnarDatabaseNotes-PowerPivotToImportMillions.pdf
Assigned Homework:
Download Excel file and complete the
homework: 014-HomeworkStart.xlsx
Zipped Folder with Text Files:
014-MSPTDA-HomeworkTextFiles.zip
Examples of Finished Homework:
014-HomeworkFinished.xlsx
Video/Class
Project 15:
Video to watch:
MSPTDA 15: Comprehensive Introduction to Excel
Power Pivot, DAX Formulas and DAX Functions ( 2
Hours 5 min)
Start files for Video/Class Project to download:
Start Excel File:
15Video/015-MSPTDA-ComprehensiveIntroPowerPivot.xlsx
Zipped Folder with Data:
15Video/015-TextFiles.zip
Example of DAX that Can't be Done
in Standard PivotTable:
015-WhyDAXandNotStandardPivotTable.xlsx
Finished file (completed after video done):
015-FinishedDashboard-Finished.xlsx
pdf Notes Handout to download:
015-MSPTDA-PowerPivotComprehensiveIntroduction.pdf
Assigned Homework:
Download Excel File with Instructions for Homework:
Start Excel File:
015-MSPTDA-Homework-Start.xlsx
Zipped Data Folder:
015-MSPTDA-HomeworkExcelDataFiles.zip
Examples of Finished Homework:
015-MSPTDA-Homework-Finished.xlsx