Skip to Content
Author's profile photo Former Member

Analysis on Children Living with HIV using Lumira Desktop

“HIV/AIDS”, it is not someone else or some countries problem. It is the problem of everyone in everywhere!

I was hooked onto this thought while searching for the datasets for the Data Genius competition. The top ten entry with most votes will be evaluated by a panel of Judges. The winners will get a chance to donate to any of the eight charities approved by SAP. Also, a ticket for SAPPHIRENOW. Though it’s a pity that we could only choose from eight approved charities, still, it is a great idea that Prize $ goes back to community that is in need.

This blog is the re-cap of my entry on DataGenius

As of 2014, Total World Population is 7 Billion + and Plus.

The population is progressing upward trend in linear.

1_Total World Population.PNG

1960 – 2014, the population of the children age (0-14) is decreasing while adult age (15-up) is the opposite.

It could mean two things. Either, we are having low child birth rate or children are dying at young age.

2_World Population by Age Group.PNG

So, I decided to look into many factors and found that >

Despite the decline in the children population, the number of children age (0-14) living with HIV has increased dramatically over 15 years from 1990-2005.

Though, the number is going down steadily from year 2010.

4_Number of Children Living with HIV.PNG

Geographically speaking, the World Map below shows the region where children living with HIV exist.

6_Children with HIV World Map.PNG

If we drill-down or analyse those regions, the following statistics are found.

6_Children Living with HIV by country and region.PNG

When we group them by region, Sub-Saharan Africa has the highest number of children living with HIV.

8_Number of Children Living with HIV by Region.PNG

If we check by the income group, regions with Low Income Group has the highest number of children living with HIV.

6_Children living with HIV by income group.PNG

Let’s see by the countries, who are in the top and bottom ten.

6_Children living with HIV top ten countries.PNG

6_Children living with HIV bottom ten countries.PNG

Then, I thought that if we spend a good deal for public health and educate the public, we could somehow eradicate this issue.

So, I decided to look into the public health expenditure data >

and found the following …

5_Total Health Expenditure 2.PNG

If we look at who spend the most and who spend the least for the Public Health:

7_Health Expenditure Top 10 Countries.PNG

7_Health Expenditure Bottom 10 Countries.PNG

None of the country that spent higher percentage of GDP on Public Health are in the list where children living with HIV exist and vice versa.

From the analysis, we can clearly see the impact of the public health expenditure and its effect on the public health.

Especially on the children living with HIV.

To conclude, it is everyone’s problem. No matter where you live in the world. You can play a part in helping this world a better place.


Let’s raise the awareness by voting my entry on the #DataGenius if this is happened to be read before 2015, December 8 😆


Your 1Click will make an impact on someone’s life.

Click here to create an impact today! It’s all in your hand.


The World Bank Logo.jpg /wp-content/uploads/2015/12/hiv_845507.jpg

The data used in this analysis is acquired from The World Bank Data.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.