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

%d bloggers like this: