Introduction
I have tracked two more flights and started gathering data and analysing the data in Excel … Power Query/Get & Transform. I then duplicate the first query before Appending both Queries. After that I loaded the Queries in Power BI for the Desktop where I created maps and some graphs/charts.
Two videos that are comprehensive but they take time … about 25 minutes altogether. The video show first, below is video one …
There is no Excel file and Power BI file because you need to build your own from these web pages …
Flight one …. https://uk.flightaware.com/live/flight/JAI275/history/20181021/0745Z/VGHS/VABB/tracklog
Flight two …. https://uk.flightaware.com/live/flight/JAI446/history/20181021/2050Z/VABB/VOGO/tracklog
Video one …
Video two …
All comments gratefully received and if you are going to be critical, you are more than welcome to suggest improvements but do so properly!
Duncan Williamson
24th October 2018
Excel with Excel Master 