Hi all,

It is time for the Data Geek Challenge III. Here is my entry and if you want to be part of it, follow the link: DataGeek III: How to Join

My Geek-entry is a very serious problematic. Smog!

We all need our environment and we only got one. So I want to show you how the Smog has changed through 20 years. My dataset includes the years from 1990 to 2010. I did not found a set which includes also 2011 to 2013 but I think everyone can read enough about the problematic out of this statistic.

The statistic is taken from the united nations site for MDG Indicators.

Link to the data-set: unstats | Millennium Indicators

Before we start, I need to answer this question:

Which house/category do you belong?

Category is a social good which belongs all of us, the environment, that’s why I’m joining the house of spirits for this blog here.

So let us start and see how Smog changed through the years. You could think, there must be less than back in 1990 out of all the programs the governments in the world has set up. In my mind are things like the electric cars or here in Europe all the new laws about energy saving lights or the vacuum cleaners. I think you all got something similar in your mind right now. Here are hard facts about smog:

Let’s have a look behind this poor numbers and see what countries are in the ranking.

Back in 1990 the USA is top and that is not good for the country.

I really like the cloud of words, because it shows the facts in a really unique way! Above I got another diagram, which shows the whole world in one picture and shift visualization to a new level. (I do not know any other product to visualize data in that lightning speed)

And what about 2010?

China is now on top of the list. That is for sure, but what about the smog reducing programs in the world. Let us have a look at the countries, which are above in the ranking.

On the next slide you can see how the Top 7 countries walk through 2 decades.

Ok, that isn’t a good visualization to compare these data. So I created another set to see it very clear.

(What I wanted to show with the two graphics above is, that it is also possible to create very clear “classic” charts very fast and without changing the tool. So it is not just a tool to create fancy graphics)

Here is the same statistic prepared in another way (just two clicks away)

And last but not least here is a statistic about the top 20.

In my opinion we all are part of one world and we need to save the planet for our children. I don’t want to share tips about protecting our environment. I’m sure you all know how to help (I hope you do) and I just want add one sentence.

“Our planet is our house, and we must keep it in order and take care of it if we are genuinely concerned about happiness for ourselves, our children, our friends, and other sentient beings who share this great house with us.”            ~Dalai Lama

Outro

That’s it. This is my Data Geek Entry.

To interpret the data in a personal way is now very easy. Despite the important theme it also shows impressively how to graphically display data with SAP Lumira. There are a lot more impressive facts inside the data, for example the percentage of smog reducing

between different countries. Perhaps someone take the set again. (or even I do 😉 )

Cheers

Florian

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply