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.