New Web Application leads to 80% higher Data Quality
As a competence center, the BFU conducts research and provides advice to reduce the number of serious accidents in Switzerland - on the roads, at home, during leisure time and in sports. It has a public mandate for these tasks since 1938. From research to consulting and education to communication: The BFU offers accident prevention from a single source. Around 130 employees are committed to safety in Switzerland, working closely with national and international partners.
Initial Situation
The Swiss Federal Accident Prevention Bureau (BFU) continuously collects accident and behavioral data in Switzerland - by internal employees, but mostly by external agencies and partners. The collection and the processing of the data are both currently carried out using various software tools and methodologies. This makes the administration, evaluation and use of the data for the BFU time-consuming and error-prone. Until now, the accident data was partly maintained in Excel lists, which led to different versions, time-consuming collection and the requirement of a software with costs for the partners. In some cases, a Microsoft Access solution was used for data collection, which resulted in decentralization and increased risk of data loss. Occasionally, data were reported directly into the statistical tool (SPSS). Due to the fragmentation of all tools, it was difficult to integrate new partners and to evaluate the collected data quickly and easily. The new solution is intended to replace all existing tools in the longer term and to consolidate the data centrally. This should simplify queries and statistical evaluations.
Solution
Thanks to the cloud-based Azure web application, developed on the .NET Framework and Blazor, data collection is now independent of device and location. All partners can access the solution and capture data - even offline. The synchronization of the data acquisition is automatically executed when the internet is accessed. In addition, partners can be entered in just a few minutes and get started right away. New versions of the app can be deployed to the different Azure tenants (e.g. test environment) in seconds via an Azure DevOps pipeline for BFU. Building Azure resources is also automated via Infrastructure as Code.
Adjustments to the surveys can be implemented easily and at any time, resulting in flexibility and independence at the BFU. This means that there is no longer any need for installation on end devices for the collection of data. The interface is intuitively designed for each party, personalized and is available in multiple languages. With the new solution, the BFU can evaluate statistical data in real time and display it visually in the dashboard. The data can also be exported for defined interfaces such as the SPSS statistical tool.
The entire project was carried out in an agile manner. Customer feedback was incorporated directly into the planning right from the start. This also allowed pilots to be set up between BFU and its partners - with just a few steps.
Benefits
- With a simple solution, partners save time on data collection and are more motivated to collect data. In addition, the intuitive design of the solution reduces the amount of training required for partners and the susceptibility to errors.
- Users for external agencies and partners are entered in just a few minutes. This allows data collections to be quickly exchanged with new partners.
- Data collections can be created and implemented independently by BFU.
- All collected data is centralized, enabling evaluations that were more costly or not possible with many individual systems. In addition, the new framework offers higher data quality and more informative evaluations.
- Thanks to the offline function, there is no need dedicated devices, resulting in cost savings and lower licensing costs, as well as eliminating time-consuming updates.
- Audit Log ensures 100% traceability.
- By using the Azure Cloud, the solution is easily scalable, BFU remains independent and can react quickly to its own needs.