Smart business analytics and AI
Accelerate analytical processes for risk management in Google Cloud.
Apoyo Económico is a company in the financial sector that provides microloans, with more than 170 branches nationwide. Among the needs of our client were the migration of relational databases based on licensing and optimization of analytical processes On Premises to Google Cloud. The main advantages that the client obtained by adopting a cloud model are: the reduction in licensing costs and very significant improvements in information processing time.
Within the most important business processes, critical analytical processes that use large volumes of information are executed on a monthly basis. Their main function is to deliver the analysis required by the business in the shortest possible time. In turn, risk analysts require the flexibility to perform additional analytical processes on the entire volume of information available.
The central requirement was to migrate the analytical process that generates as output the risk portfolio, which requires the processing of a large volume of historical information. Most of the process was implemented in an on-prem relational database which was limited to the use of licensed CPUs and hard disk space.
Our team of Google Cloud Certified Data Engineers migrated and re-engineered analytical processes to Google BigQuery as an Enterprise Data Warehouse to streamline processing time from several days to a couple of hours and empower analysts with a new universe of available information.
BigQuery was enabled to connect with Google DataStudio and Google Sheets to generate dashboards efficiently and with real-time data, which dramatically facilitated the delivery of reports to different business areas in a controlled and secure manner.
