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:
- Economical structure, which matches the legal structures (how was the money spent)
- Management hierarchy (who of the managers is responsible)
- Organizational hierarchy (which organizational unit is doing the work)
- Public structure (how things are presented on the website)
- Time
- Geography
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.
