Case Study: Holmes Murphy & Associates achieves governed, consolidated data from 1,000+ complex sources with QlikView Expressor (Qlik)

Holmes Murphy & Associates Leverages Qlikview Expressor To Govern Data From 1,000+ Complex Sources

Holmes Murphy & Associates, a premier independent risk management and insurance brokerage with 500+ associates, needed to become more data-driven while managing increasingly complex inputs from more than 1,000 sources. The firm struggled with inconsistent formats, manual data preparation and the risk of human error, and wanted to codify business rules so analysts could spend less time conforming data and more time delivering insights.

Holmes Murphy deployed QlikView Expressor to its systems analyst team in under two weeks and built five dataflows in four weeks, using the platform’s semantic and repository layers to centralize processing and automate conformance. The first project reconciled 25 years of claims—$300 million—down to the penny; the solution shortened time-to-analysis, reduced errors, created a standard, teachable platform for ~70 users, and enabled consolidated, higher-value views for customers.

Holmes Murphy & Associates

Aaron Witt

Systems Analyst