A high quality data warehouse is critical for this company. Being able to bring procurement, sales and marketing, inventory, logistics, product development and other data into a meaningful data lake gives them deep insights, facilitates better quality decision making and satisfies their hunger for data and extracting value from it.
As a company grows, it should strive to be as agile as possible especially as the stakes get higher. The company deemed agility to be especially important when applied to gaining deeper insights into its data yet was finding it harder to keep pace with rapidly changing products and systems.
The company originally built their own data warehouse using in-house coded scripts. While this worked initially, over time it became hard to maintain and slower and slower to react to an ever increasing landscape of systems. As a result, rather than extracting more value from their data, they found that they were falling behind and struggling to keep up.
CloverDX allowed them not only to replace their integration scripts, it also allowed them to react very quickly to system and data changes and present their business users with a consistent and up to date data warehouse.
With over 100 people at the company using Tableau to analyze their data, they can now manage the data integration pipeline more easily and more reliably. CloverDX ensures that the data warehouse has a constant stream of live daily updates, allowing each department to take core data and build their own business-critical reporting.
Business unit leaders, as well as the business intelligence team, now have a far more detailed analysis of costs, margins and pricing promotions. They can also continually optimize everything from sales analytics, logistics and delivery to shipping, cost control and vendor comparisons.
With the focus on data-driven optimization, this e-commerce company was the subject of one of the largest ever acquisitions in online retail and a happy ending for this particular data story.
- Data warehouse and data lake
- Integrates procurement, sales and marketing, inventory, logistics, product development and other data into one data source
- Powering over 100 Tableau users, satisfying the hunger for extracting meaning from corporate data
- Replaced custom scripted solution that had been built in-house
- Is an integral part of the company’s technology stack
- Played a role in attracting the highest ever acquisition of an eCommerce business (2017)