Share This Page

ShareShareShareShare

Cloud-based data warehouse solution and clickstream analytics for a large online grocery retailer

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

Cloud-based data warehouse solution and clickstream analytics for a large online grocery retailer

Let's Talk About Your Needs

Thank you for your submission. We'll be in touch.