Healthcare data transformation — automated ETL with real-time reporting from GoodX and Xero APIs.

Challenge

Netclinic relied on a manual PowerBI setup for clinical reporting, requiring significant ongoing effort to maintain and producing reports too infrequently for timely clinical decision-making. Data from GoodX (clinical) and Xero (financial) systems needed to be extracted, processed, and reported on a regular basis without manual intervention — a capability their existing setup could not deliver reliably.

Solution

CloudZA implemented AWS Glue to overhaul Netclinic's clinical reporting processes, replacing their manual PowerBI setup with an automated solution. Lambda functions pull data from GoodX and Xero APIs into S3 buckets, while AWS Glue crawlers automatically catalogue and transform the data according to defined schemas.

This streamlined pipeline enables consistent data processing and automated daily and weekly reporting of clinical bookings and debtor transactions. Enhanced security features including row-level access controls protect sensitive healthcare data, and the integration with Amazon QuickSight provides reliable, accurate insights into operations.

Result

The solution delivered significant improvements in efficiency and data quality, with automated ETL processes reducing manual work while ensuring data accuracy. Netclinic now receives automated daily and weekly reports, row-level security protects sensitive clinical data in QuickSight, and management has reliable operational insights without any manual intervention.

The implementation demonstrates how cloud-native technologies can transform healthcare data management through automation and robust security measures.