A service company that provides SKU tracking analysis for FMCG businesses is looking to optimize its services.
The company stocks all its data in Snowflake. It provides to its clients dashboards to help them maximize sales, improve product availability, optimize their supply chain, and better collaborate with their retailers.
More than 1 500 FMCG businesses use the service. Around 300k queries are generated every day. The total data set is about 200 billion rows.
In order to optimize its services, the company wants data users to access data instantaneously : the target is to allow its clients’ users to interact with their dashboards in less than 1 second.
Manipulating such big volumes of data can be tricky. To keep the Snowflake bill under control the company has decided to build a data mart layer on top of Snowflake. However, with time and a growing amount of clients, each of them collecting more and more data, this infrastructure has reached its limits. Maintenance of the datamarts layer becomes too complicated, and dashboards performances are deteriorating.
Adding Indexima to its architecture allowed the company to fix these issues.[To access the case study, please complete the form.]