Insight Engine for a UK-Based Pet Insurance Company to get a Holistic View of their Customers
InsuranceBusiness Impacts
Identification and acquisition of high lifetime value customers
Optimized targeting by identifying highest and lowest potential customers
Customer Key Facts
- Country : London, United Kingdom
- Industry : Insurance
- About : The client is a leading London-based pet insurance provider
Problem Context
The customer was using various third-party tools to interact with their customers and activate marketing campaigns. However, it became challenging to track the performance of these campaigns with multiple tools in use. The customer reached out to Quantiphi to get a unified view of its customer data from different source systems in a single place and build a platform that can be referred to as a single source of truth.
Challenges
- Unstructured and siloed data
- Disparate data spread across multiple application and web sources
- Inconsistent data across data sets
Technologies Used
Google BigQuery
Google Cloud Function
Google Cloud Storage
Google Cloud Dataflow
Tableau
Centralized platform to manage data
Solution
Using data architecture techniques, Quantiphi built a data warehouse platform that condensed data and made it analysis-ready. Real-time data visualization dashboards were also designed for each department. Using data architecture techniques, Quantiphi built a data warehouse platform that condensed data and made it analysis-ready. Real-time data visualization dashboards were also designed for each department.
Results
- Real-time interactive dashboards for monitoring department specific data deviations
- Generated insights for improved and informed decision-making
- Enhanced agility of the system and reduced time-to-insight