Starting Off with Clean Data
The new technical architecture required certain applications and business processes, including their business intelligence, to be migrated as well. Therefore, TWB teamed up with data experts at Xebia to move and automate their management data and pipelines to the Google Cloud. This is where our expertise shone.
First, we leveraged Compute Engine to extract and load the current database into the cloud. TWB, like a lot of healthcare organizations in The Netherlands, works with Nedap to manage their electronic health records and other business processes. They are an important player in the healthcare industry, and the data pipelines we built between Nedap and GCP has the potential to add a lot of value to other organizations within the industry.
Next, the data was imported into BigQuery where it is stored, cleaned, and transformed in preparation for safe and easy access for analysis. On the one hand, we made this data accessible in Connected Sheets for their business controllers to work their magic on, and on the other hand we used it to build interactive reports in Data Studio for end-users. These reports present the organization's KPIs: (near) real-time results versus internal benchmarks and budgets.
An important success factor was the collaboration between Xebia and TWB. We worked using our Agile Analytics methodology. Taking inspiration from agile software development, we made sure to work closely with the people from TWB in short iterations. This allowed us to continuously deliver new, value-adding insights on a short term, and allowed us to quickly respond to changes in data and processes.
