Developing a web app to export business data 8x faster for a transport company

Transforming the process: Developing a bespoke web app to increase productivity by 8x

We developed this bespoke web app for a public transport solutions company. They wanted to digitise their data collation process to introduce automation and boost their productivity. The software needed to streamline the process, outputting an actionable spreadsheet that would seamlessly plug into their existing process.

The company specialised in modelling transport systems and public transport. This meant that their work involved evaluating disruptions to traffic, including roadworks, closures, and diversions.

In the original data collation process, the client had to manually collect data from ordnance survey maps, cross-referencing with an archive of public transport information. Then the data had to be manually organised in an Excel spreadsheet before it could be processed or revenue could be generated.

Throughout initial consultation and discovery workshops, we designed an intuitive map-based interface that downloaded data from Transport API.

The software automatically collated bus route information for an area drawn by the user. We customised the software to export data tailored to their existing spreadsheet template, making internal adoption frictionless.

Implementing the software needed to be seamless. Before digital transformation, the process took up to two days before our client could deliver — a key aim was to improve the billing cycle to generate a faster return on investment (ROI).

Using the new bespoke web app, our client reported being able to complete the work up to eight times faster (without increasing their team size!) This increase in productivity made the client a rapid ROI on their web app development costs.