We are an online e commerce distributor we sell via different platforms e.g (Amazon, eBay and etc)
Our issue comes when we have many SKU and the performance of the product changes week to week. We need a method to find the right correlation to detect issues and also success.
We run our own ERP so the data comes from a MySQL DB. So the data could be exported in CSV Format
The variables we have are.
1) PA Actual Price (last 7 days)
2) PX The price we had one week before
3) PY The price we had 30 days before
4) DA Demand over the past 7 days
5) DX Demand we had one week before
6) DY Demand we had 30 days before
7) SKU Stock Keeping Unit
8) SOLD Total items sold across all platforms
9) Current Stock Showing the stock we have
10) ES, DE, eBay are the different platforms we have.
We require someone to analyse the data and give us the formula to find issues and success to our products. I have attached a data subset.
Must have analytical skills to understand what we require. If you can do it please reply " I can do it, I have done it" if you don't, your entry will automatically be deleted.
8 freelancers are bidding on average $271 for this job
i will help you in all aspect of data analysis ,presentation and visualization, my skill in analysis will be based on excel, tableau, spss among other analyses softwares
I can do it and I have done it. I would love to hear more about this project, please contact me and ask any necessary questions. I have worked with excel for many years and I can analyze data fairly well.