The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
FMCG business seeks to analyse sales data from online Point of Sale system:
- the data is available for each day for the last year in .csv format
- it is complete but not set up very well for easy integration into Access . However could easily write VBA to re-format data in Excel before putting it into Access
- Probably too many entries for an Excel database (between 250 and 800 transactions per day, each with separate line items)
- Data would be updated COB daily (although, live updates would be better....see below)
The objective is to identify useful patterns and correlations in data to
a) improve inventory management (be able to respond quickly when stocks are low)
b) generate accurate sales predictions
c) analyse staff performance
d) identify good/bad selling products
e) identify causal factors affecting sales that are not being noticed.
Re updating the data. The easiest approach would be that the database is updated at the end of every day. But, it would be great if the ...
Sign in or Register to see more