Improving Data Quality and Query Performance with a Data Warehouse

Industry: Insurance

Project Type: Power BI and Analytics

Tools Used: SSIS, Enterprise Data Warehouse, SQL Server Reporting

The Benefits

Higher Employee
Productivity

due to faster reports

$1000’s

saved due to less IT hours spent building new reports and dashboards

More Revenue
and Reduced Expenses

due to accurate analytics

Project Overview

Trean Corporation is an independently owned entity providing insurance management services, insurance and reinsurance consulting, and reinsurance placement services.

Trean has grown over the past few years along with the amount of data it maintains. This additional data, the complex logic in reports, and the custom way of handling incoming XML data resulted in a slow reporting environment that was difficult to manage and often resulted in inaccurate data.

Project Goals

Faster and more accurate reporting

Cleaner data pulled from XML files in a standardized manner

Remove current data caching process

Approach

Interviewed the IT data team and reviewed commonly used reports to formulate a list of measures and
dimensions for the data warehouse
Identified the tables and fields holding the data for the measures and dimensions.
SSIS solutions were built to pull from the existing reporting system and the XML files
Data marts were built for each of the different lines of business
A new data warehouse was developed to combine the data from the data marts.

The Results

A new data warehouse that provides a complete view of the policies Trean manages.

Users can easily see new metrics such as:

- Policy types that are exceeding a loss ratio threshold.

- What percentage of their overall portfolio is defined by what type of policy.

The complex data caching solution was removed from the environment.

70-90% improvement in reporting speed.

A data environment that can grow with the business.

Improve Your Performance and Profitability Today

SCS uses best-in-class tools to deliver database, reporting and data platform and analytics solutions. We partner with your team to develop custom solutions.

Get Started

Case Study: