Case of success

foscal

foscal

CConstruction of the data lake in Google Cloud Platform with a Datalake, to improve processes and obtain a short-term return on investment.

Challenge

It is required to implement a flow for the analysis and processing of your data, thus being able to make available the files from different sources in xlsx and csv (RAW) format, corresponding to the billing processes.nya glosses in a single storage.

Solution

The successful construction of the data lake in Google Cloud Platform was carried out with a Datalake which allows the collection of a variety of business data at scale, from different sources of information, both for structured and unstructured data, making it available for analysis and decision making. .

Outcome

It was possible to modernize the client's data warehouse, which contains different sources of information from their transactional systems, this information was migrated to Cloud Storage, processed with Jupiter Notebooks, and later sent to Bigquery, there was modeling of the data, which are finally displayed through Dynamic dashboards in Datastudio. 

With the solutions of Google Cloud Platform, the client has seen that with cloud services, internal processes can be automated and in this way have a short-term return on investment, the accompaniment of Servinformacion throughout the implementation and change management was essential to achieve the objectives raised. 

About the Client

foscal is a health service provider institution of high complexity, with the highest quality standards, committed to providing humane and safe care for our users. 

*All rights reserved. This publication is for commercial, informational and illustrative purposes. The content on this portal has the sole purpose of highlighting the success stories developed, implemented, managed and supported by SERVINFORMACIÓN. On the occasion of contracts, purchase orders and other legal instruments entered into with the aforementioned companies. The information published is exclusively intended to describe the contracted service, respecting the commitments of confidentiality, non-disclosure and use of the brand. SERVINFORMACIÓN under no circumstances reveals information of a confidential, sensitive or reserved nature according to the contracted service and in accordance with the regulatory framework of Law 1581 of 2012, Decree 1377 of 2013, and other regulations that regulate the protection of personal data in Colombia. This publication is supported in part by the framework of Law 1150 of 2007, Decree 19 of 2012 and Decree 1082 of 2015 rules that regulate Public Procurement in Colombia and the right of companies to register and publish the experience in a Unique Registry of Proponents (RUP) with the intention of presenting themselves as proponents in the different modalities of public procurement. SERVINFORMACIÓN when publishing the names of the entities and companies using the logo, text and photographs, it should NOT be interpreted that between SERVINFORMACION and the entities there is a de facto partnership, consortium, joint venture, association, shareholding, or joint venture. The logo and brand was taken from the main page of the Entity, without any alteration and for illustrative purposes and for reference only. The only relationship that exists or existed between the entity and company mentioned was the provision of a service. If you consider that we are violating your rights with any publication (text, photography or use of logo), please contact us at the email: servinformacion@servinformacion.com and this publication will be expanded, supported or corrected.

Have a smart location project in mind?

Increase the Productivity of your company and improve your business opportunities

Tell us your idea.

Contact us now!