Download PDF
Lifetime Value Optimization through Data Centralization: A BlaBlaCar Case Study
Technology Category
- Analytics & Modeling - Big Data Analytics
- Infrastructure as a Service (IaaS) - Cloud Databases
Applicable Industries
- Cement
- Transportation
Applicable Functions
- Logistics & Transportation
- Sales & Marketing
Use Cases
- Demand Planning & Forecasting
- Last Mile Delivery
Services
- Data Science Services
The Challenge
BlaBlaCar, the world's first online carpooling booking service, faced a significant challenge in accessing and utilizing their data. The company's Business Intelligence (BI) teams were heavily dependent on IT teams for reporting and analytics. The process of data retrieval was time-consuming and repetitive, often taking days to deliver the requested data. The company's data sources were heterogeneous and scattered, making it difficult for the BI teams to access the data on demand. The challenge was to find a solution that could clean, consolidate, and centralize these data sources for easy and immediate access by BI teams globally.
About The Customer
BlaBlaCar is a pioneering company that launched the world's first online carpooling booking service. This innovative approach transformed carpooling into a viable means of transportation. The company has experienced rapid growth, boasting over 10 million members and operations in 13 countries. It continues to expand at a rate of 200% per year. BlaBlaCar operates in the online car sharing platform industry, primarily in the European and Indian markets. The company's primary use case for data science is Lifetime Value Optimization (CRM).
The Solution
BlaBlaCar adopted Data Science Studio to automate the cleansing and centralization of data for global on-demand access. A developer and a BI Data Manager built a stream that automatically retrieves data from various sources, including SQL databases, social network data, user reviews, and partner logs. The data was then aggregated and stored in a Vertica database, optimized for analytical calculations and complex queries in Big Data environments. This solution allowed business, marketing, and BI teams to build and view reports without regenerating complex and expensive queries on SQL databases. The BI teams used Tableau Software, connected to the Vertica database, to create visualizations of the data.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
System 800xA at Indian Cement Plants
Chettinad Cement recognized that further efficiencies could be achieved in its cement manufacturing process. It looked to investing in comprehensive operational and control technologies to manage and derive productivity and energy efficiency gains from the assets on Line 2, their second plant in India.
Case Study
Airport SCADA Systems Improve Service Levels
Modern airports are one of the busiest environments on Earth and rely on process automation equipment to ensure service operators achieve their KPIs. Increasingly airport SCADA systems are being used to control all aspects of the operation and associated facilities. This is because unplanned system downtime can cost dearly, both in terms of reduced revenues and the associated loss of customer satisfaction due to inevitable travel inconvenience and disruption.
Case Study
IoT-based Fleet Intelligence Innovation
Speed to market is precious for DRVR, a rapidly growing start-up company. With a business model dependent on reliable mobile data, managers were spending their lives trying to negotiate data roaming deals with mobile network operators in different countries. And, even then, service quality was a constant concern.
Case Study
Digitize Railway with Deutsche Bahn
To reduce maintenance costs and delay-causing failures for Deutsche Bahn. They need manual measurements by a position measurement system based on custom-made MEMS sensor clusters, which allow autonomous and continuous monitoring with wireless data transmission and long battery. They were looking for data pre-processing solution in the sensor and machine learning algorithms in the cloud so as to detect critical wear.
Case Study
Cold Chain Transportation and Refrigerated Fleet Management System
1) Create a digital connected transportation solution to retrofit cold chain trailers with real-time tracking and controls. 2) Prevent multi-million dollar losses due to theft or spoilage. 3) Deliver a digital chain-of-custody solution for door to door load monitoring and security. 4) Provide a trusted multi-fleet solution in a single application with granular data and access controls.
Case Study
Vehicle Fleet Analytics
Organizations frequently implement a maintenance strategy for their fleets of vehicles using a combination of time and usage based maintenance schedules. While effective as a whole, time and usage based schedules do not take into account driving patterns, environmental factors, and sensors currently deployed within the vehicle measuring crank voltage, ignition voltage, and acceleration, all of which have a significant influence on the overall health of the vehicle.In a typical fleet, a large percentage of road calls are related to electrical failure, with battery failure being a common cause. Battery failures result in unmet service agreement levels and costly re-adjustment of scheduled to provide replacement vehicles. To reduce the impact of unplanned maintenance, the transportation logistics company was interested in a trial of C3 Vehicle Fleet Analytics.