topic Re: KPI Ideas in QlikView

KPI Ideas

shyamcharan — Fri, 02 Oct 2015 11:32:00 GMT

Hi Experts,

I have the Products, Orders, Order Details, Customer, Employee tables as in the attachment.

Can you please suggest the possible Key Performance Indicators from the available tables/Fields.

Thanks in advance and I appreciate your help.

Regards,

Shyam.

Re: KPI Ideas

MK_QSL — Fri, 02 Oct 2015 12:07:38 GMT

1) Number of Customers

2) Number of Orders Received

3) Total Sales Value

4) Average Sales Value per Order.. Per Month... Per Year

5) Total Qty Sold

6) Average Qty Sold Per Order

This data model is more than enough to create a Nice Looking Dashboard and QV app with many tables, charts and KPIs...

* Top 10 Orders, Top 10 Customers.... Etc

* Number of Customer lost wrt selected year... i.e. Customers buying last year but not this year

* Number of new customers

* Comparison of Sales this year vs last year... this month vs last month etc

* top 10 Salesman

* Line chart showing MonthYear vs Sales

Re: KPI Ideas

Fri, 02 Oct 2015 12:10:56 GMT

I also like putting inforamtion on my dashboard that also tells me negative information, such as bottom 10 orders, customers, etc - thais can tell you what is not selling, which customers are not giving you a lot of business, etc.

you can also include average order price

Re: KPI Ideas

Anonymous — Fri, 02 Oct 2015 13:02:02 GMT

Hi Shyamcharan,

Sales Growth

Sales Opportunities

Product Performance

Sales Target

Average Purchase Value

Sales Bookings

Customer Retention

Customer Satisfaction

Cost of Goods Sold

Incremental Sales

Average Purchase Value

New/Loyal/Old/Returned Customers.

New/Cancelled Orders.

Regards

Neetha

Re: KPI Ideas

Anonymous — Tue, 06 Oct 2015 02:32:17 GMT

Thanks heaps guys.

These helped me a lot in understanding what can be built just based out of a few tables.

Thanks a ton!!

Regards,

Shyam.

Re: KPI Ideas

Anonymous — Tue, 06 Oct 2015 04:59:19 GMT

Hi Shyam,

Please close the thread by marking correct answer,so it maybe helpful to others.

Re: KPI Ideas

shyamcharan — Tue, 06 Oct 2015 05:22:12 GMT

Hi Neetha,

I have marked it as Assumed Answered as there are more than one correct answers in this thread.

However, please suggest if I can make any better.

Regards,

shyam.

Re: KPI Ideas

MK_QSL — Tue, 06 Oct 2015 06:15:30 GMT

you can obviously tick helpful answers whoever has helped you...