Request for Proposal For Consultancy For Designing An Integrated Programme Performance Tracking Dashboard For Dca South Sudan Using Powerbi

Request for proposals are invited for Consultancy for Designing an Integrated Programme Performance Tracking Dashboard for DCA South Sudan Using PowerBI. Closing Date: 4 Nov 2024 Type: Consultancy Consultancy for Designing an Integrated Programme Performance Tracking Dashboard for DCA South Sudan Using PowerBI Introduction DanChurchAid (DCA) is a Danish Humanitarian and Development Organization, which primarily works with both local and international NGO partners, and its a strong member of international networks/alliances including churches. DCA is headquartered in Copenhagen and has offices in 19 countries worldwide. It seeks to assist the most marginalized populations through its three global goals Save Lives, Build Resilient Communities, and Fight Extreme Inequalities with a cross-cutting focus on Gender Equality, Youth Engagement, and Environmental responsibility. DCA works with local communities and is increasingly involved in building the capacity of partners, communities, and local government institutions as well as its staff. DCAs South Sudans office is based in Juba and implements programmes through its partners in Jonglei, Upper Nile, Eastern Equatoria, and Central Equatoria states. This Terms of Reference (ToR) for Consultancy describes DCA South Sudans plan for Designing an Integrated Programme Performance Tracking Dashboard- a One-stop center for tracking the programme and strategy progress and inform evidence-based decision-making. The ToR outlines the background to the assignment and the expected deliverables. Guidance has also been provided for the competitive bidding and sourcing of the Consultant. Project Background Annually, DCA Country Offices report on their contributions to global results framework indicators. However, DCA South Sudan Country Office is faced with significant gaps in systematic mechanisms for tracking the performance of key output and outcome indicators. Accordingly, the DCA South Sudan MEAL team is working on creating a centralized database to aggregate and visualize data from the various partners and projects under HRMA and EAT Programmes. This will provide a mechanism for tracking activities, output and outcome indicators as well as budget performance. The data visualization will be leveraged on PowerBI platform. Objectives of the assignment The primary objective of creating an integrated PowerBI dashboard is to offer a centralized platform for monitoring project and strategy progress in real-time, enabling informed decision-making through timely access to relevant information. Specifically, the dashboard will integrate the following: Process monitoring: Focusing on monitoring activities, and tracking the quality of services delivered by DCA partners to the rights holders Context monitoring: Focusing on the market price monitoring, especially for the cash-based interventions Results monitoring: Focusing on monitoring project indicators against targets and KPIs at output and outcome levels, disaggregated by project, partner and location etc Finance monitoring: Integrating budget performance monitoring vs the activity implementation. Use of the existing information management systems for beneficiary data management, reporting and data visualization e.g seamless integration with Kobo and RedRose platforms Evidence and learning: Focusing on the integration of data from project reviews, documentation of change stories and program accountability mechanisms. Scope of the assignment The design dashboard of the PowerBI dashboard will aggregate data from two programmes of HRMA and EAT implemented by DCA South Sudan. Specifically, data for over 20 projects including activity, output, and outcome indicators as well as strategic indicators will be integrated into the dashboard. The PowerBI dashboard will synchronize data from the existing data collection platforms such as Kobo Collect, RedRose and financial reporting systems. The following modules will be integrated into dashboard design. Beneficiary data management: A master beneficiary database has been designed to capture beneficiary data for activities at project level. Currently, an excel template is used to register and store beneficiary data and enrol them into different activities based on the vulnerability and selection criteria; this process will be automated and integrated into PowerBI. The primary beneficiary profile data, including age, sex, location, vulnerability, support received, and composition of other household members are captured at the time of registration. Routine Activity Monitoring: The routine monitoring data collection process will be automated using Kobo mobile data collection platform. The reach and distribution of inputs will be tracked based on the beneficiary lists. Additionally, training and awareness raising sessions will be tracked using a standard checklist developed and integrated into Kobo platform. Routine monitoring will also involve real-time monitoring and verification visits, on-site distribution monitoring conducted by the MEAL and partner volunteers. The monitoring data collected through Kobo will automatically synchronise with PowerBI platform for visualisation. Post-Distribution Monitoring (PDM): The PDM data is collected on the project participants utilization, timeliness and satisfaction with cash, emergency shelter/NFI and seed distributions. The PDM uses mixed methods, including a quantitative survey, key informant interviews (KII), and focus group discussions on measuring the key questions. The key objective of the PDM is to reinforce accountability, improve programming, and identify and prevent any protection risks. The primary quantitative data collection will be leveraged on Kobo mobile data collection platform and synchronized with the PowerBI platform for indicator tracking and visualisation. Manual paper-based tools will be used for qualitative data collection and the final analysis results are integrated within the dashboard. Outcome Monitoring: Outcome monitoring is critical to understanding if activities are achieving or on track to achieve the stated outcome(s) and the project objective. Annual strategy outcome monitoring will be conducted. Regarding the interventions and the indicators that will be tracked, outcome monitoring will use several data collection methods, including primary quantitative beneficiary-based survey and qualitative data collection through key informant interviews, focused group discussions and case studies. A review of the project reports and other secondary data sources, including context monitoring reports, will also be used to triangulate and validate the findings before integrating into the dashboard. Context Monitoring: DCA partners collect market price data from local vendors to understand the availability and the prices of key food commodities, wage labour rates and fuel. The market price monitoring tool is leveraged on Kobo platform. The market price monitoring tools have been aligned with the REACH Joint Market Monitoring Initiative (JMMI) tool. With the proposed dashboard, market price information will be integrated into PowerBI and the dashboard refreshed on bi-weekly places. The visualisation will include the local market information such as currency exchange rates, daily labour rates, and the availability and pricing of food commodities, including the minimum expenditure basket (MEB). The market monitoring data collected will be used to guide the cash value, ensuring that the program is not having adverse effects on the local market prices. The markets to be surveyed will include the major domestic market areas in the respective partner project locations. The number of markets to be monitored will be determined by the partners presence. By monitoring the price trends, the survey allows the prediction of how the external situation might influence the projects and vice versa. Price increases above an unacceptable threshold or lack of supply may be used to trigger remedial actions, including those identified at the planning stage. The specific objectives of the market monitoring are to: Monitor and map of commodity price trends Assess the level of food availability in the local markets Assess the effects of aid interventions on the markets and participating traders. Accountability to the affected population (AAP): DCA-Partners have been provided with an excel template to aggregate and track all the feedback received from the different feedback mechanisms, including community meetings, suggestion boxes, phone calls as well as direct feedback received through staff, among others. The feedback data will be integrated into PowerBI for visualisation and reporting. Specially, the number of feedback received, types of feedback, mechanisms used, and the status of each feedback are some of the common indicators that will be integrated in the PowerBI dashboard. Approach The design and implementation of the integrated project performance monitoring dashboard will adopt a participatory approach involving consultations and input from the MEAL, Programmes, Senior Management Team (SMT), Finance and other key support teams. This process will be led by the MEAL-Manager in collaboration with the MEAL Specialists for HRMA and EAT-Programmes and Finance team. The dashboard will fully align with the DCA Global MEAL standards, and results framework and donor requirements. The activity, beneficiary data and budget will be synchronized to enable timely data collection, visualization, learning and adaptation. The Consultant will hold an inception meeting with the project core team to better understand and define the user-requirements specifications. Any technical guidance or modifications shall be agreed at this stage. The design of the dashboard will adopt a progressive approach, with an opportunity to incorporate new projects, indicators and activities and updating the indicator Tender Link : https://reliefweb.int/job/4102979/dca-request-proposal-consultancy-designing-integrated-programme-performance-tracking-dashboard-dca-south-sudan-using-powerbi