From spreadsheets and multiple systems to 10,000+ jobs tracked in a single live dashboard
How HTS (Property & Environment) turned messy data into insights to act on, with Datore.
- 10,000+tracked live
- 2 clicksto see most overdue jobs
- Automateddaily job digests for ops managers
- 5 stagesof job lifecycle in real time
It simplified the analysis for us. Rather than looking at loads of numbers, it gives a quick snapshot without needing to know what the data should look like.
HTS (Property & Environment) Ltd - Local Authority Trading Company, owned by Harlow Council
- Sole (R&M) provider to Harlow Council, managing social housing repairs and maintenance across the borough
- Specialising in: roofing, plumbing, gas repairs, electrical, damp works, carpentry, and environmental works
- Managing thousands of open jobs at any time, across emergency, urgent, and standard SLA categories
- In the process of migrating from a legacy system to a new MRI maintenance platform
Spreadsheets, static reports, and a backward view of performance
HTS (Property & Environment) Ltd had plenty of data - but getting anything meaningful out of it meant hours of manual work. Their legacy maintenance system produced only static, generic reports: a snapshot of jobs completed or in progress, with no ability to drill down, spot trends, or act fast.
Managers were compiling their own analysis in spreadsheets, building formulas by hand, and still ending up with an out-of-date picture.
Monthly client reporting took days of copying, pasting, and reformatting - across every contract.
From messy spreadsheets to clarity - The Impact Pathway in Action
- Connect & Map
Datore connected directly to HTS's legacy maintenance system, extracting historical job data and building the automated data pipelines needed to feed a live analytics platform.
We mapped the full job lifecycle - from call raised to job closed - across five distinct stages, and worked alongside managers and engineers to understand what decisions the data needed to support.
- Build & Embed
We built a live repairs and maintenance dashboard giving managers a real-time view of all open jobs - by area, job type, SLA status, and priority.
Engineers now receive automated digests categorising jobs by urgency rating.
We also worked with operatives to improve the data entry process to ensure reliable timebased analysis.
- Migrate & Scale
With the migration to a new MRI system, Datore is managing the data transition, preserving historical trend data so year-on-year and month-onmonth analysis remains intact.
The same dashboard framework now also covers HTS's environmental works system, tracking productivity across communal area maintenance, fly-tipping clearance, and landscape works.
Tracking time across job stages revealed process patterns that nobody had visibility of before. This is where the real change management work begins — giving HTS the confidence to have honest conversations with their operations team, not to monitor people, but to understand where the pressure actually is and resource them better.
Real-time visibility & automated reporting
- Managers start each day with a live view of all open jobs - by area, category, and SLA status - no manual compilation needed
- In two clicks, managers can identify most overdue jobs, compare suppliers’ performance & identify the location of engineers.
- Ops team receive automated daily digests prioritising jobs due today, within 24 hours, and within 3–10 days - reducing missed SLAs
- Five stages of the job lifecycle are now tracked in real time - HTS can now analyse time per task and improve processes
- Monthly client reporting, previously built by hand in Excel, is now automated - saving significant back-office time each month
The Datore difference
HTS evaluated three solutions to do more with their data. They chose Datore for the individual touch:
“Datore felt approachable, really listened and understood our needs”
The difference isn't just technical. Datore is embedded within HTS's operations, working alongside engineers and office staff to support the data capture process, change management and the use of insights to create a tangible business impact.
HTS appreciates how agile the Datore team is:
“Every time we talk about improvement on a particular dashboard, it’s very quick. They’re very responsive, no need for consultation upon consultation.”
You could say that it was more of that personal touch and the approachability was there. Whatever we discuss, it can be put into action pretty quickly as opposed to waiting for it a couple of days or weeks like with other providers.
Want answers like these from your own data?
A 30-minute call. Bring your messiest question - we’ve heard worse.