Table of Contents
The main goal of this project is to answer the following questions; "Which manufacturers were top based on the number of cars sold?", "What was the most purchased transmission?" and "Which manufacturers were top based on the total selling price of cars sold?".
This analysis takes place between 2010 and 2020.
Credibility Criteria
The cars were classified into 4 fuel types:
- Petrol
- Diesel
- LPG
- & CNG
In this analysis I consider car sales to be credible if they were either petrol or diesel cars
The data source I am using is the Excel file which I obtained through the database website Kaggle.
I believe this data to be reliable because firstly, the data was sourced from www.cardekho.com which is India's leading car search venture that helps users buy cars that are right for them. Its website and app carry rich automotive content such as expert reviews, detailed specs and prices, comparisons and videos/pictures of all car brands and models available in India. A bunch of young, enthusiastic IT graduates set up the website. Its investors include Google Capital, Tybourne Capital, Hillhouse Capital, Sequoia Capital, HDFC Bank, Ratan Tata and Times Internet.
The key variables I want to analyse within this project are as follows:
- Number of cars sold per manufacturer
- Value of total cars sold per manufacturer
- Number of cars sold per transmission
My data contains:
- Manufacturer - String
- Model- String
- Year - String
- Selling Price - Floating Pointing
- Km Driven - Integer
- Transmission - String
- Owner - String
- Engine - Floating Pointing
- Seats - Integer
I want to first use a bar chart to visualise the manufacturers with the most number of cars sold. Then I want to use a treemap to visualise which suppliers generated the most in selling price. Finally, I used a pie chart to show the split between manual and automatic transmission.
To collect the data used for this analysis I downloaded an Excel file from the Kaggle website from a dataset called "Car Details Dataset".
First I added a filter on the data which would allow me to easily spot unique values within columns. I then converted the selling price and Km-driven columns to numbers and used =COUNTBLANK in column N with a range of A:M to locate any rows with blank cells. Once I had located these blank cells I removed those rows of data to ensure I had the most information possible when creating my visualisations. I then added 2 columns before column B and used =LEFT(A2,FIND(" ",A2)) in cell B2 to pull through the manufacturer name from the Name column, I also used =MID(A2,LEN(B2)+1,LEN(A2)-LEN(B2)) to pull through model. I dragged these formulas down so that they covered the entire dataset. After this, I filtered on years before 2010 and deleted them as my scope was 2010-2020. I also removed fuel types that weren't either petrol or diesel because petrol and diesel cars have historically dominated the automotive market. Analysing these types provides a comprehensive understanding of the majority of vehicles on the road, making my analysis relevant to a larger audience. I then removed the rows relating to test-driven cars as I only wanted to include cars that were sold.
Using a pivot table I put the manufacturer in the row and put the count of manufacturers and the sum of selling price in the values fields. Using the MAX and Min formulas I pulled through the max and min count of manufacturers and the sum of the selling price which showed me that Maruti had the highest number of cars sold (1902) with the highest total selling price (899,623,919.00 rupees) and Ashok sold the least amount of cars (1) with the lowest total selling price (300,000.00 rupees).
![Car Details Dashboard 1](https://private-user-images.githubusercontent.com/139594033/309506358-709584e2-e96b-4b96-985a-70ee4e95a6ca.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjU3MDY1ODAsIm5iZiI6MTcyNTcwNjI4MCwicGF0aCI6Ii8xMzk1OTQwMzMvMzA5NTA2MzU4LTcwOTU4NGUyLWU5NmItNGI5Ni05ODVhLTcwZWU0ZTk1YTZjYS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwOTA3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDkwN1QxMDUxMjBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT02ODljZDIwMjgzZDM4NDgzZDhhYmY4OTE1NDUxNzJmZmZmOWRlODRmOTdjNTNlNmI2ZGU3ZmI3NmU4NjUwMjY1JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.mO7iZ5J69V-HlGyKGdzfNOvJtxuHu7238AJCi6LfvGg)
Within the dashboard are 3 graphs; 'Number of cars sold by Manufacturer', 'Manual vs Automatic Transmission' and 'Total selling price by Manufacturer'. The 'Number of cars sold by Manufacturer' shows us that Maruti sold the most cars (1,902). This answers the first question "Which manufacturers were top based on the number of cars sold?".
To answer the second question; "What was the most purchased transmission?", we have to look at the 'Manual vs Automatic Transmission' graph. This graph shows us that out of the 6,875 cars sold, the majority of those cars (86%) were manual transmission while only 14% were automatic transmission.
To answer the final question; "Which manufacturers were top based on the total selling price of cars sold?", we can use the 'Total selling price by Manufacturer' graph. This graph shows us that the manufacturer Maruti had the highest total selling price (899.62 million rupees).
Firstly, by looking at the 'Number of cars sold by Manufacturer' we can see that Maruti; an Indian subsidiary of Japanese automaker Suzuki sold the majority of cars during the period. The reasons for this could be the following...
- Affordability and Value for Money
- Strong Brand Loyalty and Trust
- Efficient After-Sales Service
- Government and Regulatory Support
- Local Manufacturing and R&D
Maruti Suzuki offers a wide range of cars that cater to various price segments, providing value for money with competitive pricing, fuel efficiency, and low maintenance costs. This makes their cars attractive to a broad demographic.
Over the years, Maruti Suzuki has built a strong reputation for reliability and trustworthiness. Many Indian families have owned Maruti cars for generations, fostering brand loyalty.
Maruti Suzuki’s extensive service network ensures that customers have easy access to maintenance and repairs. The availability of spare parts at affordable prices further enhances customer satisfaction.
Maruti Suzuki has benefited from favourable government policies and regulations, including initiatives promoting the manufacturing sector and incentives for small cars, which form a significant part of their lineup.
Maruti Suzuki's strong local manufacturing presence and investment in research and development allow them to produce cars tailored to Indian conditions and preferences, ensuring competitive pricing and better market acceptance.
These above factors collectively give Maruti Suzuki a significant edge over its competitors in the Indian automotive market.
Car Details Dataset