Develop an Interactive Power BI Dashboard for Local Governance Project Mapping

The main priority of the Regional Hub is to provide UNDP Country Offices in Asia and the Pacific with easy access to knowledge through high quality advisory services based on global applied research and UNDP lessons learnt. The second priority is to build partnerships and promote regional capacity building initiatives, which allow UNDP, governments and other development partners to identify, create and share knowledge relevant to solving urgent development challenges. The Bangkok Regional Hub mainly focuses on support to Democratic Governance, Environment & Energy, Crisis Prevention and Recovery, Poverty Reduction with an overarching effort on achieving the Millennium Development Goals.

The UNDP Bangkok Hub for Asia and the Pacific (BRH) Governance Team maintains a living mapping of local governance and local development projects across the Asia-Pacific region. This mapping covers currently over 166 projects across 27 countries, capturing data on thematic focus areas, SDG alignment, intervention types, donor partnerships, budgets, project status, and geographic coverage. The mapping currently exists as an Excel workbook and needs to be transformed into an interactive, web-accessible visualization to support programme oversight, knowledge sharing, and evidence-based decision-making. The Online Volunteer will develop a Power BI dashboard that enables users to explore the data through interactive maps, filters, and charts, and will configure it for embedding on the UNDP website. This contributes directly to SDG 16 (Peace, Justice and Strong Institutions) by strengthening transparent and accountable governance programming, and to SDG 17 (Partnerships for the Goals) by enhancing coordination and visibility of development interventions across the region, as well as to SDG 11 (Sustainable Cities and Communities).

We are looking for one experienced Online Volunteer who, under the supervision of the BRH Governance Team, will support the development of an interactive Power BI dashboard to visualize the mapping of local governance and local development projects across Asia and the Pacific. The mapping currently exists as an Excel workbook containing 166+ projects with data on thematic focus areas, SDG alignment, intervention types, donor information, budgets, and geographic coverage. More specifically, the Online Volunteer is asked to: - Review and clean the source Excel mapping file in coordination with the BRH Governance Team, and structure the data into a Power BI-optimized model with appropriate table relationships. - Design and develop an interactive Power BI report/dashboard including a geographic map visualization, filter panels and slicers (country, status, thematic focus, SDGs, donors, budget), summary statistics, and detailed project drill-through pages. - Ensure the dashboard is visually aligned with UNDP branding guidelines which will be provided, with cross-filtering enabled so that selections in one visual dynamically update all others. - Produce a completed report on Power BI, generate and provide the embed code for website integration, and share the final file (.pbix). - Draft a brief user guide (max. 4 pages) covering how to update source data and refresh the report, and conduct a handover session. - Participate in regular online check-ins (approx. 30 minutes per week) to discuss progress, clarify open questions and share challenges. An initial onboarding call (60 minutes) will be held to provide instructions and context before the assignment begins.