Samples of my data work

Oliver’s Data Analyses – A Personal Insight

Hi, I’m Oliver Moldenhauer, founder and managing director of DataStrategies4Change (DS4C). We are now a three‑person team – Dan, Kaan and myself – helping NGOs put their data to strategic use. Many of my projects pre‑date DS4C, but they illustrate how I tackle analytical challenges and which methods I still bring to our team today. Below are a few public examples. (Naturally, I’ve done much more work on dashboards and key metrics, but most of that remains internal.)

Supporter Survey Digitalcourage

In 2018, I organized, implemented and analyzed a supporter survey for Digitalcourage. Amazingly, more than one quarter of supporting members answered the survey! The results are summarized in this Digitalcourage blog post.

Data-Driven Journalism for Investigate Europe.

At Investigate Europe, I was mainly working as one of the two Executive Directors (together with the impressive Elisa Simantke), and my data work mostly focussed on our KPIs and dashboards. However, I found time to work on data analysis for the investigative projects. Examples of my visualisations and contributions to data analysis can be found especially in the following investigations

• Energy Charter Treaty – How an obscure EU legislation threatens our climate goals, Feb 2021

• Europe in the Gas Trap, Oct 2020

• Dirty subsidies – How Europe sabotages its climate goals, Aug 2020

A good example is the following interactive map of Europe, showing the fossil-fuel-related assets that are protected under the Energy Charter Treaty. You can zoom in the map, and hover over the countries to get more detailed data.

In ECT data analysis: Results and Methods, Nico Schmidt from Investigate Europe and I described how we arrived at our main finding

The value of fossil infrastructure in the EU, the UK as well as Switzerland protected by the Energy Charter Treaty is €344.6 billion. This is the result of an analysis by Investigate Europe.

This was a number never former derived that proved important in the further debate about the Energy Charter Treaty (ECT).

Analysis of Wikipedia editors

At Wikimedia Deutschland, I developed fundraising dashboards and automatized monthly, and annual finance reporting, but alas, this is not shareable.

However, the indicators I developed and implemented about the German-language Wikipedia Community:

Stability of the German-language Wikipedia Community

• current version at Wikimedia Deutschland and the

• last version I worked on.

After a lot of discussions with volunteers and the relevant team at Wikimedia Deutschland, I developed two new key indicators: The editors with voting rights and the recurring editors. Those definitions make it much easier than earlier indicators to determine whether it’s always the same authors who contribute strongly or whether there is a healthy influx to the group of authors. (It’s more a case of the latter, with more then 20% of the editors with voting rights gained voting rights for the first time in the last two years.)

To get these indicators all more than 230 million edits in the German-language Wikipedia since its inception are analysed, which needed quite some parallelization of the calculations.