We were able to use components of Microsoft Azure to automate data extraction. We then used Power BI to digitise the data and unlock analytical reporting to a small and restricted group of people. Lastly, we embedded a Power App within Power BI to allow these restricted users to dynamically change and update data.
This showed where workers were clustered location-wise around the UK and thus where socially distanced transport could be used to get them to Aberdeen. It also showed which workers would require accommodation on arrival for a period of self-isolation whilst coronavirus test results were awaited, and which could safely isolate alone at home.
To increase effectiveness, we also built an audit report to look at the data and assessed what details were changing over time (e.g. travel dates offshore). This audit helped Total to understand exactly what was changing and why, as frequent travel alterations are common in the industry.
To further ease the administrative burden of the new mobilisation requirements and to ensure rigorous safety protocols were trouble-free to follow, we built an email summary report. This allowed Total to contact each company with a list of all their personnel who were flying on a particular date, allowing them to get their workers ready via the necessary coronavirus pre-screening.
We ran this pre-screen exercise through Power BI, allowing Total to assess who was answering each form, to bring submissions into a central repository and to match it against their individual transport arrangements.