Closed

Interface and setup KPI for POS system

This project received 10 bids from talented freelancers with an average bid price of $2755 USD.

Get free quotes for a project like this
Employer working
Project Budget
N/A
Total Bids
10
Project Description

Project KPI
This project is to design and build a GUI interface to set up Key Figures we need to track in real time. And an engine to compile this data (This project is not to display the Figures our POS program would take care of this)
We have a POS system running at different stores each client of ours wants a different Loyalty program. in order to speed up the process at the point of sale (not to have to run at that point SQL statements that takes time and to sum up large amounts of data) we would like to have handy KPIs figures that the POS program would be ready to take from.
Some requirements.
a. In each store, we only need the data and KPIs that the “loyalty program” of this store would need.
b. The server should be responsible for the work to prepare the data (maybe triggers, events) and not the client computer
c. POS data could change and the KPIs must be reflected as well (a client may change or delete some rows that are already reflected in a KPI)
d. Would need a GUI interface to select the KPIs for each location
e. This job is not to design the “Loyalty Campaign” but to design a and build a way to store the KPI and an interface to set it up.
f. Loyalty Campaigns may change in a store so it needs to be easy to change the KPI it is being gathered
g. The file structure may be a bit different from location to location but the key fields remain the same solution should work even if structure is changed

Some examples of “Loyalty program” sceneries and the KPI needed
a. If this customer has bought in the last 7 days from our meat department and paid cash for it give him now a discount of 5% in the fish department

There is only 1 KPI we need for this Loyalty Campaign:
1. sum of all meat department product in tickets grouped by day and customer only if the ticket was paid with cash

b. If this customer tickets is in average more then $100 in the last 30 days and this customer has visited the store this month more than 20 days then give coupon for this customer for the department this customer has bought the least YTD
This would need 3 KPIs
1. Average Ticket grouped by day and customer
2. Total visits grouped by day and customer (only count one per day)
3. Total each department grouped by customer and day


Any many more such type of information

So we would want to have a system that could consonantly have all these KPI handy so the POS register program could at the point of sale

If anything is not clear please don’t hastate to ask


In order to get this job explain in detail how you plan to accomplish this
What would I need to set at each store

The tables are in advantage data files from Sybase (server and Local server)

[url removed, login to view]

This tool would help you deal with the ADT files.

[url removed, login to view]

We prefer this should be in Delphi but is not necessary

Put in the word blue magic I should know it is not spam

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online