Download Excel START File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-MSPTDA-RelationshipsRatherThanVLOOKUPStart.xlsx
Download Excel FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-MSPTDA-RelationshipsRatherThanVLOOKUPFinished.xlsx
Download Example of Large File Size using VLOOKUP: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-PivotTablesVLOOKUPFinished.xlsm
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-MSPTDA-RelationshipsRatherThanVLOOKUP.pdf

Assigned Homework:
Download Excel file and complete the homework:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-HomeworkStart.xlsx
Examples of Finished Homework:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/013-HomeworkFinished.xlsx


This video introduces Excel Power Pivot and shows how to use the Relationship feature rather than VLOOKUP Function to reduce file size and allow user to pull fields for a PivotTable Report from Multiple Tables.

Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

Topics:
1. (00:15) Introduction
2. (01:43) Look at VLOOKUP solution
3. (02:49) Introduction to What Is Power Pivot? Discuss what a Data Model is.
4. (05:46) Relationship feature
5. (09:16) Create PivotTable Report
6. (11:45) First Look at Implicit Measures
7. (13:02) Enable the Power Pivot Ribbon Tab
8. (13:37) First Look at Power Pivot Window and Data Model
9. (20:30) Summary