Ujjaval Rana

Sales Analytics Dashboard Business Need is to improve management of efficiency by tracking different KPIs Since this business is handling more than 1000 products and 500 customers they need to keep track of different performance indicators for developing new strategies and keep track of target achievements. Data range is From 2019 to 2021 August Major comparison parameter for business is 2019 sales since 2021 growth will be difined on basis of 2019 sales since in 2020 business was affected due to covid-19 Different KPIs are  Top Selling Items   Top 10 Customers by Sales  Item Segment wise Growth vs 2019 (more then 1000 items Segmented in 14 )   YTD Sales Top 10 Profitable Customers Item Total Qty sales tracking This Dashboard is completely dynamic user has control over data filters and it has auto update facility for keeping up to date with new data Also for detailed review - sales data of Top 50 Customers is also linked in dashboard tab Note: Customer Name is hidden in Image. Thank You For Reading. .