Sunday, 27 May 2012

Worse UK recession since the 1930s

In this blog, we look at the UK Gross domestic product (GDP). We compare GDP now and in the past and how previous

The UK is officially stuck in its second recession in three years after the economy unexpectedly shrank by 0.3% between January and March. A technical recession is defined as two or more consecutive quarters of economic decline.

The data we have gathered from Office for National Statistics covers change in GDP going back to 1948, total GDP and GDP per capita. The number are adjusted for inflation.

The figures show this recession is now worse than the 1930s.

Tuesday, 10 April 2012

Is the importance of social media over emphasized in the Republican presidential race?

Where the US republican presidential race is concerned, The Twitter sentiment is damp and candidates with the most supporters and talk-ability are out of the race. How reflective is the Twitterverse of the real world?

The US Republican presidential race is heating up with Mitt Romney seemingly leading the pack. And as social media is heralded as the new power behind world politics, we decided to take a look at how well the candidates are faring on Twitter, and to what extent the cyber discussion is impacting the trends and potentially the results of the most powerful race on Earth.

We examined all tweeting activities from the 16th of 21st of March using the office Twitter account of present / past candidates (@MittRomney, @RickSantorum, @newtgingrich, @RonPaul, @THEHermanCain, @GovGaryJohnson, @GovernorPerry, @MicheleBachmann) including wannabe candidate Sarah Palin (@SarahPalinUSA). In total, our twitter probe collected 95,470 tweets. Tweets in English were by far the most dominant (96%) with Spanish just over 1%.

We enriched the data with:
  • Sentiment rating to determine whether the tweets are positive, neutral or negative. We used two algorithms.
  • Viralheat - algorithm tends to favour positive and negative tweets
  • Twitter Sentiment - algorithm tends to be more neutral
  • Tweeter Influence, which measures measure the tweeter’s reach and influence out of a scale of 100, with 10 being low influence and 100 very influential
We compiled the analytics dashboards using Tableau Software’s visualization capabilities and Albatrosa’s own social media probe. Please find below a summary of our analysis. We welcome your comments and insight. We trimmed some of the data (including tweets) to keep the file size down. If you would like the full analysis, email us at sales(at)
If you believe Twitter, @RickSantorum has the most talkability, with a share of 36% of total tweets. @MittRomney comes second with 31% and @newgingrich is at 19%. All other candidates are in the single digits.

Yet, @newtgingrich is the most retweeted, with 50%, while @RickSantorum and @MittRomney messages were retweeted at only 30%.

The average sentiment across all candidates remained fairly flat throughout the period: average 0.37, (range -1 to 1 with -1 being negative, 0 neutral, and 1 positive). This means that tweeters have been consistent with their sentiment and there wasn’t any major event that shifted opinion. @GovGaryJohnson topped most positive tweets with an average of 0.67 and @newtgingrich at the other end of the scale at 0.16.

56k of the tweets (58%) had a positive sentiment vs 39k negative. That said, tweeters with the most influence expressed more negative sentiment (29.69) than positive (29.34)

We examined influencers and damagers who had over 5 tweets positive and negative sentiment respectively using Tweeter Influence, which measures the tweeter’s reach and impact. Interestingly, all key influencers are media personalities, the top 3 influencers being @Piersmorgan, @CNN and @CNNbrk. The top damager Tweeter is @JohnKingCNN. @RickSantorum has the highest number of advocates and damager (850 vs 230) followed by @MittRomney (800 vs 140). This is not a surprise considering that they both command the highest number of tweets.

In percentage terms, Ron Paul has the highest number of advocates (150) to tweeters (5237 or 2.86%). This compares with @RickSantorum (2.4%) and @MittRomney (2.7%). Scatter diagram gives us a perspective of the tweet distribution across three measures - total tweets, average sentiment and average influence. High influencers hardly tweet. There is an even scatter of tweeters by influence and sentiment which explains the flat averages.

So what can we conclude from all of this? To recap, Ron Paul has the most vocal supporters and Rick Santorum is talked about the most, with more negative sentiment than others, which could explain his decision to “suspend” his bid for the nomination. Yet overall the sentiment is quite tame and Mitt Romney is still leading the polls outside of Twitter. This may mean that social media is not yet a major force in terms of deciding the winner of the republican race. We all know how well Obama did in social media four years ago and he has already kicked off his campaign online; it remains to be seen how decisive the influence of social media will be in the final elections.

Sunday, 4 March 2012

Top Arms Producers

Recession, what recession? It has been business as usual for the world's biggest arms companies who have seen sales of weapons and military services rise during 2010 and exceed $400bn. In this blog we analyse the top arms producers by company and country. The analysis is based on data published by The Stockholm International Peace Research Institute (SIPRI). There has been very little change between 2009 and 2010 (1% change)

The top 100 list of arms-producing and military services companies in the world is dominated by North America and Western Europe although Chinese companies are not included in the rankings and data on Russian arms manufacturers is limited due to insufficient data.

Sales from the 44 US-based companies featured accounted for over 60% of all arms sales by the top 100 producers in 2010, with Lockheed Martin topping the list at $35.7bn  worth of arms sales in 2010. UK trails behind with $53.4bn with BAE systems contributing to more that 50% of this revenue.

The visualisation below has been created using Tableau Software. It is interactive. Click on any object and do your own analysis.

Credit ratings: how Fitch, Moody's and S&P - Updated

Standard and Poors have downgraded Greece's sovereign credit ratings to 'selective default'. Earlier this month UK had the outlook on it's Aaa Moody's rating changed to negative in a range of adjustments by the major credit agency including downgrades for Italy, Malta, Portugal, Slovenia, Slovakia and Spain. We've updated the visualisation based on our original post. Click to view

Saturday, 28 January 2012

Where do People live in Europe?

In this visualisation, we examine using Tableau Software where people live in Europe.

We have focused on six European countries and examined how many citizens of each of those countries live in each place. For example in the UK there are 123,000 French inhabitants whereas in France there are 150,000 UK citizens living in the country.

Poles by far has the most nationals living abroad (1.5 mil) residing in the UK (36%) followed by Germany (28%).

Spain is still the most popular destination for Brits as 390,880 inhabit the country whereas the Spanish it seems prefer to settle in France. With over 550,000 Italian people, Germany seems a popular choice for their European friends. For the French, the UK is a popular choice for emigration followed very closely by Spain.

Sunday, 22 January 2012

Credit ratings: how Fitch, Moody's and S&P rate each country

Last week, Standard and Poor's has downgraded nine countries in the eurozone. See how different credit rating agency compare countries.

We have analysed the data using Tableau Software. Please click on the viz to interact and drill through.

France has been stripped of its coveted AAA credit rating in a mass downgrade of nine eurozone countries by Standard & Poor's. It also cut Austria's triple-A rating, and relegated Portugal and Cyprus to junk status.

The majority of the countries have a stable outlook (55% on average). That said, the number of countries with negative or negative watch far exceeds those with a positive one across all three agencies.

S&P has 10 countries on positive outlook, all emerging market, including Turkey, Chile, and Indonesia.