Geo-Analytics Driven Agile Transformation in Telecom Retail Using H3 Hexagon-based Heatmaps
- Customer
- Tele2/Altel
- Project manager on the customer side
-
- Year of project completion
- 2023
- Project timeline
- July, 2021 - March, 2022
- Project scope
- 4320 man-hours
- Goals
-
Business Challenges and Pain Points
• High CAPEX for new retail shops without data-backed justification
• Missed opportunities due to lack of real-time analysis
• Static business models that are unable to adapt to rapidly changing consumer
behavior
• Environmental impact of poorly optimized physical infrastructure
• Traditional methods were slow in determining optimal store locations
• High costs associated with relocating or establishing new stores
• Ensuring minimal service disruption during store transitions
- Project Results
-
Tangible Measurements
• ROI: 7% increase due to optimized store locations.
• Revenue Increase: 5% revenue increase per product per year.
• Net Promoter Score (NPS): increased by at least 8%.
The uniqueness of the project
Innovative Approaches:
• Geo-analytics to determine the home location of a subscriber using a probabilistic distribution over base stations.• H3 Hexagon-based Heatmaps provide a visual representation of subscriber density.
- Used software
-
Design Principles:
• User-Centric: All designs should focus on ease-of-use and accessibility for both our internal teams and end-users.
• Scalability: The system should be able to handle increasing amounts of data as our subscriber base grows.
• Interoperability: Easy integration with existing systems for data sharing.
• Sustainability: Consider environmental impacts in all design elements.
- Difficulty of implementation
-
Geospatial Data: Location coordinates of subscribers and base stations.Subscriber Data: Usage patterns, peak activity times, and service type used.Sales Data: From existing and closed stores for performance metrics.Competitor Store Locations: To identify areas of opportunity or potential oversaturation.
- Project Description
-
• Dashboard: A dashboard displaying heatmaps and key metrics.
• Interactive Maps: H3 hexagon layered maps that can be filtered based on different metrics.
• User Access Controls: Different access levels for different teams, ensuring data integrity and security.
- Project geography
- Whole country (Kazakhstan)
The right choice of a business partner is one of the main tasks of any business. The quality of goods or services that the company receives, as well as its reputation, depend on the reliability of the supplier. To make the process transparent and convenient, scoring models for assessing reliability come to the rescue.
Summer is coming to an end, but life in the analytics field is bustling. New vendor announcements, promising projects, and the pervasive penetration of AI into all areas of our lives are paving the way for the upcoming business season.
Maksim Karankevich, Director of Data and Digital Transformation, Ultramar, in his presentation shared his experience of implementing a cellular-based industrial radio network.
The home goods retailer has long been committed to digital innovation, not only in product design but also in transforming operational strategies.
Kuat Sandalov, Chief Data Officer at Kazakhtelecom tells about how data governance maximizes the value of data for strategic initiatives and decision-making while ensuring sustainability and adaptability to future needs.