Problem Statement A US Based Ecommerce Sales Company wants us to create a Sales Dashboard showing information of YTD Sales and generate insights for below scenarios-
1.Create a KPI Banner showing YTD Sales, YTD Profit, YTD Quantity sold, YTD Profit Margin
2.Find Year on Year growth for each KPI and show a YTD sparkline for each measure in the KPI to understand the monthly trend for each fact.
3.Find YTD Sales, PYTD Sales, YoY Sales growth for different customer category. Add a trend icon for each category.
4.Find YTD Sales performance by each State
5.Top 5 and Bottom 5 Products by Sales
6.YTD Sales by Region to know best and worst performing region all over country
7.YTD Sales by Shipping Type to get the best shipping type percentage