Better CX using Consolidated Data from a Serverless Data Mart

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.