The challenge
A workflow must be implemented to analyze and process the data, making files from different sources available in xlsx and csv (RAW) formats, corresponding to billing processes and disputed charges, in a single storage location.
The solution
A data lake was successfully built on Google Cloud Platform, enabling the collection of a variety of business data at scale from different information sources, including both structured and unstructured data, and making it available for analysis and decision-making.
Project results
The customer's data warehouse, containing information from multiple transactional systems, was modernized. The information was migrated to Cloud Storage, processed with Jupyter Notebooks, and then sent to BigQuery, where data modeling was performed. The resulting data is visualized through interactive dashboards in Data Studio.
With Google Cloud Platform solutions, the customer has seen that cloud services can automate internal processes and deliver a short-term return on investment. Servinformación's support throughout implementation and change management was essential to achieving the stated objectives.
About the Customer
Foscal is a provider of highly complex healthcare services with the highest quality standards, committed to delivering compassionate, safe care to our users.
