Loading...

Highline Excel 2016 Class 14: VLOOKUP as Relationship in Power Pivot Data Model & Vice Versa

16,358 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 17, 2016

Download Files: https://people.highline.edu/mgirvin/A...
In this video learn about how to create a Regional Sales Report with:
1. (00:13) Discussion about VLOOKUP or PowerPivot Data Model Relationships.
2. (01:57) Copy Sheets with Keyboard and Mouse.
3. (02:43) VLOOKUP Example to create Regional Sales Report from Two Tables.
4. (04:25) Power Pivot Data Model Relationships Example to create Regional Sales Report from Two Tables.

With big data, one of the main advantages is that with relationships between lookup tables and
transaction tables, the DAX formula process over the lookup tables (which contain unique lists) and in
turn filter the transaction table down to a much smaller size, which in turn require less time when the
formulas calculate. More later.

Loading...


to add this to Watch Later

Add to

Loading playlists...