I require a proficient expert who can develop an advanced spreadsheet that will import and sort data with specific criteria. The spreadsheet should not only help with the data organization but should also present it visually in the form of sales graphs.
The types of data it will handle are:
- Customer information
- Product information
- Sales data
- End user usage by the product, shipped through 12 distribution centers
As part of the functionality, this data should be sorted by:
- Customer
- Product information
- Sales data
- Quantity sold
- Region
- Weekly sales
Ideal skills for this project would be in-depth knowledge of Excel formulas, pivot tables, and chart generation in Excel. Previous experience in developing advanced spreadsheets for data analysis will be a plus. A sound understanding of sales data analysis will also be beneficial.
My aim is to improve our decision-making process and sales strategy by having comprehensive, actionable insights at our fingertips.