For day 2 of dashboard week we are given the option of selecting any dataset available on UNICEF. UNICEF (United Nations Children's Fund) is a United Nations agency that provides humanitarian and developmental assistance to children and mothers in developing countries, focusing on areas such as education, health, nutrition, and emergency relief.. The website has an amazing range of data available on several different pressing topics from women’s health to access to safe drinking water. However, one dataset drew my attention immediately– literacy, and specifically how it’s been impacted by COVID.
According to a report by the United Nations Educational, Scientific and Cultural Organization (UNESCO), at the peak of the pandemic in April 2020, approximately 1.6 billion learners in more than 190 countries, or 91% of the world's student population, were affected by school closures. This disruption in education has had wide-ranging effects, including learning loss, increased dropout rates, and widening educational inequalities.I ended up finding two datasets on UNICEF from 2019 and 2021 and supplemented with additional data from UNESCO due to the missing values. I also wanted to include in the data information about different regions and continent so added additional data from the UN.
In alteryx I got the datasets down to the fields I wanted, converted datatypes, and joined the four datasets to create my final dataset.
Here is a snapshot of what the final dataset looks like!
Something I’ve always been interested in incorporating to a dashboard is an image for the background. So I went to unsplash, a stock image website, and perused their free images to find something that I thought would fit with the format of the dashboard. I brought the image into Excel to crop it and lower the transparency.
And generated a color palette off of it:
<color-palette name="Book" type="regular">
<color>#FFFFFF</color>
<color>#DCB79A</color>
<color>#E0D9D3</color>
<color>#766760</color>
<color>#FEFEFE</color>
<color>#9ABFDC</color>
<color>#D3DAE0</color>
<color>#606F76</color>
<color>#BD4285</color>
<color>#DC9ABF</color>
</color-palette>
Once I had all that I brought it into Tableau to make this dashboard: