excel_adidas_sales_2020_2021

Sales analysis of Adidas merchandise in US region from 2020 to 2021 Sales-Analysis for Adidas in US

*This is an excel interactive visualization project.

Sales Performance Analysis is an effective method to determine the sales progress over a period of time. The analysis allows us or sales team to identify the weak areas and what actions should be taken to improve the business performance over the period. It also provides several significant advantages to businesses and this includes identifying areas of improvement, tracking progress and profitable product line.

I analyzed this Adidas Sales dataset in csv format which I acquired from Kaggle website and conducted a Sales Performance Analysis to provide insights on this following business questions: • How is the company’s overall performance?
• What are the most profitable retailer for adidas?
• Which customers are the most valuable to the company?
• What region experienced the highest sales over the period?
• Which type of shopping method is more popular among the buyers?

Note: The data is from year 2020 to 2021.

Process
• Steps taken in this case-study-analysis include:
• Cleaning the dataset
• Creating pivot-tables to analyze a specific areas
• Data Visualization
• Making it interactive by adding slicers and linking with different visuals

The dashboard :

Outcome/Result of the analysis:

• West Gear is the most profitable retailer for the adidas company which sale the highest number of products. While Walmart and amazon has the lowest sale among all the retailers.
• The line chart shows that there is a trend of increasing sales from year 2020 to 2021 and the highest sale is reported in the month of July 2021 and December 2021 at approximately $78 million, on the other hand June 2020 has the lowest sale.
• The map shows the sales region in US where the maximum sale region is indicated by the dark green color and minimum sale is shown by the grey color. California sold the maximum adidas merchandise.

• Lastly, the donut chart reflects that in-store is the most popular method of sale at 40 % among the buyers followed by the outlet at 33%.

Reference : https://www.kaggle.com/datasets/heemalichaudhari/adidas-sales-dataset