From Survey Data to Charts: An App for Streamlining Data Visualization Workflows

More in Common collects survey data to better understand the social cohesion of German society, but transforming this data into visual insights currently requires a manual, time-consuming workflow. In this project, we develop a Shiny application that automates key steps—from data extraction via the Crunch API to preparing and generating visualizations with Flourish. Building on existing prototypes, we improve data processing, ensure accuracy through testing, and design a user-friendly interface to create polished visualizations. The tool also supports export to PowerPoint and potentially other formats. By reducing manual effort and increasing confidence in the accuracy of results, we help save valuable employee time, improve More in Common’s already strong evidence-based communication, supporting their mission to foster social cohesion.

VisualizationAutomation Survey

Status: Project Work
Project Period: May 2026 – ongoing
Partner: More in Common e.V.

More in Common is an organization wholly dedicated to the issue of social cohesion. Its goal is to foster a society that is strengthened at its core and capable of responding to social change in a united and resilient way. In its understanding, social cohesion is far more than peaceful and considerate coexistence; it is a prerequisite for a central element of a vibrant democracy: the ability to engage in constructive disagreement across differences. The organization is nonpartisan and collaborates with institutional partners from a wide range of sectors. It operates teams in the United States, the United Kingdom, France, Poland, Spain, Brazil, and Germany, working and learning across borders.
Homepage