Interactive Excel with Large Database Search
Budget: £20 – £250 GBP
I need a professional who can assist me in building an efficient database that can interact with Excel multiple times a second. The database will need to handle a dataset of 1,000-10,000 permutations across 3-5 variables reliably.
Key Aspects:
- Database: Open to any type (SQL, NoSQL, In-Memory)
- Excel Interactions: Preferably handled with Python, VBA or Power Query
- Interaction Type: Primarily read queries, with potential for write operations
Ideal Skills:
- Proficiency in database management and design
- Expertise in Excel and its interaction with databases
- Strong programming skills, particularly in Python and VBA
- Experience with handling large datasets
Please provide evidence of your previous work with similar projects, along with a proposal detailing your approach and estimated timeline for this project.
Key Aspects:
- Database: Open to any type (SQL, NoSQL, In-Memory)
- Excel Interactions: Preferably handled with Python, VBA or Power Query
- Interaction Type: Primarily read queries, with potential for write operations
Ideal Skills:
- Proficiency in database management and design
- Expertise in Excel and its interaction with databases
- Strong programming skills, particularly in Python and VBA
- Experience with handling large datasets
Please provide evidence of your previous work with similar projects, along with a proposal detailing your approach and estimated timeline for this project.