Hello Everyone,

I have been thinking for a while to come out with a topic which could help people and make them aware of what we are heading towards .

Well after pondering for a while I have come up with the topic which most of them know about but still requires some more focus .

Yes CO2 Emissions across the globe is my first ever story for my data geek entry .

In this post, I would like to brief you the usage of SAP Lumira to understand the CO2 emissions by showing you the insights of my data .

The data can be downloaded from Data Samples for SAP Lumira

As we have an option in SAP Lumira to explore the data directly from ExcelI have just browsed the source file and selected the required fields to explore and

finally acquired the data.

I wanted to find the Countries which contribute to the high CO2 emissions during the period of 2005 – 2010 . Since SAP Lumira has a good geographical bubble

chart and chloropleth chart , it has helped me to view my data in a better way and give a good understanding of exploring my data using it .

I have created a Geographical Hierarchy on Country Name .

/wp-content/uploads/2013/12/geo2_343968.jpg

  Few issues were resolved by editing the Geopgraphical Data . This feature of SAP Lumira has helped me to enrich my data and has helped me to come out

  with a more accurate information . 

Geo.jpg

  Finally all issues have been resolved .

/wp-content/uploads/2013/12/geo3_344030.jpg

  Then I have made visualisations of my data for period of 2005 – 2010 using Geographical bubble chart and Chloropleth chart which gave the density of pollution

  due to CO2 Emissions across the globe .

  This is for the year 2005 . I have used background images and controls to make it more interactive . The controls help to give a more detailed understanding of

  my data .

/wp-content/uploads/2013/12/visual1_344031.jpg

  Well since I am an Indian I would just like to show you the insight of my data of India’s contribution to CO2 Emissions during 2005 which is around 1.06 .

Insight.jpg

    Similarly I have come up with visualisations for the years 2006 , 2007 , 2008 , 2009 , 2010 .

/wp-content/uploads/2013/12/visual2_344033.jpg

/wp-content/uploads/2013/12/visual3_344034.jpg

/wp-content/uploads/2013/12/visual4_344035.jpg

/wp-content/uploads/2013/12/visual5_344036.jpg

/wp-content/uploads/2013/12/visual6_344037.jpg

  Also now to enrich my data I have added % change 2005-10 to measures and removed a few duplicate attributes .

/wp-content/uploads/2013/12/measure2_344038.jpg

/wp-content/uploads/2013/12/measure_344039.jpg

  Now I have moved a step further and have compared the CO2 Emissions during period 2005 – 2010 by % change in 2005 – 2010 . I have implemented this using line

  chart and area chart .

/wp-content/uploads/2013/12/visual7_344040.jpg

  Now I have compared CO2 Emissions during years 2009 & 2010 by using donut chart , column chart and line chart .

/wp-content/uploads/2013/12/visual8_344041.jpg

  SAP Lumira also gave me a zoom in option which I could used for my donut chart to show the % change during 2009 – 2010 in CO2 Emissions country wise .

visual8(1).jpg

  Now I have used the stacked column chart feature which I found very useful to showcase the CO2 Emissions during 2008 – 2010 for various countries .

  This gave me a better understanding of the major contributors to CO2 Emissions which in turn is leading to global warming . If you observe closely I really found

  the background image really interesting where the Statue Of Liberty is drowning with a man hanging on it . I am just trying to imply that if we don’t start to do something

  about the alarming increasing rate of CO2 Emissions then this would probably be the scenario of the world .

/wp-content/uploads/2013/12/visual9_344043.jpg

  Next I have used filters and rank values to show the top 3 major contributors to CO2 emissions during period 2005 – 2010 .

visual10(1).jpg

visual10(2).jpg

visual10(30.jpg

  Finally after these processes this was my visualisation for the top 3 countries contributing to CO2 Emissions during the period 2005 -2010 . Also here

  if you look closely there is a Qatar aeroplane flying in the background and Qatar is one of the leading contributors towards CO2 emissions .

/wp-content/uploads/2013/12/visual10_344027.jpg

Finally this is my last visualisation by which I would like to conclude my story . I have used tag cloud chart to achieve this . This is a really cool feature wherein the countries

which contributed more towards CO2 Emissions were shown in larger font (as per 2010 data) .

/wp-content/uploads/2013/12/visual11_344028.jpg

I have come to the end of my story . I have really found SAP Lumira helpful in enriching my data and helping me to get a deeper understanding of the increasing

rates of CO2 Emissions across the globe . This was an eye opener for me as I went through my data and I hope I have made you aware too about the consequences

by stating these facts and in the process also made it interesting as I narrated my story and made it worthwhile for the readers . All in all SAP Lumira has helped me come

up with a good conclusion to this topic along with a very good visualisation .

Thanks for reading .

Regards ,

Abhishek Dutta

To report this post you need to login first.

12 Comments

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

  1. Irshaad Bijan Adatia

    Abhishek,

    Great post!!

    I enjoyed seeing the different ways you chose to represent CO2 emissions.

    I’d like to know more about your experience, if you’d be willing to share!!!

    1. Did you have to cleanse or ‘prepare’ your data at all? If so, how long did this process take?

    2. After all was said and done, how long did it take you to visualize everything?

    We’re looking forward to many more great posts in the future!

    Bijan

    (0) 
    1. ABHISHEK DUTTA Post author

      Hello Irshaad !

      First of all thank you for your patient reading of my blog and thank you for appreciating my work !

      I would love to share my experience with you .

      1.Yes if you see my blog I have shared the link for where I have taken the dataset . So yes after acquiring the data set I had cleansed my data a bit by removing few unwanted data . But nevertheless after I started analyzing my data I found out many unresolved issues which I have shared in this blog . I would have never come across them but with the help of SAP Lumira I found these insights of my data and spend time resolving and preparing my data to make it presentable and accurate .

      2. Yes I did take some time to prepare and visualize and compose my story . Actually most time went in choosing the topic from such a wide variety . Then I had used many features which SAP Lumira had provided and put my creativity and thinking into it and finally this is how it came out . All this took almost an entire day .

      Anything else you would like me to share ? I am more than happy to reply .

      Thank you for your valuable comment .

      Abhishek Dutta  

      (0) 
      1. Irshaad Bijan Adatia

        Abhishek,

        I must have missed that you DID share your data! My apologies for that … Thank you for answering my questions. I look forward to many more submissions in the future!

        Bijan

        (0) 
        1. ABHISHEK DUTTA Post author

          Hello Bijan ,

          Thank you for your interest in my blog ! I would be glad to answer more of your questions . Also would request you if you could like and rate my blogpost .

          Abhishek

          (0) 
    1. ABHISHEK DUTTA Post author

      Hello Kumar ,

      Thank you for reading my blog and appreciating my story ! Also would request you if you could like and rate my blogpost .

      Abhishek

      (0) 
    1. ABHISHEK DUTTA Post author

      Hello Nagesh ,

      Thank you for reading my blog and giving me a valuable feedback . Also would request you if you could like and rate my blogpost .

      Abhishek

      (0) 
    1. ABHISHEK DUTTA Post author

      Hi Anusha ,

      Thank you for liking my visualization and story about this very important topic which everyone needs to be aware of ! Yes SAP Lumira is definitely very useful for depicting my story . Also would request you if you could like and rate my blogpost .

      Abhishek

      (0) 
  2. KAUSHIK BASU

    Hi Abhishek!

    I went through your entire Blog-post and the
    effort is a very good effort towards CO2 emission Data acquisition and the
    associated graphics also are very logical and relevant.

    However, the young generation today has to
    realize a few issues. The world is well beyond the age of data acquisition and
    mining with respect to Carbon footprint. There is overwhelming amount of data
    available!! But what do we do with it if the human race is not willing to
    address it? Countries are busy doing politics over Carbon credits. So, going
    forward, you have to work as a large team of Computer Engineers making
    available the Data in the easiest form to Environmental Engineers who in turn
    can provide precise action plan for other Engineers such as Process, Mechanical
    and Electrical engineers to design systems accordingly.

    So, the moral of the story is that CO2 emission
    cannot be solved by any individual brilliance. Technology and Engineering is
    all about Team-work!     

    Regards,

    Kaushik

    (0) 
    1. ABHISHEK DUTTA Post author

      Hello Kaushik Basu ,

      Thank you first for reading through my blogpost and appreciating my work . Also thank you for your valuable feedback and liking my visualization and my large data set that is my big data and my story about this alarming issue . Yes I agree with your points and even I feel we need to work as a team . But this is the starting of a revolution and is a stepping stone towards success . But as you rightly said teamwork is very important but individually contributing would also help . It’s like “Little drops of water make the mighty ocean” .

      Thanks & Regards ,

      Abhishek Dutta

      (0) 

Leave a Reply