Leading insurance broker achieves powerful data analysis capabilities
Greater visibility and more responsive business operations
Date : February 13, 2013
West Monroe enabled business users at one of the world’s largest insurance brokers and property/casualty third-party claims administrators to analyze client revenue in new ways.

When a leading insurance broker needed new metrics from disparate systems, we found creative ways to give executives powerful data analysis capabilities.

Disparate systems and data make reporting difficult
This organization struggled with a highly manual revenue reporting process that relied on multiple source systems and lacked the ability to provide deep analytics in a timely manner. Specifically, management was unable to analyze trends between client-level revenue and managed claims. The company had attempted to merge claims and contract data several times but had yet to succeed.

With the company’s business growing rapidly, the ability to analyze client revenues was critical. Management turned to West Monroe Partners for assistance. West Monroe had worked successfully with the company before and offered both the deep industry experience and technology knowledge to drive this project to completion.

New ad-hoc reporting capabilities
West Monroe Partners’ cross-functional team quickly oriented itself to the unique issues posted by the client’s disparate systems and moved to address those by:

  • Architecting and implementing a matching process to join data from the two systems
  • Developing a user-friendly process for assembling and uploading manually generated revenue data
  • Creating a Microsoft-based analysis “cube” that enabled ad-hoc analyses from Microsoft Excel Pivot tables
  • Implementing a maintenance solution that enables the finance team to improve business logic over time

Greater visibility, more responsive business operations
With newly assembled revenue and claims data, the client’s executives are able to:

  • Identify and steer its business toward the most profitable clients and billing types
  • Hold managers accountable for claimand revenue metrics
  • Perform ad-hoc revenue and claims analysis by client branch, account manager, carrier, and broker

Accordingly, the client has experienced tremendous improvement in the visibility into its business operations.

The company now can identify and respond to rapidly changing business dynamics—leading the way to greater profitability and growth.

Technologies Employed

  • Microsoft SharePoint 2010
  • Microsoft SQL Server Reporting Services 2012
  • Microsoft SQL Server Integration Services 2012
  • Microsoft SQL Server Analysis
  • Services 2012 - Tabular Model
  • Microsoft Excel 2010
West Monroe Insights
Non-Revenue Water (NRW): Challenges & Solutions
View More
Related Insights
West Monroe Partners to present and sponsor at the FinXTech Annual Summit
Date : April 26, 2017
Join West Monroe Partners at the FinxTech Annual Summit in New York, NY.
Natural Language Generation Goes to Work
Date : January 24, 2017

Natural Language Generation (NLG) is a form of artificial intelligence (AI) which takes an input of data and produces a narrative similar to how a human would interpret the data. NLG technology can be very transformative when used in business situations, especially in industries that are heavily dependent on generating text summaries based on straightforward conclusions drawn from structured data and that lack the capital to support a large workforce.

Date : January 23, 2017

Data is an asset. That is the mindset companies in the insurance industry must quickly embrace if they are to remain competitive in a landscape that is being challenged from seemingly all angles. From product commoditization, shrinking margins and disruptive startups to aging technology and processes, changing customer expectations and regulatory uncertainty, insurance companies face a critical imperative to harness data assets existing within their enterprise today.