Build Customer Database & Reporting in Excel
Budget: $750 – $1,500 USD
I'm in need of an experienced Excel specialist to build a comprehensive customer database, with fewer than 300 customers of a meal delivery program. This database will be primarily for tracking customer records, and will also include various customer-related information that can be summarized with pivot tables, monthly and annual reports.
The database should store:
-Customer Name
-Customer Address
- Contact details
-Special requests
-Allergy alert information
- Service history
-Delivery route number
-Delivery route order (in what order are the deliveries made)
- Feedback and complaints
Furthermore, I need this database to produce various reports. Specifically, I need it to assist with:
- printing production orders
- generating monthly government reports
- integrating with billing systems
Ideal skills for this project include advanced Excel capabilities, database management, and reporting experience. It would also be beneficial if the freelancer has a background in customer service data analysis. I'm looking for someone who can deliver a user-friendly and efficient database.
The database should store:
-Customer Name
-Customer Address
- Contact details
-Special requests
-Allergy alert information
- Service history
-Delivery route number
-Delivery route order (in what order are the deliveries made)
- Feedback and complaints
Furthermore, I need this database to produce various reports. Specifically, I need it to assist with:
- printing production orders
- generating monthly government reports
- integrating with billing systems
Ideal skills for this project include advanced Excel capabilities, database management, and reporting experience. It would also be beneficial if the freelancer has a background in customer service data analysis. I'm looking for someone who can deliver a user-friendly and efficient database.