Handling odd data

In the avia_par_xx data from Eurostat there are a number of odd values, particularly from France (missing seat counts in some years) or Greece (fewer seats than passengers, which sounds uncomfortable!).

I would like to follow Eurostat's lead and not just throw such observations in the datasets away - they are official, after all. So these numbers are included in total seat and total flight counts, but I've had another try at making the load factor and seats/flight calculations more robust to such issues.

Just a reminder that I use the load factor formula that is not weighted by distance (passengers/seats, not RPK/ASK).

Now I've tried to trap the odd data values, and set them to NULL in the numerator, and 1 in the denominator, so that they have little effect when aggregated into region averages, for example. 

But you'll still see France and Greece graphs doing some odd things.

Flow-control in the flight data!

In tableau, I've not got the functionality out of geographical hierarchies that I was expecting (maybe I'm not doing it right). So instead, I've built a set of prompts that now allow you to look at flows of flights at a variety of different levels of aggregation such as airport-airport, airport-region, airport-country, or country-country.

Not as difficult as I thought it would be, but hat-tip to vizpainter for putting me on the right track.

So check out the new tab in the 'pax' dashboard, that focuses on load factors and aircraft size!

European Flight Data updated

The 'pax' dashboard of European flight data from Eurostat has been updated with 2015 - not all available yet, and I had some difficult loading EL, FR and NO, so these countries only go to 2014.

More energy

I've updated the energy dashboard and it shows clearly the benefits of the new boiler, but also the mild Winter we've had so far. Looking forward to the bill this year!

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.