Transforming eCommerce performance reporting

Sigmoid built a centralized data lake that enabled data products for real-time sales reporting, omnichannel insights, and enhanced inventory management.

Business Challenge

The customer is a multinational CPG company. The global scale of their eCommerce operations demanded more visibility of their sales and inventory data. They wanted a centralized data lake that could enable data products on real-time sales analytics, general ledger, and vendor management dashboards, catering to diverse retailers. An effective monitoring system was crucial to minimize chargebacks resulting from late shipments or incomplete orders, thereby achieving cost savings. They were looking for data-driven insights to enable effective investment decisions for high-performing eCommerce channels.

Sigmoid Solution

We created a centralized data lake that streamlined and consolidated the vast and varied data landscape originating from multiple retailers and brands. Data from diverse sources was stored in Azure Data Lake Storage (ADLS) and APIs from multiple vendors such as eStore, Lett, and Sprinklr were used to provide access to the data scrapped by these vendors. The data underwent meticulous ingestion, transformation, and storage in formats tailored to the specific needs of the business. The refined data was stored in Databricks tables to establish a robust foundation for real-time analytics and reporting.

Business Impact

The centralized data lake provided a consolidated view of sales, inventory, and financial metrics to optimize strategic investments, driving tangible revenue growth. Real-time analytics and meticulously crafted P&L dashboards enhanced visibility into eCommerce operations which enabled proactive responses to changing market dynamics. The solution addressed complex data standardization challenges to establish a unified data ecosystem.

$300

million worth of POS transactions data analyzed

92%

assurance in online availability of stocks

70TB

data analyzed for insights on the General Ledger

Relevant Case Studies

Find out what data services can do for you.