Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to develop a sales performance application to be used in a supermarket.. I want to get an idea what are the report types to be used..
If you have any idea or any sample application please share with me.
Thanks and Regards,
Nilupa
anybody don't have experience in this.........???
anybody don't have experience in this.........???
Hello,
any amount. Let's start with what basis information you have available.
Do you have sales per product and store? If yes, over what periods? Weekly, monthly, quarterly, etc.
Do you have price per product, units sold, $$ sold, VAT?
Any information about placement of products, restocking levels etc etc? Amount of linear meters/ cm used by a product.
Tell me what you have and we can figure some KPIs.
Regards,
Petra
Hi
Thanks ...
I want to know what kind of reports are used for sales analysis in supermarkets? are there any special analysis?
for an example market basket analysis... are there any other things?
Regards,
Nilupa
Dear Nilupa,
on demo.qlik.com one sales application available name is QT sales Demo YTD. it will help you .
Regards
Sunil
Hi,
things that are interesting:
Cost of Inventory at cost and at retail, Days of supply by product, out of stock levels, returns due to overstocking (especially in the white lines), % of sales to total category, also on brand / manufacturer / sub cat basis - things like that.
Then over all or department: category comparisons, space to sales / profit / margin analysis, customer frequency, direction of movement of customers past category ... and of course, time comparisons. YA, YTD, Quarters, different yearly periods... etc.
The list is endless. It depends what you are wishing to achieve and the granularity of your data. It can be for Assortment analysis, category management, marketing and research institutes ... you need to define your audience.
Hope this helps.
Petra.
Thank u all for the ideas!!! 🙂