Automating DRUCOM Data Integration: Manual Guidelines and Power BI Solutions for UNHCR Private Sector Partnerships

This project focuses on automating the donor report database for UNHCR Southeast Asia using Microsoft Power BI and Excel. It streamlines data integration processes by merging donor payment data from various sources into a cleaned and unified worksheet.Key Features and Outcomes:<b>Automation Efficiency:</b> Reduced data processing time from <b>2 days to 15 minutes</b>, significantly improving operational efficiency.<b>Data Accuracy:</b> Enhanced data accuracy by <b>98%</b>, minimizing human errors during manual processing.<b>Replicable Workflow:</b> Developed <b>replicable guidelines</b> and a <b>manual user guide</b> for scalability across Southeast Asian offices.This solution supports data-driven decision-making and reporting within the organization, providing a framework for future donor database automation.