I was always curious to know more about the automotive industry spread across the world. Brands and automotive groups interested me a lot. Now, SAP Lumira has given me a platform to present the findings in a pictorial format. In this blog I have tried to show automotive manufacturing trends  using the results I got from SAP Lumira. I have tried to explore the number of vehicles manufactured in the world for the past few decades and mapped down the trend of production of various category of vehicles. The countries leading in manufacturing are also been mapped and results are presented in various forms using tables, pie charts, line graphs etc. The findings are based upon the data which is taken from Wikipedia.

This research led me to find out the answers for the following important questions:

          1) Which brand has manufactured the highest number of vehicles in 2012? (Top Brands)

               i) We were also able to find out who was the highest manufacturer of Car, LCV, HCV and Heavy Buses across the globe for the year 2012.

          2) Which country has been the highest manufacturer of vehicles in the year 2012?

               i) We can find the production trends across the past few decades.

Intially, let’s have a look at the trend of yearly total production from 1997-2012. This has been demonstrated by the bar chart and a radar chart below, with Y-axis being the production in millions and X-axis being the years from 1997 to 2012.

/wp-content/uploads/2014/01/1_356548.jpg

/wp-content/uploads/2014/01/2_356558.jpg

Line graph depicts a better picture of this trend along with another variable included-(percentage change in production yearly).

/wp-content/uploads/2014/01/3_356559.jpg

After getting the picture of total yearly production , I wanted to refine the search a little more. I was more curious on knowing the Vehicles manufactured by each group and then conclude which group has manufactured maximum number of vehicles in the year 2012(Statistics were available till 2012). Below are the details of production for top 20 Automotive Manufacturing Groups.

Below chart shows the total production by each Group in the year 2012:

/wp-content/uploads/2014/01/4_356560.jpg

Pie chart explains the share of each group in the total production for 2012 in a better way:

/wp-content/uploads/2014/01/5_356561.jpg

Vehicles are classified into four basic types based on their use. They are

i) Cars (Cars, SUV’s, MUV’s)

ii) LCV (Light Commercial Vehicles)

iii) HCV (Heavy Commercial Vehicles)

iv) Heavy Buses

Now the need arose to bifurcate the total production of each group in 2012 into these types.

The total production was bifurcated into various vehicle types and the graphs were plotted using SAP Lumira. The results are as below:

This bar chart explains the bifurcation for each group in the year 2012.

/wp-content/uploads/2014/01/6_356562.jpg

SAP Lumira provides powerful tools to make the visualization more explanatory and easy to understand. This is explained by another chart alternative to the above one.

/wp-content/uploads/2014/01/7_356563.jpg

Isn’t it explanatory enough? This chart provides a better visual of the bifurcation of total production of each brand recorded in the year 2012.

Now based on the total production of each brand I simulated a Tag Cloud which looks as below.

Classifying the groups according to the number of vehicles manufactured.

/wp-content/uploads/2014/01/8_356564.jpg

Then I also simulated the top 10 Car, LCV, HCV and Heavy Bus manufacturers using SAP Lumira.

I got the following results:

1) CARS

/wp-content/uploads/2014/01/9_356565.jpg/wp-content/uploads/2014/01/10_356566.jpg

2) LCV

/wp-content/uploads/2014/01/11_356567.jpg

/wp-content/uploads/2014/01/12_356568.jpg

3) HCV

/wp-content/uploads/2014/01/13_356569.jpg

/wp-content/uploads/2014/01/14_356570.jpg

4) Heavy Bus

/wp-content/uploads/2014/01/15_356571.jpg

/wp-content/uploads/2014/01/16_356572.jpg

Total production made in different Countries is also an important trend to note about. I have made an analysis for the same.

I have made a graphical representation of the total production for the Top 20 leading countries (Number of vehicles manufactured) based on the statistics for the past few decades. Below graph represents the same.

/wp-content/uploads/2014/01/17_356573.jpg

Y-axis represents the production in millions and X-axis represents the countries. The colours represent the years.

Based upon the production statistics for the year 2013 the top countries are represented by the Tag Cloud shown below.

/wp-content/uploads/2014/01/18_356574.jpg

The same is represented by a Geo Bubble Chart as Below :

/wp-content/uploads/2014/01/19_357331.jpg

Based upon the analysis following things could be concluded.

1.       2012 recorded the highest production of automobiles in history.

2.       Years 2008 to 2009 experienced a drastic fall in production. An abrupt rise is observed in production from 2009 to 2010.

3.       Toyota was the leading manufacturer of automotive vehicles in the 2012 with a total of 10104424.

4.       Volkswagen was the top manufacturer of cars with a total of 85,76,964 in 2012.

5.       GM has topped the list in the number of LCV’s manufactured with a total of 26,58,612 in 2012.

6.       Isuzu was the leading manufacturer of HCV’s with a total of 5,65,617 in 2012.

7.       King Long was leading in the number of Heavy Buses manufactured with 41775 units manufactured in the year 2012

8.       In the year 2012 China has superseded other leading countries like USA and Japan by manufacturing highest number of vehicle units. 

9.       Top three countries being China, USA and Japan respectively.

To report this post you need to login first.

13 Comments

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

  1. Irshaad Bijan Adatia

    Kishor,

    Great post!

    It’s great to see how you used many different types of visualization to display data.

    I was hoping to see a geo chart!! They’re one of my personal favourites…

    Would you be able to share the link to the data that you used?

    Lumira makes it very easy to consume such data, looking at the difference in countries and having China’s 2012 data SPIKE! *exciting* 😎

    Looking forward to many more great posts!

    Bijan

    (0) 
    1. K P Post author

      Hi Bijan,

      Thanks for your constructive comments, I have updated the blog with a Geo Bubble chart.

      🙂

      Thanks,

      Kishor

      (0) 
  2. ricardo Huarte

    amazing work!

    If it is not too much trouble, would you share your dataset, i tried to generate it myself using the sources you mentioned but i ended up with just countries and types of cars but not the motor companies.

    I would greatly appreciate it.

    and again, great work, 😎

    (0) 
  3. ronald farmer

    It is really informative article and graphical depiction of all the major car companies and their production rate is very appreciable. At present a race is going on among different cart manufacturers to service better than all. It is really hard to say who is leading but interesting thing is that this competition has become beneficial for customers as they have extensive selections to choose the best. Extent of automobile industry is not limited merely to car manufacturer companies but it ranges up to designing, marketing, selling departments as well as service centers, auto part dealers and maintenance team. 

    (0) 

Leave a Reply