A property and casualty insurance company with over 10 acquisitions needed a way to create holistic reports across the enterprise. Aptitive created a data hub that enabled reporting on KPIs such as premiums and loss ratios across all business lines, saving them nearly 50 hours a month.

The Problem

Aptitive’s client, an insurance holding organization that has acquired over 10 individual companies, struggled to provide reporting and analytics at an enterprise level. The client wanted to gain uniform, overarching insights about claims and policies across its many lines of business. With their existing data processes, the business intelligence team struggled with differing reporting practices across companies, highly manual processes for editing existing reports, and no ability to use modern BI tools for dashboarding or advanced analytics.

Our Solution

To alleviate this problem, Aptitive leveraged their ETL framework and best practices to create a centralized data hub that consolidated data sources, improved data quality, and standardized business logic across the enterprise into a single version of the truth.

The Outcome

The resulting solution eliminated many manual processes and inaccuracies in data leading to more accurate reporting and insightful analytics. Furthermore, the solution enabled the organization to break down their key performance indicators such as premiums, reserves, loss ratios, and retention rates across many dimensions of their business allowing key business stakeholders to effectively analyze and report on their subsidiaries, as well as the overall organization.

Client Industry

Insurance – Property and Casualty


SQL Server Integration Services
Microsoft SQL Server
SQL Server Server Analysis Services
SQL Server Reporting Services
Duck Creek