Business Intelligence

Download this Page

 

 What is the GMS Business Intelligence (BI) Top

 
Country-based pooled funds (CBPFs) are multi-donor humanitarian financing instruments established by the Emergency Relief Coordinator (ERC). CBPFs allocate funding based on identified humanitarian needs and priorities at the country level in line with the Humanitarian Response Plan (HRP). 
 
The GMS Business Intelligence Portal (BI) is a tool that displays CBPF data in a meaningful and useful way which helps users to analyse the funding process with a consolidated view. You can access the Business Intelligence Portal at this address: https://pfbi.unocha.org/ 
All CBPF BI data is live and  publicly available for everyone to use and download latest CBPF allocation and contribution data.
 
In the BI, data trends are illustrated through eye-friendly, analytical, and thematic visualizations. This information management platform is structured in nine different sections. Please find a brief overview on each of the section below. 
 

 Allocations Overview  Top

 
The BI main data visualization tool displays all CBPF projects’ data in one interactive map : the Allocations Overview. 
 
 
Users can see all allocations and projects funded through the CBPF on the map.
 
Moreover, users can personalize the map by applying the following filters : 
  • Year
  • Humanitarian Pooled Fund
  • Partner type (UN Agency, National NGO, International NGO, International Red Cross/Red Crescent Society)
  • Cluster
  • Allocation type
  • Location Level (the administrative and structural level of governance)
The map also allows the users to generate a list of all projects according to the filters applied. This list can be downloaded on desktop as an excel sheet. 
 
*Please note, for more information on this visualization, refer to the tutorial video. You can access the video by clicking on this video icon : 
 

 COVID-19 Allocations Top

 

The COVID 19 Allocations visualization is a set of two visuals providing real-time information on CERF and CBPF allocations responding to the 2019 COVID Pandemic. It is composed of the Distribution of Allocations map, and the Allocations Timeline.
 
The COVID-19 Allocations map is an interactive map displaying in real-time all CERF and CBPF allocations responding to the COVID-19 Pandemic. It is public and allows users not only to visualize at a glance the global and in-country situation, but also to extract projects’ raw data as Excel sheets.
 
The Allocations’ Timeline displays the key dates and milestones related to OCHA's response to the pandemic, including CERF and CBPF allocations.
 
To learn more about this visualization, you can refer to our dedicated article on the Help Portal or watch this tutorial video .
 
 

CBPF Funding Targets and HRP FundingTop

 

This dashboard provides an overview and tracks progress of CBPF funding against requirements and funding levels of HRPs in each country with an active pooled fund.
 
It includes a global data section, a breakdown of CBPF funding targets by Fund, and details on CBPF for which no HRP exist.
 
To learn more about this dashboard, watch our tutorial video .

 CBPF GAM MarkerTop

 

The Gender with Age Marker used in CBPF projects is a tool that codes – from 0 to 4 - whether a humanitarian project is designed well enough to ensure that women/girls and men/boys will benefit equally from it or that it will advance gender equality in another way.
 
Since January 2019, all projects submitted in the Grant Management System (GMS) are required to provide a GAM code and reference number.
 
The new GAM Beeswarm Chart draws on this newly added data to the GMS to enable humanitarian stakeholders to visualize the allocated funds according to the Marker code.

In the beeswarm, each circle represents aggregated CBPF projects according to their Marker code (from 0 to 4). The size of the circle depicts the number of the projects for that CBPF-Marker, while the position of the circle along the horizontal axis depicts the amount allocated (as value in dollars, as a percentage of the total value for the Marker or as a percentage of the total value for the CBPF). The color indicates the Marker code (from red for GAM 0 to blue for GAM 4). 

 

ContributionsTop

 
CBPFs allow Member States and private donors alike to pool their contributions to support specific humanitarian responses. They ensure that timely, coordinated, and principled funding is available and prioritized at the local level by those who are closest to people in need. CBPFs increase predictability of funding and involve frontline responders, including national and local NGOs, in the planning and delivery of humanitarian response. 
 
The Contribution visual displays the list of paid contributions and commitments made to CBPFs by year and allows the users to filter the donors’ contributions to the according funded CBPF.
 
Some of the features available are:
  • Display of the paid and pledged amount for all CBPF’s and individual CBPFs
  • Display of donor wise pooled fund contributors
  • Display of year wise CBPF contributions
  • Display of contributions based on individual CBPFs
  • Breakdown of funding received by individual CBPFs

 Contributions Trends Top

 
 
This visual analyses the trends of contributions made or pledged by donors, according to the CBPF throughout the years.
 
Users can apply the following filters to customize the visualization:
  • Donor
  • Currency
  • CBPF
  • the announced future pledges and the predicted pledges according to statistical trends
 

AllocationsTop

UN agencies, national and international nongovernmental organizations (NGOs), and Red Cross/Red Crescent organizations are eligible to receive funding from CBPFs in support of their life-saving relief programmes. The allocations made from CBPFs to relief partners by year are displayed here.

Some of the features available are:

  • Display of Year wise CBPF allocations to the various relief partners
  • Display of allocations based on individual CBPFs

 

 Allocations trends Top

 
This visual analyses allocations’ trends throughout the years. Users can select specific CBPF to customize the graph. If no CBPF is selected, the default curve represents the overall allocations trend. 
 
 

 Allocations timelineTop

 
 
This visual shows the timeline of allocations per CBPF since 2018. It indicates the start and end dates of the allocation, the overall allocation amount, the allocation summary and the Humanitarian Response Plan’s targets at the core of the allocation. 
 
 
 
 

 Funding Overview Top

 
This visual focuses on funding flow and trends. The blue circles represent the donors, while the orange circles represent the CBPF. The size of the circles corresponds to the size of contributions for donors, and allocations for CBPF. Users can select a donor to see the amount and the according funded CBPFs; or select a CBPF to track its according donors.
 
 
 

 ClustersTop

 
This visual informs the users on the clusters’ targets, achievements and fundings, according to the year, the allocation type and the CBPF. The visualization shows not only the amount allocated by cluster, but also the number of targeted and affected persons by clusters. 
 
 
 
 
 
 

 Affected Persons trendsTop

 
The Affected Persons’ Trends visualization focuses on the persons affected by the crisis that prompted the establishment of the CBPF. The visual shows both the targeted number of persons that will benefit from the humanitarian projects, and the actual number of beneficiaries. Users can select the year and the CBPF to customize the visualization. 
 
 
 

 Common BI featuresTop

 
Each section of the BI includes a unique, interactive data visualization chart. Users can select specific parameters to customize the chart according to their needs. Moreover, five technical tooltips are available on the right-hand side of every visual : share, play, image, .csv and help. These tooltips are needs-tailored and configured to enhance the users’ experience of the BI. 
 
 
 
  • Share / Bookmark 
After customizing the visualization chart, users can share the results on the communication channel of their choice. The Share icon generates a link of the personalized visual, which redirects to a webpage displaying the customized chart. Click on [share] to copy the link and paste it on social media or any communication channel.
 
Bookmark : Users can paste the Share link on the navigation bar of their browser, and save the linked webpage as a bookmark. 
Play launches an animation of the data visualization’s timeline, enabling users to watch how the data trends evolve throughout the years. 
Image enables the users to download the customized data visual onto their computers as a pdf or png file. 
.CSV enables users to download the raw CBPF data linked to the visualization. Raw data will be downloaded onto the user’s desktop as an excel file. 
The Help icon is a short explanation of the rationale behind the data visualization as well as its customization possibilities. 
 
 
 

 Data ExplorerTop

 
Data Explorer provides a list of full data snapshots of all CBPF projects. 
 
To download the raw data as .csv documents on your computer, go to the BI homepage and click on data Explorer. 
 
 
Select the pooled fund to display all implemented and ongoing projects of the Humanitarian Fund. Click on the [download] icon to download an excel documents of the projects’ data.