Grocery Store Dashboard

Grocery Store Report Action Points:

Transaction Report:

1. From the KPIs, we can see that there is a 5% Increase in Revenue, Profit, Quantity & Transaction in the Last Month in comparison to Previous Month but we can also witness 5% Cost increase.

Hence, there is no actual growth in the Business of Grocery Store considering last month performance

2. Prior to Jan 1998, the Grocery Store was limited to US Market, but from 1998 as Market expanded to Mexico & Canada, there is an upward shift in magnitude of the trend in terms of all parameters like Revenue, Profit, Quantity Sold, Transaction as well as Cost in actual terms but Profit Margin wise there is no change, it was 60% in 1997 and also 60% in 1998

3. We can have an Idea of the Best & Worst performing Product & Store from the Report and take actions accordingly

Product Report:

From Product report we can have a good idea about specifications of Grocery Store Products Brands & Products

Customer Report:

We can find the most important factors effecting customer base of Grocery Store, that are, has_children and Member_Card

Hence, for Marketing purpose with resource constraints, Customers having children and having Bronze Member Card can be targeted

Return Analysis:

The Products & the Store from where the Products are returned frequently can be identified from the report.

Hence necessary actions can be taken like Quality checking of Products, Store environment etc.

Return Analysis:

1. The Products & the Store from where the Products are returned frequently can be identified from the report.

Hence necessary actions can be taken like Quality checking of Products, Store environment etc.