Case Study: State Auto Insurance Companies achieves faster analytics and lower costs with Looker

State Auto Insurance Companies Boosting productivity with advanced analytics

State Auto Insurance Companies, an Ohio-based insurer operating in 33 states, needed to move away from a legacy data warehouse to cut costs, improve performance, and reduce data siloing. The company relied on complex actuarial analysis and reporting, and it wanted a more efficient platform for managing insurance data and supporting advanced analytics.

Looker-supported analytics modernization helped State Auto, with BigQuery as the primary data lake solution along with Cloud Dataproc and Cloud Storage, to streamline data management and speed up queries. The results were significant: development time fell by 45%, maintenance costs dropped by 55%, most query times improved by up to 90%, and an 800GB query went from three hours to seven minutes.

State Auto Insurance Companies

Krishna Tummalapalli

Enterprise Data Architect