Many view technology as something cold a mere combination of servers, pipelines, and lines of code. But at UrbaDigital, we’ve learned that behind every data point on a dashboard, there is a human story waiting to be addressed.
A timely piece of data in Health, Education, or Child Protection is an intervention that can save a life, build a bridge to better opportunities, and prevent vulnerability.
This is the core of our work on the CAMEL Program Dashboard for ChildFund International, a global organization dedicated to connecting children and youth with the resources they need to grow up safe, healthy, and educated.
To bridge the gap between complex raw data and actionable insights, UrbaDigital applied a comprehensive, multi-phased methodology aligned with ChildFund’s specific programmatic needs:
1. Deep Discovery and Requirement Definition Technology must serve the people using it. We began with a series of Discovery Sessions involving key stakeholders, including the VP of Programs, the global Monitoring, Evaluation, Research, and Learning (MERL) team, technical advisors, and country offices. This allowed us to align the dashboard with ChildFund’s MEL Data Model, structuring the architecture to answer six vital questions:
2. Automated Data Pipeline Development (ETL) To ensure high-quality, near real-time information, our data engineering team designed a robust pipeline to connect the built-in APIs of both DHIS2 and CommCare. We built an automated Extract, Transform, and Load (ETL) process that channels this data into a centralized AWS-based Data Warehouse (Analytics Platform). This eliminated manual data crunching and ensured minimal latency.
3. UX/UI Design and Data Modeling in Power BI Understanding that the dashboard would be used by everyone from global executives to regional directors and local managers, we prioritized a “drill-down” user experience. We mapped the data points to design an interface in Power BI where leaders can view high-level global organizational performance, and with a few clicks, investigate specific bottlenecks in a single country or village.
4. Training and Handover To guarantee the long-term sustainability of the project, our methodology included comprehensive documentation covering pipeline architecture, data models, and customization guides, alongside dedicated training sessions for key users.
Accelerating Digital Evolution: Scalable Tech Solutions for Government, Finance, and Enterprise
Subscribe to our newsletter for expert insights, industry news, and practical tips delivered to inbox.
Urbadigital is a registered trademark
