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.