Improved Passenger Dashboard

To celebrate the completion of the 2014 data from Eurostat, I've reorganised the passenger dashboard so departures from Europe (EU28/EFTA) and arrivals outside Europe are available in a single tab. (Previously they were in 2 separate tabs.)

So if you select Copenhagen, say, you'll see all the flights departing Copenhagen (with passenger and flight counts, seat counts and load factors). If you select JFK, say, you'll see all arrivals at JFK from European airports.

Unfortunately, this data set does not include Turkey as a departure point, so for Turkish airports you can only see arrivals from EU28/EFTA airports.

(I plan to make the same simplification for cargo too, in future.)

2014 data are complete, finally!

The passenger and cargo data from Eurostat have finally been updated, so I've updated them in the main dashboards. 2014 data are complete, but 2015 is still very patchy so it has not been loaded at all.

I have to say, refreshing the data in Tableau is a doddle!

European airports flight departures - 2014 updated

The passenger data in the tableau dashboard has been updated with the latest data from Eurostat (avia_par_xx).

and for cargo too - see the cargo dashboard.

Plotting GPS routes

I wanted to try something different in Tableau - its ability to plot geographical routes.

So I've loaded up some routes from a bike GPS, using R to manipulate multiple files and add speed calculations - though I'm sure the haversine formula could also easily have been implemented in tableau to get the distances. 

It took me a while to realise the return journey from home is longer by several minutes. Check out the speed and you can guess where the incline is with me, or against. 

European Cargo airports (2003-2013)

Finally, I have extended the data that's available in the cargo dashboard to cover 2003-2013, where underlying monthly data are available from Eurostat.

Check it out!

Seems to be some missing data for Sweden 2005-2007 - the data availability tab gives a clear account of which years are available for which States.