Phoenix - Your AI AssistantI need data analyst to build a monthly master sales report
- Posted:
- Proposals: 47
- Remote
- #4501254
- OPPORTUNITY
- Awarded
London 
Description
Experience Level: Expert
Looking for a freelancer to support our business through data analysis and report generation. The project has the following steps
1) develop a Master Sales Report spreadsheet in excel to combine sales data from Woocommerce (UK & global sales); Amazon (FBM & FBA sales in UK, US, Australia, Canada); Ebay (UK only); Wallmart (US only)
Primary function is to report sales across 12 products - in 7 countries by units AND value - retail & wholesale (trade)
This will include breaking down reporting of multi unit SKUs to single units (i.e product x 40 data to be broken to 40 units and added to that product line)
2) apply this spreadsheet to previous years data sources and produce a summary sheet
3) be available to process this report on a monthly basis when we supply the monthly reports
A very rough example of the kind of report we are hoping for is attached
The data provided will need to be fined as the reports from Woocommerce, Amazon, Ebay, Wall mart present the data in different forms
1) develop a Master Sales Report spreadsheet in excel to combine sales data from Woocommerce (UK & global sales); Amazon (FBM & FBA sales in UK, US, Australia, Canada); Ebay (UK only); Wallmart (US only)
Primary function is to report sales across 12 products - in 7 countries by units AND value - retail & wholesale (trade)
This will include breaking down reporting of multi unit SKUs to single units (i.e product x 40 data to be broken to 40 units and added to that product line)
2) apply this spreadsheet to previous years data sources and produce a summary sheet
3) be available to process this report on a monthly basis when we supply the monthly reports
A very rough example of the kind of report we are hoping for is attached
The data provided will need to be fined as the reports from Woocommerce, Amazon, Ebay, Wall mart present the data in different forms
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Would you also like ongoing support for Master Sales Reporting, QuickBooks Integration, Amazon, WooCommerce, eBay & Walmart Data Consolidation, SKU Mapping, Inventory Analysis, Financial Reporting, VAT & Tax Reporting, KPI Dashboards, Forecasting, Business Intelligence Analytics, full auomation , and Full A–Z eCommerce Performance Management — All in One Place?