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.
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)
This tool would help you deal with the ADT files.
We prefer this should be in Delphi but is not necessary
Put in the word blue magic I should know it is not spam