This is an Sales Analysis Dashboard created in Excel, visually representing sales data using various charts and filters. Below is a description of the key components of the dashboard:
Dataset Used in the project : https://www.kaggle.com/datasets/vishwas199728/adidas-sales-data?select=AdidasSalesdata.xlsx
Key Components:
- Retailers (Sales vs. Profit) Chart (Top Left)
- A combination of a bar chart and a line graph showing total sales and operating profit for different retailers such as Walmart, Amazon, Kohl’s, and more.
- Sales by State (Top Center)
- A heat map displaying sales distribution across different U.S. states, with darker shades representing higher sales figures.
- Filters (Top Right)
- Users can filter data based on:
- Year (2020, 2021)
- Region (Midwest, Northeast, South, Southeast, West)
- Sales Method (In-store, Online, Outlet)
- Users can filter data based on:
- Region-wise Sales (Bottom Left)
- A doughnut chart showing the percentage contribution of each region to total sales.
- Sales Trend (Bottom Right)
- A line chart illustrating sales performance over time from January 2020 to December 2021.
- Navigation Tabs (Bottom)
- Different worksheet tabs such as Sales_details, Pivot 1, State, and Dashboard suggest the presence of underlying data sources.
This dashboard helps in analyzing Adidas sales performance across different states, retailers, and sales channels, making it easier for decision-makers to identify trends and optimize strategies.