Skip to Content
Author's profile photo Former Member

Data Geek Challenge : The Cause and Effect of Increase in Motor Vehicles

With the excitement of Data Geek challenge and by seeing a lot of blogs about SAP LUMIRA on SCN I made up my mind to post one 🙂 , but choosing the topic was a difficult task 🙁 . Recently after becoming an owner of a 2 wheeler vehicle I got interest to blog in the field of motor vehicles. So I made this simple analysis using LUMIRA.

To start off I began collecting data from http://data.gov.in and http://databank.worldbank.org/data/home.aspx

Then I came up with a structure for the blog as :


1. Analyzing the Increase in number of motor vehicles

2. Cause of this increase.

3. Effect of this increase.

First I visualized the state wise increase in number of motor vehicles in India within a span of 10 years(2001-2011) using 2D Column chart

Capture.JPG

and within a span of 5 years using a 3D column chart as below

3d.JPG

I can also compare the states based on number of vehicles easily with the help of Geo Bubble Chart as shown

geo chart.JPG

     Now I thought about the cause of this increase in number of motor vehicles. The first thing which came to my mind is Increase in the population, although there are various other factors. So as soon as I got the data on adult population I began to visualize it against the motor vehicles.  I did this using the Line charts

popu1.JPG

     I found the above chart very interesting because the increase in both the indicators i.e, adult population and number of vehicles seemed to be same. So I visualized it in a more detailed way by removing the Year from the X-axis in the Dimensions section and placed it in Legend Color field. After doing this I was surprised to see the chart as below where all the lines are parallel to each other 🙂

popu.JPG

Now its time to think about the effect of this increase in motor vehicles. Apart from the luxury we get two things which are worth considering they are

  1. Emissions from the vehicles
  2. Road Accidents

After collecting the data for the CO2 emissions I was searching for some representation other than what i used until now. Then i found this cool chart called Radar Chart which is shown below.

co2_1.JPG

The good thing to observe in the above chart is that the gap between the number of vehicles and CO2 emissions has decreased in 2010 when compared to 2001. But the actual amount of CO2 emissions increased significantly from 2001 to 2010

Next is the number of road accidents. I found that better to visualize using a simple column chart as below for years 2001 and 2010

accidents.JPG

A very good thing to observe in the above chart is that in the year 2001 the number of accidents are almost 75% of number of vehicles. Whereas in 2010 the number of accidents are very much less than 50% of the number of vehicles also just little more than the accidents in 2001.

I also analyzed state wise road accidents as shown below using a different chart called the Tag cloud where the visualization of the data is very clear and easily understandable.

acc.JPG

Finally to conclude this blog all I can say is that the effort put for this analysis is to make the reader understand the effects of increase in motor vehicles and think up a solution to reduce the emissions and save the environment as well as reduce the road accidents to the least possible as ones’ life is very important 🙂 .

Also Thank you for finding time to read this 🙂

Assigned tags

      39 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ganugapenta Pradeep Kumar
      Ganugapenta Pradeep Kumar

      Good Analysis Vamsi 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you 🙂

      Author's profile photo Former Member
      Former Member

      nice analysis vamsi, specially after using a two wheeler in a crowded city 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      haha ty 🙂

      Author's profile photo Former Member
      Former Member

      thanks for sharing ...

      Author's profile photo Former Member
      Former Member

      nice analysis man...keep it up 🙂

      Author's profile photo Former Member
      Former Member

      Good analysis and a great start in blogging..   Liked the idea of this subject...

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      thankyou Durgamadhab Mishra 🙂

      Author's profile photo Jitendra Kansal
      Jitendra Kansal

      fantastic.. great data analysis . 🙂

      Rgrds,

      Jitendra

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Jitendra Kumar Kansal 🙂

      Author's profile photo Former Member
      Former Member

      good visualization of data vamsi 🙂

      regards

      lakshmi

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      ty lakshmi 🙂

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      Excellent analysis Vamsi. The rise of adult population leads to rise in vehicular traffic. One more reason for the governments to invest more in public transportation.

      Regards,

      Vamsi

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      ty vasanth fr reading 😀

      Author's profile photo Former Member
      Former Member

      Hi Vamsi,

      Nice work! keep it up.

      Regards,

      Hari Suseelan

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      ty fr reading Hari 🙂

      Author's profile photo Former Member
      Former Member

      Hi Vamsi,

      You are most welcome.

      Have a wonderful day!

      Regards,

      Hari Suseelan

      Author's profile photo Former Member
      Former Member

      Good Blog, really appreciate the analysis done, how much time did you invest in getting all these details & then put in charts.

      On the other side it not an individual  who can reduce the rising pollution ,its a combined efforts. what i have been hearing was of car pooling but i saw very few using it need or use public transport. For going nearby one needs a walk or a bicycle which is what i have been for the last 4 years.

      Thanks for sharing vamsi. Sukant Chakraborthy

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      it took me a lot of time for gathering and arranging the data may be 2 or 3 days...after tht it was all very fast 🙂
      Also if every individual do their part thn only it will become combined effort 😀

      Yeah carpooling is a good option and we cant use cycle for long distances.
      thankyou for reading 🙂

      Author's profile photo Former Member
      Former Member

      Good posting Vamsi. You increased its usage after buying a bike 🙂 .

      SAP LUMIRA on SCN I made up my mind to post one 🙂 , but choosing the topic was a difficult task 🙁 . Now you are riding this task.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Yeah i didnt realize the effects of increasing vehicles at the time of buying 🙁 ..
      ty for reading kumar 🙂

      Author's profile photo rajesh bethamcharla
      rajesh bethamcharla

      Good Analysis..keep it up.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      ty rajesh 🙂

      Author's profile photo Modadugu Hemanth Kumar
      Modadugu Hemanth Kumar

      Thanks for sharing Vamsi.

      Author's profile photo Former Member
      Former Member

      Hi Vamsi,

      ''The rise of population leads to rise in traffic." really appreciate the analysis.

      Effective visualization of data.

      Thanks for sharing...

      Kind regards,

      Khushi

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks kushi 🙂

      Author's profile photo Prashanth konduru
      Prashanth konduru

      Good analysis and thanks for sharing ....

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Prashant 🙂

      Author's profile photo Anson Abraham
      Anson Abraham

      Hi vamsi krishna reddy kakuru,

      Nice analysis. Keep posting 🙂

      Regards,

      Anson

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      thank you John 🙂

      Author's profile photo Former Member
      Former Member

      You have so much  patience and gathered many information...

      You did Great job.....

      Regards,
      Chandrakanth.

      Author's profile photo Suvonkar Bashak
      Suvonkar Bashak

      Hi Vamsi,

      Very good analysis, it was a nice read.

      Regards,

      Suvonkar

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks suvonkar 🙂

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj

      Good blog Vamsi

      Nice analysis

      Regards,

      Vivek

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks vivek 🙂

      Author's profile photo Former Member
      Former Member

      Excellent Analysis & Posting.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks niloy for reading 🙂

      Author's profile photo Binish Gole
      Binish Gole

      Very Good Analysis and even better way of representing it, its like reading a well crafted book where each nod is linked on another and building interest of the reader...

      Good Job!!!

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks a lot binish. I actually took a break from scn ..your appreciation is very encouraging  to make a comeback 🙂