Adidas Sales and Distributors Performance Dashboard
The dataset for this dashboard is available from public dataset repository Kaggle: [https://www.kaggle.com/datasets/heemalichaudhari/adidas-sales-dataset/data ](https://www.kaggle.com/datasets/ahmedabbas757/dataset)
This project was divided into two parts- sales performance dashbaord and individual retailer performance dashboard. New AI tools like Q&A and Key influencers were used to make the dashboard more interactive and understand the key drivers behind operating profit.
We were able to answer the below questions through visualization:
- Which is a better performing channel in terms of profit and sales volume? What is the distribution of these channels among the different retailers?
- How can we rank the product assortments along best selling and most profitable parameter?
- What is the most profitable region for Adidas by Sales and Profit Margin and which region requires attention?
- What is the product assortment, profit margin and contribution of each individual retailer (through DAX)?
- What is YoY trend for each retailer on profit, revenue, sale volume (through DAX)?
- How do the retailers perform on important KPIs like revenue and Sales Volume? Locate them in a range and compute the average?
- Calculate the Sale Volume and Profit Margin (through DAX) for each retailer?
- Calculate Profit Margin % by Sales Method, Region, State and City for each retailer.
- Do a Product Profitabiility Analysis (Profit Per Unit through DAX) and draw an average Sale Volume flow in a week through DAX?
- Do a revenue-trend analysis for each retailer.