During day 4 of Dashboard Week, we were assigned an interesting task to select data of our choice from https://www.gapminder.org/data/ and present it in Tableau. We were also not allowed to use Alteryx to prepare the data.

After doing some research on the website, I selected the data related to Education as per my interest. I used some files related to Primary aged children not enrolled in school (both girls and boys), Rate of completing Primary School for girls and boys, Ratio of Girls to Boys in Primary school and Ratio of young Females to Males in various countries across the world. I also joined these files to Income for various countries and divided countries into three groups (Lower Income group, Middle-Income group and Higher Income group as I wanted to explore the relationship between Income Group and Girl education. I used Tableau Prep to prepare my data and really enjoyed using its cool features.

After exploring the data, I was able to collect some useful insights-

  • Worldwide, there are still 31 million girls of primary school age out of school, including more than 80% of children in low-income countries. Of these 17 million are expected never to enter school. There are 4 million fewer boys than girls out of school.


  • In Lower Income Group countries, the girls not enrolled in school are highest followed by boys from Lower Income Countries. However, in Higher Income countries, the number of girls and boys out of school are comparatively quite low.


  • Girls are 1.5 times more likely than boys to be excluded from primary school. That’s 15 million girls of primary school age who will never have the opportunity to learn to read and write in primary school, compared to about 10 million boys.


  • Three countries have over a million girls not in school: In Nigeria, there are almost five and a half million, Pakistan, over three million, and in Ethiopia, over one million girls out of school.


  • Globally, 9 in 10 girls complete their primary education, but only 3 in 4 complete their lower secondary education. In low-income countries, less than two-thirds of girls complete their primary education, and only 1 in 3 completes lower secondary school.


  • Rate of completing Primary School is much lower in Low Income Group countries then Middle and Higher Income Group countries.


  • The ratio of Girls to Boys in Primary School is least in Lower Income Group countries. In low-income countries, women account for only a third or less of human capital wealth. However, in Middle Income Group countries ad Higher Income Group countries the ratio of Girls to Boys is quite balanced.


  • Women with primary education (partial or completed) earn 14% to 19% more than those with no education at all. Women with secondary education may expect to make almost twice as much, and women with tertiary education almost three times as much as those with no education.


  • Women represent nearly two-thirds of the world’s illiterate. Approximately 1 in 4 young people in Low-Income countries are illiterate.

I also used some other website to get the information like –







I was both amazed and disappointed to explore the fact that Millions of girls around the world are still being denied an education. Awareness about the issue and understanding the importance of girl’s education will only help to make the world a better place for women. It is rightly said by Charles Malikleo that “The fastest way to change society is to mobilize the women of the world.”  Also, said by Kofi Annan “To educate girls is to reduce poverty.”

My dashboard in Tableau looks like this-


This link to my workbook.

The Data School
Author: The Data School