topic Sales performance application for a Supermarket in QlikView

Sales performance application for a Supermarket

Thu, 16 Sep 2010 09:57:00 GMT

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

Sales performance application for a Supermarket

Thu, 16 Sep 2010 12:33:21 GMT

anybody don't have experience in this.........???

Sales performance application for a Supermarket

Thu, 16 Sep 2010 12:35:44 GMT

anybody don't have experience in this.........???

Sales performance application for a Supermarket

picturebox — Thu, 16 Sep 2010 13:00:36 GMT

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

Sales performance application for a Supermarket

Fri, 17 Sep 2010 04:39:13 GMT

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

Sales performance application for a Supermarket

suniljain — Fri, 17 Sep 2010 08:09:10 GMT

Dear Nilupa,

on demo.qlik.com one sales application available name is QT sales Demo YTD. it will help you .

Regards

Sunil

Sales performance application for a Supermarket

picturebox — Fri, 17 Sep 2010 08:49:08 GMT

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.

Sales performance application for a Supermarket

Fri, 17 Sep 2010 09:58:47 GMT

Thank u all for the ideas!!! 🙂