(Project) The Refugee Crisis
Skills: Excel, Power BI
The refugee crisis has become a global mass migration of such scale that it requires attention. The 2017 documentary, Human Flow, depicts the gravity of the refugee crisis. It illustrates the conditions under which displaced humans live and just how little control they have over their own lives. This documentary transformed statistics of a far-away situation into real, life stories that viewers can see, relate to, and act upon.
Therefore, I aim to visualize data containing information about refugees. I will answer the questions:
Where are they coming from?
Where are they landing?
At what points between 1990 and 2019 did numbers fluctuate dramatically?
What determined those events?
The dataset for this report is gained from the WorldBank: World Development Indicators. It consists of two excel files:
Refugee population by country of origin 1990 -2019
Refugee population by country or asylum 1990 -2019
Cleaning the datasets
Both datasets were cleaned using the following steps in Microsoft Excel:
Rename column headers
Delete unnecessary column headers
Replace null values with zero
Upload datasets into Power BI and create new SUM Refugee measures
Rename column headers to state the year without brackets
Delete unnecessary columns ‘Series Name’ and ‘Series Code’
Create new measure SUM Refugees for both datasets
Replace null values with zero