I created Excel sales data dashboard.
Metadata :- Segment, Country, Product, Discount Band, Units Sold, Manufacturing Price, Sale Price, Gross Sales, Discounts, Sales, COGS, Profit, Date, Month Number, Month Name, Year.
The Dashboard includes following insights
- Sum of profit for every country and their share with piechart
- Sum of sales for every country and their share with piechart
- Sum of unit sold for every country and their share with piechart
- Total unit sold per year with ring chart
- Productwise total unit sold
- Productwise count of discount given
- Productwise total discount given 8)*** Totsl sale of product for every month - (Help in identifying season demand)
- Total discount given per month
- Total discount given per year 11)*** Cost effectiveness of the product