Spiral Mantra Pvt Ltd.
Empowering Businesses with Digital Transformation
Empowering Businesses with Digital Transformation
An e-commerce service focussed on delighting the world with an unmatched range food and beverages products. In 5 years, it has accomplished a 300% growth and has served over three million unit of world-class products to consumers. It is based on the fresh-to- consumer business model and owns the entire back-end supply chain powered by stringent cold chain control. With over 5,000 employees, it has successfully built differentiation across all dimensions including technology, supply chain, product quality, consumer engagement, and category understanding. It operates across 20+ cities across the country. Now wants to use the power of data to serve the consumers better and create an impact in their industry.
The client approached with a need of establishing a core data team to centralize data for better availability to business growth team, for management decisions and creation of robust dashboards
Starting with basic as-is analysis approach we identified the need for cloud based architecture using AWS cloud databases for faster data availability. The data pipeline was streamlined with a three-phase solution using Medallion framework. Raw data ingested into Bronze layer => Cleansed and Conformed data For Silver layer => Well organized business level data tables in Gold Layer used for dashboarding and visualisation. Centralized and organized data eliminated unnecessary queries and establishing proper queries for best data to be used for analysis and decision making.
This simple Medallion approach enabled the team to easily understand and utilize data for business decisions.Now the client enjoys centralized data helping them improve their business decisions in much faster time .Their product performance has drastically improved with the data helping them identifying gaps eliminating every unidentified gaps due to improper data pipeline
