Friday, April 18, 2014

Premier League Transfers - Summer 2013 and January 2014

Here's looking at the transfer movements involving Premier League teams! And very much influenced by the links I mentioned in my previous post.

Tableau Hand-off Maps and Network Maps

This post is a tribute to the versatility of tableau and how almost any visualization can be recreated in it (with varying degrees of effort, of course).

Hand-Off Maps

Below is an example of a type of hand-off map, representing the migration between countries. Another example can be found here. As you can see, hand-off maps make it really easy to understand paths of flow between two nodes - in this case the movement of people between countries.



You can find a really good example of a hand-off map recreated in Tableau here by Joe Mako.

Network Maps

Network Maps are more designed to show the connections between different nodes. Below is the network map for my Facebook connections. People have been grouped together based on the inter-connections between them. So all my school friends are clustered together while colleagues from work form another cluster. Lines between people from two different clusters indicate their connection.

This network graph was created using Fritwork.com,
a pretty cool site that lets you visualize your Facebook connections
If you found Joe Mako's hand-off map easy to follow, then the method of recreating network maps will come quickly to mind. You can find Michael Martin's very clearly explained method here. Although assigning the co-ordinates is a bit cumbersome, defining a characteristic based on which to develop the network - grouping and linking nodes - may help in defining the algorithm to automate the co-ordinate creation for each node.
The PDF document also contains a list of other really good resources to understand Network Theory. Understanding the basics and some key metrics (which Michael has helpfully listed in the document) will also help in creating a network graph.

Tuesday, April 8, 2014

Intersecting Economic, Social and Political Indices


The drawbacks of using GDP as a measure of advancement or progress of a country has been demonstrated many times before. GDP, being only a measure of the economic advancement of the country does not offer much insight into the other indicator's of a country's well-being such as literacy rate, infant mortality rate and sex ratio.

This exercise looks at metrics that broadly span three categories


  • Basic Human Needs
  • Foundations of Well-being
  • Opportunity
One gets an idea of the granularity and eye to detail with which this exercise was conducted when one looks at the metrics, which cover everything from access to piped water and basic knowledge to outdoor air pollution and tolerance for homosexuals.

What I have done here is not recreate the extremely illustrative and comprehensive graphs done by the Social Progress Imperative; but rather I have attempted to study how natural wealth and democratic index could influence the social progress index and the interaction between the social progress index and GDP per capita.

Democratic Index
The Democratic Index has been developed by The Economist Intelligence Unit and considers the following metrics:
  • Electoral process and pluralism
  • Functioning of government
  • Political participation
  • Political culture
  • Civil liberties
Based on how countries score on the five categories, they have been grouped into Full Democracies (South Korea, US, UK), Flawed Democracies (Argentina, India) , Hybrid Regimes (Venezuela, Iraq, Lebanon) and Authoritarian Regimes (Saudi Arabia, United Arab Emirates).

Natural Wealth
Information for Natural Wealth per capita has been obtained from the World Bank and in expressed in US dollars. It captures the wealth in terms of crops, pasture land, forests, coal, natural gas, oil and subsoil resources.

Insights
  • Few authoritarian regimes dominate the top quadrant of high GDP per capita and high social index. These countries are distinguished by the fact that they are very rich in natural resources.
  • The authoritarian regimes are not fully oppressive as one would expect, since in terms of freedom of the press, personal choice, these countries score in the same range of flawed democracies. The real differentiation lies in indicators like political terror and personal safety