Introducing Power Pivot
In this video I introduce Power Pivot and how you can use it to join multiple tables of data together and display your data in a Fiscal Year format.
In part 1 I demonstrated how Power Query can quickly consolidate all of the files in a folder and bring that data into Excel.
In part 2 I followed on from that introduction and added an extra transformation step to get the dates I needed. I then converted the data into a Pivot Table and Pivot chart and added some user-friendly Slicer filters.
If you missed part 2 take a look here…