Case Study: how Opbox saves A Better Service £140,000 per year

The question

Leadership wanted to monitor a simple metric - how much revenue does each of their waste trucks generate per day - the Revenue, per Truck, per Day.

Simple? Unfortunately not.

The problem

"Revenue" data sits in Xero, "Per Truck" data sits in Big Change (operations software) and "Per Day" data sits in a maintenance schedule on Excel.

The solution

A loooooong manual exercise, every day downloading, cleaning, structuring and building charts - in excel, by an expert (a data analyst or, in this case, the FD).

Opbox removes this pain in 3 simple steps:

1️⃣ CONNECT - Opbox connected to Xero, Big Change and Sharepoint

2️⃣ UNIFY - exported and organised the data into a Single Source of Truth - where it's cleaned*, refreshed and kept up to date

3️⃣ ACT - every week the team log in to Opbox for an updated view of the business's performance at a truck by truck level across all the metrics they use to run the business.

ABS were quoted £100,000 to create a database to allow a £40,000 pa data analyst (which they don't have) to do this exact thing.

Opbox is c.3% of that cost and does not require any technical expertise to use.

If you are struggling to bring multiple data sources together reliably and regularly, give Opbox a shout at info@opbox.ai - we'd love to help.