New Web Application leads to 80% higher Data Quality

Data used to be collected through various tools and Excel lists, but today efficiency has increased thanks to unification in one collection tool. The new framework allows easier connectivity for partners, is device and location independent, and reduces effort for everyone involved.

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.

%
reduction of the susceptibility to errors in data collections
Test Icon
no more device dependency during data acquisition
central interface as a replacement for different capture tools

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.

Steffen Niemann

Research assistant | BFU

«The collaboration has been worthwhile: Finally, we can use a modern software tool for our numerous data collections. The regular meetings of the entire project team were central to the development. Only in this way could we create a common understanding and meet all the requirements.»

More success stories

Sitzung mit 3 Frauen und einem Mann in einem Büro

LGT

Collaboration with Change Management strengthened: LGT relies on Microsoft 365 and Copilot

Helion isolutions Story

Helion Energy AG

Digital Transformation for Energy Pioneer Helion

Shell Lubricants Öl wird bei einem Auto in die Hube geleert

Shell Lubricants Switzerland AG

Efficient Product Planning in Seconds thanks to new Web Application

SBB Zug von vorne am Zürich Hauptbahnhof

SBB

From Migration to long-term Partner: SBB on the Path to Digitalization with isolutions

Forumlar für den Test von Drogensubstanzen

Stadt Zürich Drogeninformationszentrum

Transformative Efficiency: How DIZ optimizes its Service thanks to Low-Code App

Drei Personen stehen und reden in einem Sitzungszimmer

MLL

Evaluation expertise: How isolutions helped MLL Legal to select an efficient and neutral partner

Mehrere Kühe auf einer grünen Weide

Swissgenetics

Efficient Customer Service and Process Optimization thanks to digital CRM Solution

Zwei Schweizer Seilbahnen fahren den Berg hinauf

Seilbahnen Schweiz

Better accident prevention thanks to new accident database

Bell Food Group

Bell Food Group

The training portal successfully supported the introduction of Microsoft 365

Mann schaut auf das Handy mit der offenen Well Gesundheits-App

Well

The Modern Workplace as an Enabler for Innovation in the Healthcare Industry

Labor Diabetes Center Berne

Diabetes Center Berne

More flexibility in diabetes research thanks to Azure and Workplace as a Service

Junge Studenten sitzend im Schulzimmer am Laptop

edupool.ch

Digital and modern Exam Management: Automation, Flexibility and increased Efficiency

LOWA Wanderung

LOWA

Modern workplace without internal IT specialists

SalutaCoach Applikation

SalutaCoach

Thanks to new application to reduction of numerous additional efforts

Expertsuisse Header

EXPERTsuisse

Support and Project Manager for successful Evaluation Process

Swissgrid Headquarter

Swissgrid

New Contact Center Solution for a Modern Workplace with more Scalability and Flexibility

Lusee isolutions Story

Lusee

Thanks to interactive Conversations increased Sales Opportunities

Fachhochschule Nordwestschweiz Migration Microsoft Teams

Fachhoschule Nordwestschweiz

Lower Licenses Costs with Microsoft Teams Telephony

V-ZUG - Story

V-ZUG

International Business driven by Introduction of Microsoft D365

BOBST Life Program

BOBST Group AG

Employee Experience 2.0 - Leading Innovation BOBST Life Program for 5'000 Employees

Securitas Group Microsoft 365

Securitas

With the Introduction of M365 to the Company Culture Booster

Migros Collaboration Platform

Migros-Genossenschafts-Bund

Digital Identity, M365 Toolkit and better enterprise-wide Communications

Rotpunkt Apotheken - Story

Rotpunkt Apotheken

Increased Efficiency and fewer Excel Lists thanks to Microsoft D365

BFU IT Framework

BFU

New Web Application leads to 80% higher Data Quality

AMAG Gebäude von aussen in Zug

AMAG

Future Workplace with M365 Suite rolled out to 6'500 Employees

Innosuisse IT Plattform Azure Cloud

Innosuisse

Efficiency Increase of the Innovation Promotion Process thanks to individual Solution «Innolink»

KIBAG Digitaler Arbeitsplatz

KIBAG

Successful Introduction of the digital Workplace thanks to User Adoption for 1'200 Employees

Gartenmann Engineering WaaS

Gartenmann Engineering

From successful Cloud Transformation to secure and reliable Operation

Rega

Rega

Increased Security in Operations thanks to Migration to the Cloud and M365

Swisstransplant - Story

Swisstransplant

Digitization of Processes for improved Planning and as an Innovation Driver