Monday, 20 December 2010

UK is freezing – how cold is cold?

Temperatures in the UK have plummeted in the last few days causing major disruption to the transport network and ruining the traditional Christmas gateway weekend.

The met office takes regular readings throughout the day. The visualisation below is based on readings at 9am on the 20th of December.

The UK temperature ranged from 3.6 deg Celsius in St Marys Airport (Scilly) to -18.7 in Pershore (Worcestershire). The national average was a freezing -8.7 deg. Northern Ireland (Castlederg) came in second at -18 deg. Surprising Lerwick (northern tip) was only -1.1 deg.

We have used Tableau in our analysis. To get the most of this insight click on the visualisation below to bring the data to life. Click on countries, multiple values and/or basically anything you find interesting and watch how the visualisations update automatically.


Friday, 17 December 2010

Which country does best at reading, maths and science?

The world education rankings from the OECD are out. The UK is slipping down in maths, reading and science, and has been overtaken by Poland and Norway.

China topped the league in all subjects. The UK is ranked 25th for reading, 28th for maths and 16th for science.

We have used Tableau in our analysis. To get the most of this insight click on the visualisation below to bring the data to life. Click on countries, values and/or basically anything you find interesting and watch how the visualisations update automatically.

Tuesday, 16 November 2010

Who owns America's debt?

The US Federal Deficit is always in the news. Who actually owns the debt?

We have used Tableau in our analysis. To get the most of this insight click on the visualisation below to bring the data to life. Click on countries, values and/or basically anything you find interesting and watch how the visualisations update automatically.



Treasury bonds are how the US - borrow money by issuing government securities, which other countries and institutions buy.

Total debt has risen from 2.6b in Q3 2008 to 4.2 in Q3 2010.

US national debt is owned predominantly by Asian economies, with China topping the league with 868 billion US$ (21%) and followed by Japan 837 billion US$ (20%). The United Kingdom is third with 448 billion (11%).

Thursday, 11 November 2010

Most Popular Airliner Crashes

As an investigation begins into the cause of the engine failure of the Qantas-owned A380 the safety of airliners and air crash data worldwide comes into focus.

Click on the chart entries to get the most of this insight and bring the data to life.


The MD 80 has the highest number of passenger fatalities with Boeing 737 (CFMI) follows closely with 1,049 fatalities. Airbus A320 comes in third with 602 fatalities.

The Boeing 777, Airbus A319 and ERJ- 145 have all recorded no fatal accidents to passengers or passenger fatalities.

Boeing 737 (NG) currently holds the highest number of operating airliners at 3,274 worldwide.

From a manufacturer perspective, Boeing has 7,346 operating airliner with 2,867 fatalities followed by Airbus with 4,921 operating airliner with 1,202 fatalities.

Wednesday, 27 October 2010

Oliver and Olivia: the most popular baby names in England and Wales

What are the top baby names for 2009? We have used Tableau Software in our analysis to analyse the date courtesy of the Guardian and the office of national statistics.

Click on the chart entries to get the most of this insight and bring the data to life.



Olivia remains steady as the most popular girl's name and is joined by Oliver, up one place to top the poll of most popular baby names.

The fastest rise in popularity was seen by the girl's name Maisie which jumped 29 places from last year to the position of 34th most popular. Austin saw the biggest surge in popularity amongst the boys' names, up 60 to finally make an appearance in the top 100.

The regional data shows Jack and Oliver to be the top names across the UK apart from in the West Midlands where Mohammed takes the top spot for the boys. For the girls, Olivia and Sophie stay strong across England and Wales apart from the East where Chloe takes the top place.

Sunday, 20 June 2010

England’s Dismal Display at the World Cup – you decide

How did England and Algeria compare according to the statistics? Check out the analysis with data courtesy of the Guardian and Opta.

We have used Tableau in our analysis. To get the most of this insight click on the visualisation below to bring the data to life. Click on players, teams and/or basically anything you find interesting and watch how the visualisations update automatically.

With no goals, we decided to have a look at examining passing accuracy throughout the game by team and player.



Kadir and Yebda had over 90% passing accuracy for Algeria. Carragher and Cole matched that accuracy for England. Overall, England had 74% passing accuracy (85% in own half and 66% in the opposition). Algeria passing accuracy was 68% (78% in own half and 60% in the opposition).

England had more action in the opposition half, 200 passes versus Algreria’s 150.

Lampard had the most passes (67) with 81% accuracy Barry (64) with 81% accuracy.

Does this mean England had a better chance at winning? You make up your mind by clicking and interacting with the data. The fact remains that both teams went home with just one point.

Tuesday, 16 February 2010

Long delays on Monday mornings at Heathrow: Misconception

In this post, I examine flight departure delays out of Heathrow by weekday and time. To my surprise, those long and frustrating waits on the tarmac on Monday morning could not be back up by statistics.


We have used Tableau in our analysis. To get the most of this insight click on the visualisation below to bring the data to life.

The average departure delay from Heathrow is 38.2 min and the busiest hour is Friday at 9am (55.75 min delays). Monday morning delays average around 26min well below the average.

Dhaka and Colombo have on average the highest departure delay with 137 and 123.9 minutes respectively.

Now you know. Give it a try by clicking and interacting with the visualisation.