Adidas wants to create an annual sales report for the year 2021. Adidas can understand it's customers and grow sales in 2022.
- Compare the sales and orders using a single chart.
- Which month had the highest sales and orders?
- Which region has the highest sales and profit?
- List the top 5 states with the highest sales?
- List the bottom 5 states with the lowest sales?
- Which retailer is contributing to maximum sales?
- Data Cleaning: Check whether any null values are present or not, and check for the formats as well.
- Data Processing: Transform the data to achieve the target.
- Data Analysis: Analyze the data and create charts out of it using a pivot table.
- Interactive Dashboard: Create a dashboard using the charts created using the pivot table.
- Insights: Share the insights with the clients and stakeholders.
- Sales Ranking by Month:
July has the highest sales. August has the second-highest sales. December has good sales as well, but it is not specified as the exact ranking.
- Regional Sales and Profit Ranking:
The West region has the highest sales. The Northeast region follows the West region in sales. The West region also has the highest profit. The Northeast region follows the West region in profit.
- Top 3 States by Sales:
New York is the state with the highest sales. California has the second-highest sales. Florida ranks third in terms of sales.
- Bottom 3 States by Sales:
Nebraska has the lowest sales among the states mentioned. Minnesota ranks second-lowest in terms of sales. Iowa is third-lowest in sales.
- Top 3 Retailers by Sales and Profit:
Foot Locker is the retailer with the highest sales. Sports Direct follows Foot Locker in sales and profit. West Gear is another retailer in the top 3 for both sales and profit.
