How plays a humble part in fighting COVID-19




Het Vlaams Agentschap Zorg & Gezondheid (VAZG) is responsible for the recognition, licensing and subsidizing of various providers and services for health care, elderly care, home care, residential care, and other forms of care, for facilitating the cooperation and data sharing between these services, for the organization of preventive health services such as vaccinations and screening programs, for the control of infectious diseases, for environmental health monitoring, and for the organization of the Flemish social protection programs.

With the outbreak of COVID-19, VAZG was faced with the challenge to keep track and report on a daily basis on the number of infected patients and healthcare workers and the number of COVID-19 related deceases for the care homes under their authority. First complexity was to collect data from more than 500 elderly, home, residential and other care homes with each between 50 to 150 healthcare staff to contact.

The solution

We decided to use Amazon Simple Email Service (Amazon SES), a cloud based email service, for sending personalized e-mails to the healthcare professionals. These daily mails are sent from a Lambda Function which are scheduled with AWS EventBridge. The respondents receive a link to a Google form through which they can enter the requested health data.

The EventBridge schedules a “data stream” Lambda Function for retrieving the desired health data through a Google API and converts the data into a JSON & CSV file which is stored in AWS S3. After some cleansing and preparation, this data is used by the BI team to build Tableau dashboards which are used by the COVID-19 taskforce.


Tableau dashboard VAZG


Kudos to Nicolai and Berk for their contribution in the fight against COVID-19.


Posted by Matthias Vallaey on 8-mei-2020 10:26:21

Matthias Vallaey

About the Author

Matthias is founder of Big Industries and a Big Data Evangelist. He has a strong track record in the IT-Services and Software Industry, working across many verticals. He is highly skilled at developing account relationships by bringing innovative solutions that exceeds customer expectations. In his role as Entrepreneur he is building partnerships with Big Data Vendors and introduces their technology where they bring most value.