Project Description
I need a repeatable Python workflow that connects to my external databases, gathers the required tables, and pushes the refreshed data into Excel while immediately producing data visualisation sheets. The script must:
• Open a secure connection to the databases using supplied credentials
• Query the specific tables I outline and perform any light cleaning with pandas
• Write the results to a new or existing workbook through openpyxl / xlsxwriter
• Generate the visualisations right inside the file—charts and graphs that update every time the script is run
I will supply a small sample of the database structure and an Excel template so you can mirror my formatting. The end-to-end run should complete with a single command or scheduled task, with all libraries clearly documented in a requirements.txt file.
Acceptance is straightforward: if I can point the script at my database, run it without manual edits, and receive an updated Excel workbook containing the refreshed data plus the visualisations in their assigned sheets, the job is done.