Use Case
From Costly SaaS to Bespoke Intelligence
2 minutes read
Download full Use Case
Challenges
- High Platform Costs: Approximately £120K spent annually on an external reporting system, with expenses escalating alongside usage and growing data volumes.
- Limited Microsoft Integration: Restricted integration with the Microsoft ecosystem created additional operational friction.
- Fragmented Data Sources: Complex connections across multiple data streams made it difficult to unify INSTANDA views, TPA claims and other business data.
- Slow Refresh Cycles: Month-end reportings delayed visibility into gross earned loss ratios and portfolio performance.
Solutions
- Bespoke Azure Data Platform: A custom analytics environment using Azure Synapse and Azure Data Lake Storage Gen2 to replace the packaged analytics SaaS platform.
- Automated Data Pipelines: Automated data ingestion and policy-to-claim alignment across 10+ products and multiple TPAs.
- Medallion Data Architecture: Bronze-to-Gold layered data implementation with incremental loads to support daily data updates.
- Custom Power BI MI: Replaced rigid reports with interactive Power BI dashboards for GELR, rate strength and portfolio performance.
Business Impact
- 97%+ Platform Cost Reduction: Reduced approximately £10K in monthly SaaS fees to roughly £210 per month with Azure.
- Daily Data Visibility: Replaced month-end reporting cycles with automated daily updates.
- Zero Manual Reconciliation: Automated policy-to-claim matching across 10+ products and multiple TPAs.
- Greater Analytical Control: Enabled granular tracking of rate strength, retention and gross earned loss ratios.
- Flexible KPI Expansion: Enabled teams to introduce and adapt custom metrics as business requirements evolved.
A major global specialty (re)insurance player serving complex and high-value risks across international markets sought a scalable, data-driven Management Information (MI) platform to support finance and underwriting decisions. However, its reliance on its standard packaged analytics platform, created significant operational constraints. With recurring costs reaching approximately £10K per month and increasing with data volume and usage, the platform was expensive, difficult to customise and offered limited integration with the wider Microsoft ecosystem.
- Microsoft Power BI
- Azure Synapse Analytics
- Microsoft Power BI Report Builder
Data Engineering and Analytics
Link Copied to Clipboard!
You Might Be Interested
