The client had previously used Microsoft Excel to manage the database but to make it more modern, accurate, reduce mistakes, and able to be visualized and analyzed, we were contacted to help manage the database and visualize the data.

Apart from our normal unpack session during the early period of the project, the client requested another session, named capability workshop, to learn about data processing and analysis in general. We held two sessions with MOVE and UNDP as our participants at our office.

The client had heard about KoboToolbox and would like us to customize the tool for their specific use case. We also needed to migrate the existing data to a new database. Some data need to be updated through our shared codebook to unify all variants of the same term. The data collection form had to be adjusted to satisfy various requirements from their internal teams. In the end, we created a dashboard to visualize all the data for the public with Google Data Studio as shown below.

Overall, we suggested and orchestrated many data tools together to satisfy specific requirements of our client. This organized violence data collected by Institute of Asian Studies was already valuable, but it has become more accessible through better data processing and dissemination.

Monitoring Centre on Social Cohesion and Resilience