On
Off
Client
Large online grocery retailer catering to more than one million orders per month.
Challenges
- Disparate systems for business intelligence, data analysis, and visualization
- Lacked the capability to provide detailed analytics needed to improve customer reach
- Extant infrastructure platform could not scale up to meet ambitious growth plans
- Limitations in supporting campaign management and rules engine capabilities
- High lead time in extracting and making the entire data set available for business reporting and analysis
Solution
- A cloud-based DW solution that helped leverage the on-demand scalability and massive parallel processing capabilities
- Using Amazon S3 as a landing zone, the solution transformed data using Elastic Map Reduce and loaded it into Amazon Redshift DW
- Captured enhanced Clickstream data with the enriched context driven by events using Snowplow
- Ingested historical data and provided multiple APIs for downstream consumption
- Provided operational information on scheduled data loads through Mindtree’s ABC (Audit Balance Control) framework
Benefits
- Integrated 360° view on customer buying patterns, trends, inventory and other operational parameters
- Nimble in reacting to changes in customer buying patterns and competition scenario
- Potential for cross-selling
- Increased ability to target the right customers with the right promotions and ability to measure the success rate of the promotions
- Better insights into customer’s channel of buying, mode of payment, and enhancing customer experience while ordering
Read more:
Enabling Industrialized Insights Platform for leading Pharmaceutical Company
