Home Case studies Database development for streamlined data management
Education
Database development for streamlined data management
Viamonde provides fully supervised ski and snowboard programmes for school groups. They needed a database that was user-friendly and accessible from anywhere that was central to operations.
Robert Perris - Director
Viamonde
The database can be accessed from anywhere at any time – including when taking groups onto the ski slopes.
With data centralised, it can be kept accurate and up to date. It is immediately available to those who need it, to help improve the customer experience.
Reporting is now at a click of a button, enabling reliable data to be presented to staff and stakeholders quickly for review.
Customer challenges
Due to not being able to access or store client information easily, staff were using different methods to record data – some online, some paper-based. This started from when a job was first raised and resulted in the information being recorded inconsistently making planning difficult.
As often staff members had limited access when skiing with young groups, they couldn’t access the information needed, this could include dietary requirements and medical data of any particular child. Not having accurate data readily available caused processes to be less efficient and customer service could suffer.
The brief
Viamonde wanted a new system that would consolidate their data into one system and make it easier to manage. They needed database development so it would display, filter and sort key information enabling employees to easily find requirements for each client. This information needed to be specific for each child e.g. food allergies.
They were keen that the solution managed the process from beginning to end. They wanted to be able to create a trip from the moment a school gets in contact and then use the database to continue adding information before, during and after the trip. Robert wanted to give their customers access to parts of the system so that they could review and submit information relating to their trip in a more efficient manner, rather than the current system of emailing Excel files.
The solution
Database development
We developed a bespoke online software application which is easy for staff to access from anywhere. They can view and manage client data on-the-go, enabling them to provide customers with a more superior customer service. Accurate information can be captured early in the planning process which will inform the rest of the trip. They can also store notes and information during and after the trip to help the post-trip reports.
The new system allows Viamonde to allocate accommodation and staff to trips, checking for duplicate information, or issues (such as a double-booked ski instructor). This not only saves time but identifies any issues so they can be quickly resolved. A calendar system is used to display ongoing jobs and availability making it easy to identify slots for new bookings.
The solution
Web-based interface
Our Oxford-based team created a simple interface which allows staff to input, access and report on client jobs easily. It is accessible from anywhere with an internet connection, which is particularly important during the operational seasons, as they travel a lot and are not based in the main office all the time. The team can access and edit data at any time – even months after the trip has finished.
Viamonde can now plan their programmes, transport and even the meals for each trip and generate PDF reports for both customers and staff at the click of a button. Output options enable staff to tailor the reports to their departments and needs, meaning they will only see information relevant to them. This ensures the system is efficient for each individual member of staff.
The benefits
The new software allows Viamonde to provide an enhanced customer experience. By centralising the data into one system, they can now access and manage in a more logical streamlined manner. This has allowed for a more efficient way of managing their clients’ stays and requests. This benefits the staff, as their jobs are made easier and their clients looking to enjoy a seamless trip.
Tim Ault
Business Development Director
“We design and develop software solutions and websites that make organisations more efficient and grow. We can do the same for you”.
Education
