2017 Cycle-Commuting now complete.

I've updated the cycle-commuting Tableau dashboard with the remainder of the 2017 data, including the weather data. A wet and slushy end to the year. And more business travel meant less commuting overall.

I still haven't quite worked out why there is so much quarter-to-quarter variation; 2017 showed a repeat of the pattern of 2016, so this looks like seasonality rather than randomness. I'm sure traffic, daylight and weather have something to do with it. For example, there's a lot less traffic for much of the Q3, since the schools are on holiday.

Further analysis is for another day, but ideas certainly welcome. You have the data.

I've decided that 3 years is quite enough of this sort of recording, so for cycling at least, that's all folks!

Passenger update, finally

It seems it's always October before the last calendar year is complete. 2017 seems no exception. 

I have updated the passenger data from Eurostat in the dashboard. Congratulations to the Netherlands for already providing data as far as April 2017. Six laggards are still short of data in 2016. October, maybe.

Energy - nearly 8 years

Just updated the household energy consumption Tableau - the 8th year of data will be complete next week! 

Maybe I should link it to the weather information - like the cycling dashboard, which has also been brought up-to-date. Seem not to have been in the office much over the Summer, so numbers are down. But speeds up, as usual at this time of year.

Several updates

I have updated the B787/A350 routes dashboard though there doesn't seem to have been a big increase in the numbers of routes in this data source.

And the cycle-commuting and energy dashboards are also up-to-date.

Aircraft Routes updated (B787 A350)

I've updated the maps of the announced routes of B787 and A350. See the Tableau for the latest data, adapted from airportspotting.com.

Cycling into the wind

So now I've merged the wind data that I was using with the thorn plots and the cycling data on the Tableau public dashboard. It uses an average wind speed and direction based on the two metar observations nearest to the mid-time of the ride. 

I wondered how to show wind direction, but in the end a simple grouping by quadrant was easy to do and good enough to separate the data into meaningful groups.

The effect of windspeed on the way home, when the wind is in the SW is pretty clear, I think.

I just wish I could get a sensible data between start&end calculated field in the title. Could not get this to work in Tableau.

Routes of A350 and B787 - updated visualisation

The latest version of the routes map has been updated to use great circle links between airports. There seem to be 2 options for this - getting Tableau or R to do the work. Getting R to do the work was easier for me (just an application of gcIntermediate()) than getting to grips with interpolation functions in Tableau. The cost is that you pass a lot of extra data. I suppose I could have used 2 files and done a join in Tableau instead, but the volumes are not huge. 

There are tableau workbooks around to do the work, but from tableau public it doesn't seem to be possible to open and copy the calculations as suggested.