Terrorism has been around since the beginning of time, and has caused empires to rise, fall, and allowed people to gain power. It is a growing problem in this unstable world. A simple act of terrorism can cause tensions between two countries, as seen with Israel and Palestine’s conflicts due to religious beliefs and territory disputes. Among the various potential threats are wars with neighboring countries, missile attacks on cities, biological and chemical terrorism, suicide bombings, and hostage taking.

Owing to the growing global terrorist activities, we wanted to explore how analytics could help in understanding the various patterns and trends in these terrorist activities.

To compare or quantify the effect of terrorism on different countries, we tried to bring in the below-mentioned indices that directly/indirectly affect terrorist activities:

  1. Global Terrorism Index – which provides a comprehensive summary of the key global trends and patterns in terrorist activities for each country.
  2. Human Development Index – which is a composite statistic of life expectancy, education, and per capita income indicators
  3. Political Stability and Absence of Violence Rank – measures perceptions of the likelihood that the government will be destabilized or overthrown by unconstitutional or violent means
  4. Percentage share of Military expenses in a country’s GDP – this is representative of how seriously a country takes its security and how much it’s willing to spend to protect their nation


For our analysis, we took data from Global Terrorism Database which is an open-source database that contains information on global terrorist activities between 2001 and 2015. For each attack, information is available on the date and location of the incident, the weapons used and the target, the number of casualties, and the group, if identifiable.


The latitudes and longitudes which were a part of the original data source and the same was used for tagging cities to represent the number of casualties while the country names were used to tag the various indices.


  • Microsoft Excel : Used to perform initial exploratory analysis and for data preparation for subsequent Geo Visualization.
  • Tableau: To develop insights and analytics on the top 10 ranked countries by GTI scores.
  • Carto : Used to perform geo visualization on this dataset on the global level.


Tableau Dashboard Link

We analyzed patterns using the Top 10 GTI rankings for various countries which have highest terror activities on various levels overtime across the years like

  1. Volume of Attack – Includes No. of causalities, injuries, GTI score and no of attacks
  2. No of attacks vs No of killings
  3. Type of weapons used for terrorist activates
  4. Type of targets for terrorist activities



Carto Link

Carto was used for Geo-Visualization. We have used following 5 layers:

  1. International Logistically: The terrorist activities are divided into two categories, international logistically (which means that the perpetuators are of different nationality than the place of attack or not).
  2. Types of Weapons Used : This layers shows the types of weapons used by terrorist. We can see from the map that firearms and explosives are most common weapons.
  3. Types of Attacks: In this layer we show the different types of attacks by terrorist. Bombing, Armed Assaults and Hostages are most common attacks types.
  4. Intensity of Casualties: The heat map in this layer shows the severity of the casualties in the terrorist attacks.
  5. Suicide Attack: This layer indicates whether the attack was suicide attack or not.

Do let us know in case of any feedback/ suggestions/ queries.

Created By:

  • Disha Grover (A0148618W)
  • Manan Katiyar(A0148510M)
  • Ram Thilak Prem Kumar (A0148522H)
  • Shweta Sharma (A0148486N)