Linux GUI Dashboard for Manufacturing Metrics
Budget: $750 – $1,500 AUD
I'm looking for a proficient programmer to create a graphical user interface (GUI) dashboard for my manufacturing business. A high level of experience with Linux platforms is required as this will be the operating system used. The primary task will be programming the dashboard to display key production metrics which will assist in tracking and assessing manufacturing performance and efficiency.
Experience and Skills needed:
- Linux platform proficiency - Python or Docker
- GUI development skills - Using Metabase
- Metabase and SQLite familiarity
- Deployment on VPS and Locahost
Desired aesthetic:
I prefer the GUI dashboard to exploit the capabilities of Metabase and SQLite to achieve a functional yet appealing aesthetic. Experience in designing and developing with these technologies will be highly valued.
The code will include a module to process the .CSV files sent to the server via email. Every hour a .CSV file will be sent via email to the server. The .CSV data then needs to be processed into the SQL database using something like Pandas. We will use specific columns of the .CSV to generate data that we will then display in graphs and charts on the screen. The GUI will be quite simplistic showing mainly "Order Number", "Project Title", "Timesheet Total Hours as a percentage of Hours estimate" and "due date" (needs to be added to CSV). I have attached the dummy CSV.
Here is an exact example of the dashboard that will be replicated but for a different application - https://github.com/HawkeyeBot/exchanges_dashboard/tree/master
Experience and Skills needed:
- Linux platform proficiency - Python or Docker
- GUI development skills - Using Metabase
- Metabase and SQLite familiarity
- Deployment on VPS and Locahost
Desired aesthetic:
I prefer the GUI dashboard to exploit the capabilities of Metabase and SQLite to achieve a functional yet appealing aesthetic. Experience in designing and developing with these technologies will be highly valued.
The code will include a module to process the .CSV files sent to the server via email. Every hour a .CSV file will be sent via email to the server. The .CSV data then needs to be processed into the SQL database using something like Pandas. We will use specific columns of the .CSV to generate data that we will then display in graphs and charts on the screen. The GUI will be quite simplistic showing mainly "Order Number", "Project Title", "Timesheet Total Hours as a percentage of Hours estimate" and "due date" (needs to be added to CSV). I have attached the dummy CSV.
Here is an exact example of the dashboard that will be replicated but for a different application - https://github.com/HawkeyeBot/exchanges_dashboard/tree/master