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.

European Cargo airports - new dashboard. (2010-2012)

Turned out to be quite easy to adapt the passenger dashboard to do the same for the freight & mail data from Eurostat (avia_gor_xx). So see the link to the new dashboard above.

Flights: are commercial freight & mail flight departures (FRM_CAF_DEP in Eurostat terms)
Tonnes: are tonnes of freight & mail on board on departure (including direct transit cargo that stayed on the aircraft - FRM_BRD_DEP)

European airport departures - 2013 & 2014 data updated.

A delay in new posts, while I work on extracting a new dataset and turning it into some useful dashboards. Watch this space.

But meanwhile, the good news is that Eurostat have published updated data for 2013 and 2014, sorting out some earlier problems and adding more months. Check out the data in the 'production version' - link is at the top of the page: I've renamed the two dashboards into something more meaningful (I hope):

• Departure Patterns shows departures from the selected EU28 airport in terms of destinations, load factors, distances, aircraft sizes, pax, flights.
• Departure Points lets you select any airport (including those outside Europe) and see details of where flights leave EU28 airports to reach that point.

I've also re-size so it fits on the ipad better - but discovered Tableau menus work better in Safari than Chrome on the ipad.