BI reports summary
In the dashboards menu, we have different reports available, each of which is explained below.
KPI Reports
Give access to the most relevant business information and offer different display options related to sales, stocks, coverage, and stockouts.
Here below are the definitions of the KPIs displayed in the different dashboards:
- Absolute stockouts: % of sizes with 0 stock in a store compared to the total number of sizes bought to be in the store.
- Real stockout: This measures when a product is not available in the store, but it is available in the warehouse. Real stockouts are those that could have been replenished.
- Coverage: Measured in weeks and calculated as the ratio between stock and sales for the last 28 days, multiplied by 4.
- Sell-out: Units sold divided by units purchased (global indicator at company level).
- Sell-through: Units sold divided by units received (indicator at store level).
- Transit stock: SKU that the store will receive from the warehouse or from another store in the following days.
Top Products
The Top Products report provides quick access to key operational insights that support daily business decisions. It ranks product by sales value, from highest to lowest, helping you identify your best-performing items at a glance.
Product Treemap
Product treemap shows information on the number and % of units sold by product family in the last 7 days.
Store Treemap
The treemap works in exactly the same way as we saw in product treemap, the only difference is that it can be seen by cities with full detail by store. This report provides the % units sold at store level in the last 7 days.
Top Stores
This report allows managers to find information at store level from a specific set of stores. The information is displayed on cards with a listing option.
Zero Sales
Zero Sales lists the country best-selling products in the stores that have had zero or minimal sales of those products in the last seven days.
Ghost Stocks
This shows the list of products that have moved from having strong sales to not being sold at all in the last 7 days, despite being in stock.
Top Sales
The report lists the 100 top-selling products in the store over the last 14 days but is a report only configured for store users. Managers can view the information from Top Products
This helps to:
- Identify most-sold products
- Manage stock replenishment in store
Top Stockouts
The best-selling products in the store (top 100 in the last 30 days) listed or sorted by stockout level. It is a report configured by default for store users because managers can view it from Top Products.
The store can use this report to:
- Identify products to replace/relocate if the minimum display is not enough
- Request special replenishments from warehouse
Disaggregated Info
This report is useful to analyze the whole list of product- store or vice versa sorted by store stock, real stockout, coverage etc. This information helps decisions to be made in the future about discounts, block codes for replenishment, or store transfer scenarios etc. The report allows data to be downloaded in excel to make a thorough analysis.
