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.

Power pivot, power query

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…

http://accessanalytic.com.au/faq-items/power-query-get-transform-part2/

Supporting Files

Download Source CSV Files if you’d like to try this out yourself

Information

For more information  on Power Query and Power BI then please read this article

Training

For training courses in Power Query and Power BI please click here