Yellowbrick | Spray Paint
Yellowbrick | Top 3 global insurance company

Yellowbrick Data Warehouse brings faster, more accurate underwriting and IFRS 17 compliance to billions of policies

Top 3 global insurance company
Industry: Insurance
Business use cases: Financial Reporting/Compliance, Underwriting, Claims Ratio Calculation
Technical use case: Enterprise Data Warehouse


This major insurance company, with more than $90 billion in annual premiums, has numerous use cases for fast, reliable data processing and analytics, including:

  • Compliance with IFRS 17, one of the most significant challenges to insurance accounting in more than 20 years.
  • Processing billions of insurance policies to assign the costs incurred for each policy across different areas.
  • Insurance underwriting, for which 200+ users interactive analyze huge amounts of historical data.
  • Claim ratio calculation (the ratio of the net claim settled by the insurer to the net premiums collected), which relies on complicated algorithms.

Existing architecture failing the business

The company’s patchwork of legacy data warehouses were too slow, inflexible, unreliable, expensive to support these use cases, slowing the pace of business and limiting the amount of accessible data:

  • Policy expenses could only be subdivided four ways, and multiple days were required to process the entire portfolio.
  • Insurance underwriting was too slow due to latency when running ad hoc queries, with only a subset of data available for analysis.
  • The solution lacked the performance and scalability needed to meet IFRS 17 compliance requirements.
  • Claims ratio calculation took two full days to complete for the full portfolio.

Modernizing for price/performance at scale with Yellowbrick

After extensive testing and evaluation, the company selected Yellowbrick over Greenplum and others for its data warehouse transformation project — with queries running 400X faster on Yellowbrick. During testing, Yellowbrick proved out its ability to help process and analyze billions of rows of data (including numerous complex table associations), providing price/performance at scale, data consistency, and 24/7 availability.

global insurance company

Today, the company is using Yellowbrick to bring instant insights to asset management, annuity insurance underwriting, life insurance marketing campaigns, and HR (for 2 million employees).

Results include:

  • Hundreds of underwriters can create policies more quickly and accurately for customers, contributing to a reduction in average turnaround time from 3.8 days to 10 minutes
  • Capabilities now in place for compliance with IFRS 17, with the company being the first in its country to meet that milestone
  • Policy expense processing now completes in 2 hours (versus several days), with costs subdivided into hundreds of different areas to drastically improve management accounting decisions
  • Claim ratio processing completes in 2 hours (versus 2 days), while other processes are running concurrently without performance impact

“After extensive testing and evaluation, the company selected Yellowbrick over Greenplum and others for its data warehouse transformation project — with queries running 400X faster on Yellowbrick.”

Top 3 global insurance company
Yellowbrick | Panda
Yellowbrick | Panda

Top Rated in Customer Reviews

Yellowbrick is a leader in Data Warehouse on G2
Review Yellowbrick on G2

Join Us for a Webinar

Meet our experts and learn how to leverage Yellowbrick's secure and fast query response.

Book a Demo

Blazing-fast performance at petabyte scale awaits you.

Book a Demo

Learn More About the Only Modern Data Warehouse for Hybrid Cloud

Run analytics 10 to 100x FASTER to achieve analytic insights that have never been possible.

Simpler to Manage
Configure, load and query billions of rows in minutes.

Shrink your data warehouse footprint by as much as 97% and save millions in operational and management costs.

Accessible Anywhere
Achieve high speed analytics in your data center or in any cloud.