Summary Need software to interrogate a database, extract data and then represent it in a dynamic dashboard Detail Data is of material production in a manufacturing workshop. We want a simple representation of progress for each Works Order as it moves through various processes. The data is stored in a standard DB format and reviewed every 60 seconds to update the dashboard. DB table needs amending to include new data to be linked to existing dataset so an input method needs creating. DB can be accessed via SQL software. DB is used by an un-editable Python coded GUI. Needs to operate within standard Windows package over a networked PC. Current DB format and sample data will be provided. Different Works Orders have different tasks ascribed to them (from a defined list) and can vary in quantity of units from 1 to 200+ so tables/charts etc. must be dynamic to reflect the different processes. Multiple Works Orders are live at any time so visualisation must scroll through all active Works Orders
