Smart business analytics and AI
A commitment to evolution in their daily collaboration
Abanca
Industry: Financial Services
Primary project location: Spain
ABANCA is the commercial brand under which ABANCA Corporación Bancaria, S.A. operates. It is one of the leading financial institutions in the Spanish market with more than 2 million customers, more than 4,400 employees and 700 offices in Spain, as well as offices in ten countries around the world.
Amarello as a technological partner had the great responsibility to strategically work the project adhering to Abanca’s high standards such as quality, reliability, responsibility and innovation as its core values.
The results
Generation of reports on the use of Google Workspace (Gmail, Meet, Drive) that enable management-oriented reporting, with the objective of displaying volumetric metrics classified and grouped according to defined typologies or data models.
The solution
A Data Warehouse was used as a data source fed from Google Workspace to obtain metrics and tracking. Views were built on BigQuery to generate dashboards in Looker Studio that respond to the business need, which provides scalability and elasticity. This allows us to access information in an agile way with analysis and visualization tools.
The challenge
Optimization of dashboard creation, data granularity and consistency, governance and security is maintained in a cross-cutting manner following the bank’s policies, information analysis is drastically simplified regardless of the granularity demanded, Google Workspace data enrichment to increase the scope and value of the reports generated.
Based on Bigquery and Looker Studio solutions, a solution has been developed that allows the organization to obtain the information required for dashboards.
Manuel Nuñez- Desktop & Collaborative Manager
