Car Sales Analysis Using Excel

The business case for this project was to analyze car sales data and uncover insights that could be used by salespeople and dealerships to improve sales strategies and increase revenue.

One of the key insights was that May had the highest number of cars bought, suggesting a possible seasonal trend in car sales. This information could help salespeople and dealerships to adjust their inventory and marketing strategies accordingly.

Honda, Ford, and Chevrolet emerged as the most popular car makers among buyers, which is a valuable insight for both dealerships and manufacturers. This information can be used to tailor marketing efforts and promotions for these specific brands, potentially leading to increased sales.

The analysis also revealed that the Silverado model proved to be the most lucrative in terms of commission earned for salespeople. This information could be used to incentivize salespeople to focus on selling this model, potentially increasing their earnings.

Furthermore, the 2020 Silverado model had the highest number of buyers, indicating its potential profitability for dealerships. This information could be used to adjust inventory levels and pricing strategies to take advantage of the popularity of this model.

The Corolla model had the highest sale price, which could be of interest to both buyers and dealerships. This information could be used to adjust pricing strategies and promotions for this model, potentially increasing sales and revenue.

Overall, these insights could have a significant impact on the sales performance of dealerships and the earnings of salespeople. By tailoring their strategies and focusing on the most popular and lucrative models, dealerships and salespeople could potentially increase their revenue and profitability.

The link to the interactive dashboard is https://docs.google.com/spreadsheets/d/1ib1FGnN5rMmNyvBjz4FsY0hy1XfQ48xw/edit?usp=share_link&ouid=104067697630711976834&rtpof=true&sd=true