Skip to main content

USSR: After 20 years

Delighted to be back after three weeks of treatment, care and medication. I rarely fall ill, so this afforded a nice break from my regular activities and also the chance to browse several websites which deal with data analysis and presentation.

My data-set for this week is from the Guardian Datablog, dated Aug 17th, titled "End of the USSR". The piece is accompanied by an image that uses a map to rate the former soviet provinces on their performance since the collapse.

The data includes yearly figures of GDP, GDP per Capita, Population, Life expectancy and Mortality among other interesting indicators like Intentional homicides, Prison population rate, Prevalence of HIV by gender, Unemployment, Happiness index score, Global peace index and Number of McDonald's!

Given the large difference in figures between Russia and other republics, I was curious to see how the presenter would design the population and the GDP charts for comparison.

I was massively disappointed. The population chart is simply a column chart representing the percentage change of population in 2009 from 1991, and a label to display the current population - very much an easy way out. The GDP chart can be found nowhere, although there is a clustered column chart that displays the GDP per Capita for 3 years out of 20. 1991, 2000 and 2009.

I spent an idle afternoon working on the Population and Life expectancy data and came up with the following after 2 hours.


Labels:

Comments

Post a Comment

Please do not post spam or promote your own site(s). Comments are moderated and such comments will not be published.

Also, please keep your comment relevant to the topic of the article.

Finally, please do not post any of your personally identifiable information such as phone number, email address or other important details as this is an open platform.

Popular posts from this blog

The Dorling Cartogram

My last project involved using a multitude of regions for drawing analysis, parallels and comparison. Not wanting to use yet another Choropleth graph, I decided to look up alternatives that were easier to create and preferably required no VBA. Soon I stumbled upon "The Dorling Cartogram", defined in the UCSB site as, "This type of cartogram was named after its inventor, Danny Dorling of the University of Leeds. A Dorling cartogram maintains neither shape, topology nor object centroids, though it has proven to be a very effective cartogram method. To create a Dorling cartogram, instead of enlarging or shrinking the objects themselves, the cartographer will replace the objects with a uniform shape, usually a circle, of the appropriate size." I had the data for Obesity in the United States handy, so I decided to give it a try before using it in my project. I opted to use Bubble charts because data points within a series may need to be of varied shapes based on...
Post a Comment
Read more

The Playfair Charts: Scotland ExIm Barchart

Soon after finishing the second Playfair chart, the one on Wheat Price and Wages, I searched the internet for additional charts made by him. I found a Bar chart circa 1786, which showed the Scottish export and import volumes with other countries. For me, the real thrill was to scroll by the list of the name of places long consigned to history books - Jersey Is, Greenland, Prussia, Denmark and Norway (together) and Flanders.  First, the original Playfair Barchart from Wikipedia,  Then, my version of it in Excel.  A couple of parting words:  Excel 2007 no longer support dots and lines as fillers for charts. Hence, the ribbed import chart is given a different color, Gold.  Normally, I'd use data point labels to construct the chart legends and other declarations given at the bottom of the chart. However, given Excel 2007' inability to automatically re-size labels to fit texts, I was forced to use text-boxes instead. 
Post a Comment
Read more

The Playfair Charts: Wheat Price and Wages

After successfully recreating the Playfair trade-balance time-series chart , I took up the second chart shown in Jorge's post which is fancifully titled, "Chart showing at one view the price of the quarter of wheat and Wages of Labour by the week from The year 1565 to 1821." I left out the top arches. Comparatively, this was the easier chart. Staying true to Jorge' rules, I didn't use any shape or clipart objects in this chart. The big oval shaped object in the middle of the chart, which contains the title is actually a marker for a data point. The original Playfair Wheat price and Wages chart from Wikipedia, and underneath, is my version in Excel.
Post a Comment
Read more