Large Workers Compensation Team drowning in spreadsheets
A large private equity maintenance provider had a large workforce of 6,000+ employees, many of whom were working on clients industrial and commercial sites. The problem was that each region had its own Health and Safety teams that would conduct the field work. From a financial and workers compensation point of view all this data was maintained in Excel workbooks, by each regional team on a monthly basis. The teams would create a new tab to capture the data for each site every month, resulting in hundreds of tabs of data on all the details. It finally came to a head when a new Manager started in charge of the Workers Compensation area. What was obvious was that many of the team members in each region’s job was to collate the workers compensation data and weren’t even that involved operationally with the sites. The process to analyse any trends could only be done annually due to the massive amount of data stitching required.
We engaged through the Head of Health & Safety to find a solution to this problem. The organisation was already using TM1 for its financial reporting and analysis. An idea was to build some simple data cubes that would have a standardised format across all regions, with flexibility to add additional fields if required. All historical data was migrated and reconciled. Input sheets were setup to capture all field data straight into TM1 with standardised hierarchies across all sites in Australia. This ended up housing 3 years of data for every site in Australia (Approx 1,500 sites) for every employee in every state. Data could then be refreshed in real time as the data was captured and could be monitored much more efficiently.
Inefficient business processes used to capture Workers Compensation data across a large diverse business. Significant time and non-value-added resource to collate this information across multiple spreadsheets.
Cut down the process from a full time role in each region to a couple of days of collation with data being populated in real time as it was collected.