Crisis Risk Dashboard - Product - Tableau

This is Part II of a two-part post. Part I outlines the process of presenting the data using Tableau and Part II delves into insights from the analysis.

This dashboard was done up for a #VizforSocialGood project. It consists of two sections: (i) violent incidents in Africa across time, and (ii) people most in need of support by different risk categories.

The dashboard hopes to present an easy and effective way to answer questions such as: what is happening? where is it happening? who is involved? who is affected? what has resulted in the current crisis? what continues to fuel the current crisis? what are mitigating actions being taken? how effective are they? where might the crisis of tomorrow emerge?


- Ignoring 2018 (as data for the year is incomplete), we can see that the number of violent incidents has been on the rise, sharply from 2013, especially violence against civilians has been consistently on the rise. Riots/ Protests are the most common type of incidents while Battle- No change of territory has led to most fatalities among incident types in the past few years, with the greatest number of fatalities in 1999, with majority of the fatalities caused by the Military Forces of Ethiopia and Eritrea.

- Violent incidents has been on the rise over the last couple of views with smaller magnitude of increase. Different countries face crisis of different incident types. For example, Somalia has the highest number of violent incidents for the last three years, 2015-2017. Democratic Republic of Congo has rose from 8th most to 3rd most within three years. For incident type Battle- no change of state territory, Somalia has the most number of incidents for the last three years as well. South Africa and Nigeria are the top two for most number of Riots/ Protests for the last three years while Burundi was in top three for Violence against civilians for the same time period and Somalia rose from fourth to top within three years.

Somalia see an increase of >10% in number of violent incidents per year from 2015.

In Somalia, for 2017, there are most clashes between Unidentified Armed Group and Civilians.

An area with a high count of violent incidents is Hodan.

For Riots/ Protests, the trend across years are more uneven.

Nonetheless, there are some areas that consistently have more Riots/ Protests than the rest.

This is similar for Violence against civilians, but the number of incidents within the blue and purple circled zones (below) seemed to be decreasing while that for the brown circled zone seemed to be increasing over the years.

- For the Sahel region, it is interesting to note that the countries are coping with different types of risks. For example, Nigeria faces the highest risk for Hazard on average, while Niger and Chad face the highest risk for Vulnerability and Lack of Coping Capacity on average respectively.

- Of the three different risk categories (Hazard, Vulnerability and Lack of Coping Capacity), the risk for Lack of Coping Capacity is the highest in general, with the minimum risk score of 5.8, compared to the minimum risk score of 2.0 and 3.6 for Hazard and Vulnerability respectively.

- In terms of Vulnerability dimensions, Socio-economic vulnerability pose a greater risk for the various administrative zones in general while Vulnerable groups has a more uneven distribution/ greater spread with the range of scores varying from 2.4 to 9.0.