Highline Excel 2016 Class 14

VLOOKUP as Relationship in Power Pivot Data Model & Vice Versa

DESCRIPTION

In this video learn about how to create a Regional Sales Report with:
(00:13) Discussion about VLOOKUP or PowerPivot Data Model Relationships.
(01:57) Copy Sheets with Keyboard and Mouse.
(02:43) VLOOKUP Example to create Regional Sales Report from Two Tables.
(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.

WORKBOOKS

Download “Highline Excel 2016 Class 14” Highline-Excel-2016-Class-14.zip – Downloaded 14 times – 713 KB




Be the first to comment

Leave a Reply