APR Nov/Dec 2022 - 42

» MANUFACTURING
»
Figure 3. Screenshots from the Sticking Application. A: Data Viewer showing measurements of selected formulations. B: Data Prediction
for newly entered data with function fit, predicted value including bootstrap confidence intervals, error and risk classification, as well as
explanatory text of the outcome.
Business example: DT Dashboard
During the past years, increased transparency on several department
activities has been requested, so we have worked on various
dashboards. In particular, the workstreams, efforts and achievements
of the department's DT initiative itself needed better dissemination
to enhance team collaboration. We thus developed a DT dashboard
in Google Data Studio™ to make all the information accessible and
traceable in an easy and quick way. It automatically synchronizes
detailed project information recorded in a Smartsheet™ with the
dashboard embedded in the department Google Site™.
The DT dashboard is composed of five main pages that provide an
overview of ongoing and planned DT projects within PTDC-F (Figure
4). The pages, easily accessible through the department intranet
homepage (Figure 4A), show full-time equivalent (FTE) spending per
project, as well as detailed timelines of bigger projects and initiatives
like our equipment integration (not shown). The dashboard contains
interactive graphs like the percentage of different features (tasks) in
42 |
| November/December 2022
individual epics (projects), which in Figure 5B shows us the projects
in the initiative data consumption and how big (in terms of tasks)
each project is. Furthermore, the graphics are fully interactive, e.g.,
by clicking on the pie chart slices, links for the relevant DT solutions
are displayed in the table below the chart (Figure 4B). One can also
examine the status of each task, here equipment connection to the
server per piece of equipment (Figure 4C). Similar to Figure 4B, the
table in Figure 4C interactively displays timelines for the equipment
selected via mouse clicking on the plot. This dashboard was presented
in a departmental meeting to make DT progress accessible to all
PTDC-F employees.
Portfolio analysis
Over three years, 40 projects were completed with 20 main project
partners. The project content was highly diverse, ranging from website
and model development to database management. Two constant
needs were process automation (8-44% of projects per year) and
data communication through visualizations or spreadsheets (25-37%

APR Nov/Dec 2022

Table of Contents for the Digital Edition of APR Nov/Dec 2022