A renowned hair care brand operating globally aimed to gain deeper insights into product sales and customer behavior across locations. However, they faced a challenge sourcing these insights due to flaws in their data management infrastructure.

 

The primary challenge lay in the fragmented nature of their data. Despite having a data warehouse implemented on Redshift, the company failed to establish it as a single source of truth. To fetch data from an ERP system and Shopify (where the company’s ecommerce solution was implemented), they relied on web scraping. Unfortunately, this method often resulted in data transfer errors, especially when changes occurred in the user interface of these data sources.

 

Another factor contributing to the challenge was the absence of a standardized mechanism for data transfer from retailers. Retailer data was typically exchanged in Excel format, which heightened the risk of human errors during the process.

 

Furthermore, the customer had already implemented a data analytics solution using Tableau. However, due to the frequent errors and discrepancies in the source data, this solution failed to provide reliable insights.

 

To address the challenges, the brand turned to JustSoftLab. Together, we embarked on a journey to overhaul their existing data infrastructure. This involved establishing fail-proof data transfer mechanisms, transforming their data warehouse into a single source of truth, and introducing a new data analytics service.