Dashboards

This Excel template is built to help the user keep track of the inventory in their retail outlet. The user can add the products and other relevant details as per their business and, it will populate the graphical representations and figures in the dashboard sheet to give an analytical insight into the business.

The sheet has two tabs. The first one is the dashboard, where all the analytical visual populates as per the data provided. This dashboard will be very useful to the store manager and other stakeholders to understand how much inventory is delivered and how much delivery is returned of in the store in a particular month, year, specific customer, or product. The second one is the data tab, where the user needs to feed the data to have an insight into their retail store business. In the data tab, there are switches through which the user can change the data as per their business needs.