H&J Martin Leverages Logi to Combine Data Sources & Gain Complete View of Business
H&J Martin leveraged Logi to combine all its data in one place and standardize reporting so they could better identify inefficiencies and take corrective action.
Founded in 1840, H&J Martin is a construction company headquartered in Belfast, Northern Ireland. In April 2015, they joined the Lagan Construction Group of companies and now operate two main divisions. H&J Martin Asset Management Services delivers minor works, planned and reactive maintenance, and facilities management services. Construction & Fit Out provides construction services, interior fit out, and refurbishment to the leisure, office, and retail sectors throughout the UK and Ireland.
One of the biggest challenges for almost every organization, is finding that single version of the truth. With separate applications for all of its core functions, from computer facilities management to document management and billing, the H&J Martin Asset Management Services division was struggling to combine all its data for analysis.
To gain a complete view of the business, the division had to manually export data from each system and bring it together in an Excel spreadsheet. This was a time-consuming process that typically only occurred once a month, creating a lot of lag time for people to get a snapshot of their performance and the status of projects. Additionally, the division had a huge internal demand for custom dashboards that they weren’t able to meet using the multiple-application environment.
“We had all these systems and no way of bringing them all together into one arena for analysis,” said Jim Cray, Operations Director of Asset Management Services. “We needed a solution that was affordable and could connect to a wide variety of data sources.”
We can see all our data at the push of a button, whereas before we were having to take data from one source and another source and join it together. All that reporting is now at our fingertips.
After considering a number of solutions, including Qlik, H&J chose Logi to bring their data together in an efficient, user-friendly way. Mr. Cray explained, “Logi was our preferred option. It was affordable, it met our needs, and the training was fantastic. We started to develop and create reports very, very quickly.”
To address the demand for custom reports, H&J took time to truly understand its users’ needs. The team met with each department and determined their key performance indicators (KPIs) and analytics needs, then created standardized reports and views. These dashboards are now available in real-time via a web-based portal.
About 100 internal support staff uses the portal daily to access reports on progress and financials and compare KPIs against internal and external service-level agreements (SLAs). Since the portal is both permissions- and role-based, H&J has also opened up reporting to its external clients, providing them with transparency into the company’s performance. Next, they plan to make Logi the core reporting system for the 50 or 60 companies in their supply chain.
Among the data sources the Logi reporting portal pulls from is H&J’s mobile working platform, an app the company developed five years ago to meet the business needs of its 145 field engineers.
Previously, these users had to physically go to the home office to pick up or drop off orders. Now using the app, they can log a variety of data, including start and finish times, credit card expenses, and client signatures. With the advent of Logi, management can bring in that data to analyze the engineers’ productivity.
Thanks to Logi’s reporting capabilities, H&J Martin is now able to identify inefficiencies and take corrective action quickly. This both increases their productivity and avoids the costly financial penalties of missing SLAs.
Mr. Cray explained, “We can see all our data at the push of a button, whereas before we were having to take data from one source and another source and join it together – and we’d only do that maybe at the end of the month. So all that reporting is now at our fingertips.”
Through standardized dashboards, H&J Martin can also measure its performance for contract KPIs, reactive response, planned/preventative maintenance, and more.
“We can see how our engineers are performing, we can see how our supply chain is performing – who’s falling behind and why,” Mr. Cray added. “There are loads and loads of benefits and cost savings that we have gotten from the product.”
The Global Services Dashboard, for example, shows the productivity of the company’s internal engineers. The data, which Logi automatically imports from the mobile working platform, includes time spent on productivity, travel, training, holiday, sick, etc.
Users can drill down by individual engineer or look at the percentage of overall productivity. H&J can then compare the engineers’ overall performance against its target (in this case, the national average of 65 percent productive).
“It’s a first-class product,” Mr. Cray said of the company’s experience using Logi. “It evolves and is under continuous change when there’s different demands on us to do different things with it.”