Automobile Sales Report

Introduction:

In this article, we'll analyze into the sales data of automobile manufacturer products. Our analysis will focus on the period from early 2003 to middle 2005, aiming to uncover key insights. The dataset used for this analysis is sourced from Kaggle and is titled "sampledataset(dot)CSV".

Case Study Scenario:

Assume management tasked data analyst with this questions:
1. Management wants to review the overall sales performance for the whole period (2003 to mid-2005).
2. Management wants to examine the specific sales performance for the year 2004.
3. Management wants to view the sales data for specific countries, such as countries in the Asia Market.

Answer:

1. View overal sales data:

From the executive summary, total sales amounted to $716 million over the period, with 99,000 units sold with 2823 partners all over the globe. Sales trend appears to be fluctuating, with noticeable peaks in November 2003 and November 2004, reaching $78 million and $75 million, respectively. But it steeped down in December 2004 and December 2005, which may indicates the seasonal trends, year-end budgets from the partners, or even year-end clearance of their inventory.

The United States (USA) emerges as the top-selling market, generating $258 million in sales, followed by Spain ($84 million), France ($78 million), Australia ($45 million), and the United Kingdom ($35 million). This indicates key markets for the company's products and potential areas for further investment or focus. For the product type, Classic cars are the top-selling product category, with 34,000 units sold, followed by Vintage cars with 21,000 units. On the other hand, trains represent the lowest-selling product category, with only 3,000 units sold.

2. Sales in 2004:

In 2004, sales reached $335M, with 46K units sold. The peak sales occurred in November 2024. The top markets were the USA and Spain, with Germany notably emerging as a significant market with sales of $13M for the year, compared to $17M for the entire period. The product type and deal size exhibited a relatively similar pattern compared to the entire period.

3. Sales in Asia Market:

We can use the filter country.

There are three Asian countries in the market: Singapore, Japan, and the Philippines. Their sales are as seen below:

In the Asian countries, sales amount to $39M with a quantity sold of 5563 units. Their peak sales month occurs in October, slightly different from other markets mentioned previously, which peak in November. Singapore leads as the top market with sales of $15.9M, followed by Japan and the Philippines with sales of $11.1M and $7.8M, respectively. Classic cars dominate in product type, but the second most ordered category is trucks and buses, indicating a notable demand for this type.