Finish Excel & SQL Tasks Today
Budget: $30 – $250 USD
I have an unfinished workbook and a partially-built database that both need to be wrapped up within the next 24 hours. In Excel, the remaining work involves tidying up raw records, arranging them into logical tables, and then turning key metrics into clear charts and graphs so the workbook can be handed straight to stakeholders without further edits.
On the SQL side, the schema is sketched but not finalized. I still need the tables normalised, primary and foreign keys confirmed, and any lookup tables added where they make sense. After that, I’ll need production-ready scripts that cover:
• well-structured SELECT statements for the main dashboard views
• INSERT, UPDATE and DELETE queries to handle routine maintenance
Please deliver:
1. The cleaned, fully-formatted Excel file with all requested charts in place.
2. A .sql file (or equivalent) containing the final schema plus the tested queries.
3. A brief read-me so I know how to run everything end-to-end.
If you’re comfortable jumping between Microsoft Excel and a standard relational engine (MySQL, PostgreSQL or SQL Server—all fine), and you can hit a one-day turnaround, this should be a quick win for both of us.
On the SQL side, the schema is sketched but not finalized. I still need the tables normalised, primary and foreign keys confirmed, and any lookup tables added where they make sense. After that, I’ll need production-ready scripts that cover:
• well-structured SELECT statements for the main dashboard views
• INSERT, UPDATE and DELETE queries to handle routine maintenance
Please deliver:
1. The cleaned, fully-formatted Excel file with all requested charts in place.
2. A .sql file (or equivalent) containing the final schema plus the tested queries.
3. A brief read-me so I know how to run everything end-to-end.
If you’re comfortable jumping between Microsoft Excel and a standard relational engine (MySQL, PostgreSQL or SQL Server—all fine), and you can hit a one-day turnaround, this should be a quick win for both of us.
Related categories:
Data Processing
Excel
SQL
MySQL
Database Programming
Database Development
Data Analysis
Data Management