The challenge
The CX department needed to have up-to-date consolidated KPIs to provide support to all customers from 15 countries. Data had disparate structure, depending on the geography.
The solution
Automated population of a new Data Mart consolidating a unique data structure for all countries, so that KPIs and all information used for support and decision making is standardized. The Data Mart was developed in a Serverless AWS RedShift environment to facilitate maintenance and data availability.
The results
Up-to-date consolidated data ready for reporting and other analytical tasks to provide a better customer experience for customers in all 15 countries.
