The challenge

Before the project, Elke Schilling, the founder of Silbernetz, had to manually download the current number of calls from the telephone provider every week and calculate relevant statistics by hand in a rather laborious way. This process took over an hour each time and was prone to errors. In addition, some of the statistics she was interested in were not available on the phone company's web portal. Finally, there was no appealing visualization of the data that could be used for communication purposes.

The data

The project was based on the raw data from over 500,000 calls (as of November 2023) from the telephone company's web portal. Among other things, the data provides information on the location and date of the call and the federal state from which the call originated. Personal data that would have made it possible to identify the caller was already anonymized by the web portal.

The solution

The CorrelAid team developed an interactive R Shiny application that downloads and aggregates the latest data and updates all statistics with just one click, eliminating the need for manual work. The application is also specifically tailored to the needs of Silbernetz: it provides summarized statistics on a monthly, weekly and daily basis and enables analyses at state level. In addition, it provides the user with various visualizations that can be used in presentations or other publications. Working with the raw data also made it possible to calculate new statistics for Elke that could not be calculated before.

The impact

The developed solution frees Elke Schilling from the error-prone and time-consuming work of manually copying and analyzing the data each week - she can now use this time for more important and impactful activities that benefit Silbernetz's mission. As the previous process was a very repetitive task that took over an hour each week, Silbernetz has been able to save significant time since the 2021 project, as the tool has now been in use for over 21 months (as of November 2023). During a follow-up meeting in November 2022, Elke reported that she is still satisfied with the results and finds the visualizations very helpful. She also pointed out that these visualizations support her in the acquisition of further funding, which is crucial for the continued success of Silbernetz.

In addition to Elke Schilling, the (now former) manager of Silbernetz was also very satisfied:

"The visualization of the data has revolutionized our work. As a manager, I often used the maps in discussions with politicians, stakeholders and donors. Our counterparts understood much faster and better our work. We were able to convince existing donors of our impact and gain new ones. The project really was a game changer for us."