Store

In the company, the whole sales analysis process was done manually using the erase-rewrite method in their style sheets to update the sales data after evaluating the heavy-looking excel data and then used to determine the best and poor seller products within a span of time.

The Manthan Dashboard only provided them with the overall sales of the multiple store outlets and the total sales of the Ladies Ethnic Wear. Hence, Analysing the Sales performance within the brand was difficult at the category and article level.

So, we transformed this traditional process by developing an Interactive Excel Dashboard using VBA coding and excel formulas which is dynamic in nature and depicts the best and poor seller product information with a single click. With the help of the dynamic dashboard, we have developed the range for SS’22 (HIT 2). The main findings were that we can easily analyze the sales performance of the previous year and plan for the next year. The result of this project was very fruitful and due to the dynamic nature of the dashboard, it can be implemented into any company by manipulating the source data.