Complex data to Dashboards using R and Google Data Studio

 

This was a two year project defining the KPIs for a multinational NGO, with activities in 8 countries. The main challenges were lack of standardisation across the organisation, and the users need to aggregate information along different and sometimes partly overlapping dimensions:

The most important part of my work was to define these dimensions, and map these against each other. This way any of these can be used to show info on the dashboards or reports.

The second most important part of my work was to define the concepts used. As the organization was largely created by national organizations joining ProVeg international, there was a need to standardize concepts like what is a department and what is a project.

The Dashboard was made for internal use, so it is not available online. The images below are from a working prototype, needing still the touch of a designer. All labels need some work and some of the data was still of poor quality. They do also include comments and questions for stakeholders.
Each item is clickable, allowing a digging deeper into the data.

internal_top_level_report

Contact