Case Study
ADA helped a global retailer get a holistic view of their online business by consolidating their data on Amazon Redshift
The Results
Understand the impact of clickstream data on revenue.
Consolidated transaction and clickstream data for further data analysis.
The Execution
The customer is a leading global sporting goods retailer with a footprint in 56 countries and selling products from over 20 brands.
The customer was in need of an E-Commerce Digital Performance Dashboards to provide insights on its rapidly expanding E-Commerce business. However, its transactional and clickstream customer interaction data were located in separate data silos hampering consolidated view of its data.
ADA helped to migrate the customers clickstream data from GCP BigQuerry and consolidated the data with its transactional data on AWS Redshift. We helped to merge the session level data with revenue data to create a holistic analytics data set. ADA then built AWS Quicksight dashboards to provide
