Productivity Renovation— Using Tableau, HomeRepair Works 6 Times More Efficiently with Fewer Staff

HomeRepair, a company that repairs residential property damage claims on behalf of one of Australia’s largest general insurers, was facing increasing competition. The company needed to understand its performance metrics quickly to retain and build its market position. HomeRepair had the majority of its data stored in GClaim, a web-based repair administration and management solution. However, the company could not use that information in a timely manner due to the lack of an in-house IT department. HomeRepair management relied on IT vendors to run queries and reports from the SQL database, a process that was too slow for the company's needs. HomeRepair management was able to pull some data out of the SQL database and into Excel pivot tables, but the resulting reports were not very helpful. To truly understand productivity and cost-effectiveness, HomeRepair would need to look at data stored in other sources in concert with its GClaim data.

HomeRepair is a company based in Melbourne, Victoria, Australia, with 35 employees. The company has spent the past decade repairing residential property damage claims on behalf of one of Australia’s largest general insurers. HomeRepair's primary client, the insurance company, selects its preferred repair service providers by looking at key performance areas including timeliness and cost. HomeRepair had the majority of its data stored in GClaim, a web-based repair administration and management solution developed specifically for HomeRepair. The company completes thousands of repairs each year and there are hundreds and hundreds of data points for every job. More recently, HomeRepair has equipped its tradespeople with mobile systems that input real-time information into GClaim.