Customer 360 Insights Fueling Global Convenience Store Growth

Client profile

Our client, the largest international chain of convenience stores, handles over two million daily orders and caters to millions of customers worldwide. It is a go-to convenience store renowned for food, snacks, hot and cold beverages, gas, and more. This convenience store chain boasts an impressive network of 71,000 shops across 17 countries.

Business challenges

• Disparate systems for business intelligence, data analysis, and visualization hindered the ability to gain comprehensive insights into customer behavior.
• The need to understand customers better to provide targeted marketing, convert them into members of loyalty programs, and deliver personalized experiences to increase revenue opportunities.

LTM solution

• Implemented a robust Databricks solution to leverage on-demand scalability and massive parallel processing capabilities.
• Utilized Databricks Delta as the landing zone, transformed data using PySpark, and loaded it efficiently into Databricks Delta.
• Provided multiple application programming interfaces (APIs) for downstream consumption, facilitating seamless integration with various applications.
• Used tools and services such as Azure Data Factory for coordination, API Gateway Enterprise Edition (APIGEE) for managing APIs, Azure Kubernetes service for deploying APIs, Redis cache for improving API performance, and Power business intelligence (BI) for visualizing data.
• Automated data processing and ensured end-to-end integration with data sources for timely insights.

Business benefits

• 360-degree insights into customer behavior across various channels, demographics, and locations. This helped create personalized loyalty programs.
• Identified strategic locations for new franchises by studying customer transactions.
• Gained valuable insights into top-selling stores, brands, categories, and products. This helped optimize inventory management and marketing strategies.
• Measured campaign success rate across different channels, understood new customers’ product preferences, driving business growth and enhancing customer satisfaction.