Power BI for attaining Sustainable Development Goals
In cooperation with Microsoft Innovation Center-Nepal, the UNDP regional local governance team is piloting a diagnostic tool (Executive Snapshot) developed on Power BI will assist subnational governments (local States, Provinces, Municipalities and Districts) mainstream local SDGs in development plans and budgets. This innovative tool allows layering of different sets of statistical data (i.e.: poverty index (i.e.: MPI, HDI, MICS), public expenditures and citizens’ perception surveys) to be analyzed against (customized) local governance indicators that are essential for the SDGs. Piloting in 3 Asian countries in 2016-2017 (Indonesia, Pakistan, and the Philippines), the tool is also likely to be rolled out from 2017 in Africa and South America.
To support sub-national and local governments’ (specifically district level) prioritization, planning and budgeting processes, and strengthen coherence, cohesion and coordination between different levels of government, a mixed methodology that maps, assesses, analyses, layers, and visualizes different sets of data was developed. The methodology maps, analyses and layers the following data:
- Basic district/province data – “ such as demographic, geographic, economic data
- Development data such as Multi Dimensional Poverty Index (MPI), or Human Development Index (HDI) that is available at district level
- Fiscal data:
- Local revenues, inter-government fiscal transfers, allocations and expenditures
- Analysis of allocation and expenditures by MPI indicators, or HDI indicators
- Local Governance Assessment
Analysis of, and interlinks between the above data sets are visually presented on a dashboard powered by Power BI on an Executive Snapshot dashboard. Additional data sets (such as conflict data, climate change data) can also be linked and layered to the above four base data sets.
The purpose of the Executive Snapshot is to provide decision makers, public, and other stakeholders a comprehensive picture of social development indicators, resource allocations by sectors, public perception of local institutions capacity and the quality of public services at district level.
This information can be aggregated to provide a comprehensive and comparable picture of district by district at provincial as well as at the national level.
The tool will also consist of a survey tool which will allow UNDP to collect data required to create a dashboard. The tool will be a web application, which will be tailored for the need of each country and their states and provinces.