It has been a wonderful six weeks experience at sidehustle bootcamp, we have really been groomed and just like raw gold we have gone through the fire and ready for use. It feels like it's ending but in reality it actually just began, for we the bootcampers it calls for a moment of reflection. As usual every Sunday we await for drey to come along with his almighty task and he sure never disappoints. THE TASK @channel Data Analytics
Work on a Life Expectancy Insight Analysis on a selected country. Your analysis should answer the following questions.
Does various predicting factors which has been chosen initially really affect the Life expectancy? What are the predicting variables actually affecting the life expectancy? Should a country having a lower life expectancy value(<65) increase its healthcare expenditure in order to improve its average lifespan? How does Infant and Adult mortality rates affect life expectancy? Does Life Expectancy has positive or negative correlation with eating habits, lifestyle, exercise, smoking, drinking alcohol etc. What is the impact of schooling on the lifespan of humans? Does Life Expectancy have positive or negative relationship with drinking alcohol? Do densely populated countries tend to have lower life expectancy? What is the impact of Immunization coverage on life Expectancy?. THE PROCESS Step 1 Download data here : kaggle.com/datasets/kumarajarshi/life-expe… Step 2 : open an empty excel file(name the file country image) then copy the year, country and population columns from the csv file you downloaded from kaggle which shows 3 columns in total and a new column called 'link' to show each country flag Download country image url : worldometers.info/geography/flags-of-the-w…
Note : we now have two csv file the life expectancy csv file from kaggle site and country image csv file )
Step 3 : open Microsoft powerBi and import the two csv files which are life expectancy data and country image
Note : click the power query to perform some Data cleansing
Step 4 : duplicate the life expectancy data and rename it to correlation
![image.png](cdn.hashnode.com/res/hashnode/image/upload… align="left" Then click 'run python script'
Note : check the screenshot above Write the above code and click 'ok' It will show the relationship among variables (correlation). Note : select 'close and apply' to save the above changes Step 5 : Go to data view and select the 'country image' data then you convert the 'link' column to image url.
Step 6 : we showed a correlation matrix to know if there is a positive or negative relationship among the variables.
Interpretation :
We observed that there is a positive relationship of 0.40 between 'life expectancy' and 'alcohol'
Which means that for every alcohol consumed it will increase the life expectancy by 40%.
Step 7 : we also decided to show the top 5 countries with measles.
.
Interpretation :
china has the highest number of measles cases all over the world followed by Nigeria , Dr Congo, India and Indonesia
Which means Nigeria has the highest measles cases in Africa.
Step 8 : Which country has the highest number of alcohol consumption? , We did this using a doughnut chart.
.
Interpretation:
There is high rate of alcohol consumption in Belarus.
Step 9 : now , we decided to focus on West Africa to know which west Africa country has the highest rate of Hepatitis B.
.
Interpretation :
There are more than 10 west African country and it shows that Gambia has the highest rate of Hepatitis B.
Step 10 : HIV/AIDs in Africa?.
.
Step 11 : we created a table to show the top 4 countries with population.
Note : add 'year' slicer from the 'country image' data so once we filter the year, the top 4 countries per year and its flag will change automatically.
FULL DASHBOARD.
.
Thankyou for your time.