DataVis

Berlin's Funding Data — An Overview

Fabian Dinklage (@fdnklg) | 02/2018

Berlin's senate department for finance regularly publishes data on how the state of Berlin is funding various institutions in the city. The data is accessible through an online database. Users can query who received funding and what amount of money was disbursed to a given recipient. The data provides more transparency on Berlin's funding infrastructure and allows for further analysis and exploration.

Over the last few months, we have been digging through more than 73,000 individual funding awards. The result is a tool for a visual exploratory data analysis, which allows users to filter the data using multiple categories and explore awards from 2009 to 2017. In addition to this tool, we have built this quick visual overview showing which topics received the most funding, as well as other general trends over time.

Grants from the City of Berlin:

You can filter the dataset based on the following criteria: Volume of money per year or number of grants per year.

Sector

Year

Volume

Amount of grants

Category name

We have chosen a so-called bubble chart in order to show the dimensions time, topic and sum in relation to one another. For those who want a more detailed view of the data, you can use our data exploration tool.

Fabian Dinklage

Über den Autor

Fabian Dinklage

Fabian Dinklage is a student assistant at the Ideation & Prototyping Lab of the Technologiestiftung Berlin in the field of Visualization & Prototyping. He is currently studying interface design at the FH Potsdam. His interest lies in the transformation of data into visual structures for gaining new insights and the development of important human-machine interactions.