From Excel Chaos to Data-Driven MEL Using DHIS2

This community innovation has been accepted at the 2026 DHIS2 Annual Conference as a digital poster.




From Excel Chaos to Data-Driven MEL Using DHIS2

The journey from disaggregated data collection instruments to a solid and integrated Monitoring, Evaluation, and Learning (MEL) system is fraught with challenges to many organizations, both governmental and non governmental, that work in resource constrained environments. This abstract is a case study on an organization that was running projects related to Maternal and Child Health (MCH) and supply chain management that initially used different tools that were not similar (Excel, Google sheets, ODK, and even Asana) to manage projects. This led to data silos, inefficiency and lack of analytical capabilities to support effective programmatic decision making, until they implement DHIS2. Intervention: Using my previous knowledge of DHIS2, I led the customization and implementation of DHIS2 as the overall MEL platform of the organization. This strategic change was to centralize data, simplify reporting and maximize the use of data on district, zonal and regional levels. Findings: The shift to DHIS2 had the positive effect. The ease of use and feel, the ability to collect offline data, and the ability to visualize the data significantly contributed to the high user satisfaction levels. The improved information security and flexibility of DHIS2 allowed ensuring that the system would satisfy more specific demands of different stakeholders, including field level data collectors and national program managers. This transformation allowed to leave behind the data collection routine and built a dynamic MEL system that allowed to make evidence based programmatic changes and enhance accountability. DHIS2 demonstrated its flexibility as it can be not only used as a traditional health facility related data but also as a fundamental MEL infrastructure of a big organization.

Primary Author: Tsegaye Shewangzaw


Keywords:
MEL, Integration, ease-of-use, DHIS2, Customization

12 Likes

Ha! Excel chaos is a catchy title that definitely made me click on this one :laughing:

4 Likes

Great idea! It reflects on situation on the ground in most settings. It pushes for more DHIS2 flexibility and integration capabilities.

2 Likes

Interesting! I am also looking forward to a similar program to the monitoring dashboard for my project.

4 Likes

An innovative approach for data management

2 Likes

Good to see DHIS2 being used beyond health facility reporting as a full MEL backbone.

3 Likes

This is very true. @tsegshsmart
Kudos to you

2 Likes

Very relevant work. Moving from fragmented Excel/Google Sheets/ODK tools to DHIS2 as an integrated MEL platform can greatly improve data consistency, accountability, and program-level decision-making.

It would be useful to know how legacy Excel data were cleaned, mapped, and migrated into DHIS2 during this transition. (Having experienced this myself — Wallahi, that’s chaotic, bro. :grinning_face_with_smiling_eyes:)

3 Likes

I feel you @Sehar_UnNisa I have downloaded the already existing excel based data, cleaned it, made some formatting and arrangement to align with the data sets on DHIS2, I created a dedicated dataset for these and export to DHIS2.

1 Like