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.
Quick project overview
- Transport data API integration
- Quickly imports relevant operational data
- Map-based area selection tool
- Allows the user to select transport data visually
- List-based bus stop / route selection interface
- Enables the user to prune data before download
- Excel export modelled on the existing process for seamless adoption
- Users can download a bespoke Excel report tailored to the business process
- Secure user login and account system
- All data and sessions are siloed to users' accounts