Get & Transform w/ PowerPivot

Practically: Pulling data from multiple sources and producing quick and beautiful dashboard reports that details previously impossible to find details.

Outcomes: Excel is not the same program as it was in 1980s and it’s undeniable that Get & transform will change the landscape of business in 2020. These features help you connect multiple files together, lookup tables hosted online and even produce elaborate collaboration systems. If you know a lot about Excel and you want to master this amazing new tool, come discover the power of modernity with this software. This second day focuses on the analysis part of the work by learning on how to make filter functions, understand basic DAX and an overview of PowerBI and its functions.