Data hub on AWS enables near real time tracking of 20+ KPIs to improve sales performance and customer satisfaction

Sigmoid Solution

Sigmoid created a single source of truth for the client and worked with migration and re-engineering of the current dashboard along with data models and visualizations moving it from on-prem to a new cloud based solution. Sigmoid helped the migration of data with a low-code no-code framework to enable new data integrations rapidly. The data was extracted from 80+ retailers across the USA and their multiple data sources including Nielson, E2Open, Ensa, and more. After shifting the datasets to the Redshift staging layer, Sigmoid developed pipelines to bring data to the domain layer for scheduling the jobs using complex business logic. We generated reports or KPIs using the data available from the domain layer to store the output in the new cloud system or the datamart layer. This data enabled the creation of multi-page Tableau dashboards catering to different user bases. In addition, Sigmoid integrated customer satisfaction datasets, e-commerce data, display and survey related metrics and harmonized product and customer IDs with internal IDs in the data repository to eliminate data silos.