Regional Cooperation and Integration and Trade Innovations Seminar Series (RCIT ISS) No.14 - RCI Dashboard: Harnessing Power BI for monitoring RCI Operations 28 July 2023 Philippines As one of ADB’s seven operational priorities under Strategy 2030, RCI operation needs to be closely monitored. By volume and number, the pre-pandemic annual share of RCI projects in total ADB-financed projects is about 25% spread across the different regional departments. Of ADB’s RCI operations, Southeast Asia represented the largest share (35%) followed by Central and West Asia (34%), South Asia (19%), East Asia (5%), and the Pacific (3%). The inter-subregional share stood at 3%, including, among others, projects in high-value agricultural value chains, inclusive finance, and information and communication technology (ICT). RCI information is used in various documents but there is no centralized and web-based database or dashboard that will make efficient the gathering and analysis of data. The Regional Cooperation and Integration and Trade Division (CCRC) developed an RCI Dashboard using Power BI, which is a powerful business intelligence tool developed by Microsoft. Power BI is primarily designed for data visualization and analytics, it can be effectively used in project management to gain insights, track progress, and make data-driven decisions. Objectives: This session: Presented basic features and use of Power BI Introduced the RCI Dashboard and show how to tap Power BI in developing similar databases. Program and Learning Materials 28 July 2023 Session / Activity Title Speaker(s) Welcome remarks Cyn-Young Park, Director, Regional Cooperation and Integration and Trade Division, Climate Change and Sustainable Development Department, ADB Overview of Power BI Raul Gatmaitan, Operations Analyst, CCSD, ADB Power BI in ADB Projects Eduardo Angeles, Consultant, CCRC, ADB Moderated Q&A Aileen Panglinan, Senior Economics Officer, CCSD, ADB Disclaimer The views expressed on this website are those of the authors and do not necessarily reflect the views and policies of the Asian Development Bank (ADB) or its Board of Governors or the governments they represent. ADB does not guarantee the accuracy of the data included in this publication and accepts no responsibility for any consequence of their use. By making any designation of or reference to a particular territory or geographic area, or by using the term “country” in this document, ADB does not intend to make any judgments as to the legal or other status of any territory or area. Event Coordinator/s Aileen Pangilinan Related Full Agenda List of Participants Overview of Power BI - RGatmaitan.pdf RCI Dashboard - APangilinan EAngeles.pdf RCIT ISS 14 - RCI Dashboard - Summary Report.pdf ADB Organizer/s Regional Cooperation and Integration, and Trade Division Topics Regional Cooperation and Integration