Onix
99 Case Studies
A Onix Case Study
a non-profit community hospital organization faced a significant challenge in managing data ingestion from its members. The data extracts came from inconsistent sources, requiring extensive manual review that overburdened analysts and took weeks to process before the data could be analyzed. Onix was initially engaged to provide hands-on support for this manual process.
Onix implemented a revised, automated solution leveraging Google Cloud Platform services, including Cloud Composer and Google Cloud Functions. This new system automated the entire ETL process, from validity scans to transformation and ingestion into BigQuery. As a result, Onix helped reduce the data ingestion timeline from weeks to just minutes, eliminating manual errors and enabling the customer's own employees to manage the process.
A Non-profit Community Hospital Organization