Business Intelligence Help Section
- Alaf Azam Khan
- Surya M
- Abhist Srivastava
Store Targets:
Store-level Revenue targets for every month. Used in reporting to compare the targets with actual achievement.
Category Key Sizes:
Specifies the required sizes in the Stock for a Style to be considered “Healthy”.
Column | Description |
|---|---|
SIZE_SET_1 | If a Store+ Style has all the sizes mentioned either in size_set_1 or size_set_2 for that category, it will be considered healthy. Used only for reporting purposes |
For Example, if the input is given as S, M, L and M, L, XL for a category, all the store style combinations in that Category having at least S, M, L or M, L, XL will be counted under healthy combinations.
Retail Calendar:
Defines the Retail week number to which days belong.
Column | Description |
|---|---|
RETAIL_WEEK | Week numbers to be used for reporting. Year on Year comparison for the same week number will be according to these numbers |
SEASON | Season to which the week belongs. Has to be one of the seasons present in the Style master |
EVENT | If the Retail week belongs to any event period (For Eg., Black Friday Sale), it can be mentioned here |
Buy Quantity:
In case the user wants to view sell through report against the buy and not dispatched (sales+stock on hand) then they can update this input at a style channel level, what was the seasonal buy quantity
Returns:
All SKUs should be in the SKU master
All store IDs should be present in Store Master
Revenue can not exceed (MPP*QTY Sold) and can not be 0 or negative.
The date should be in ‘yyyy-mm-dd’ format