Our Second project

Hello Everyone,

Thank you for checking our blog, This blogpost is about our second project from the Side hustle portfolio bootcamp. This was really exciting to work on as we had higher participation from the portfolio members. Enjoy our Process documentation

PROBLEM STATEMENT Sickle Cell disease affects millions of people throughout the world, it is the most common blood disorder among families whose ancestors come from sub-Saharan Africa, south America, Cuba, Central America, India, Saudi-Arabia and the Mediterranean regions (Creary et al., 2007). Thus, our research focuses in within America races using available data gathered over a period of 3 years (2019-2021). We did an in-depth analysis of the available data in relation to how other ailments compare to Covid-19, affect the mortality rate of a sickle cell carriers in America. HIV is another global disease that keeps spreading in the world even with the growing awareness of the danger of the disease. The data obtained of the people diagnosed with HIV within a space of 7 years (2011-2017) will be analysed to ascertain the overall details of the infected persons by their Race(Region). This study is aim at analysing the infection rate, mortality rate and consequently proffering possible recommendations on how to reduce all of these negative effects.

PROJECT OBJECTIVES This project will be using both Excel and Power bi to create a disease monitoring report and dashboard showing details of Reported cases and subsequently the total mortality rate. This will be achieved through the following steps; • Analysing the infected demography by sex • Analysing the infected demography by age • Finding out the heat map location • Reported cases by date • Mortality by region • Mortality by sex • Mortality type • Mortality rate • Total death.

DATA SOURCING Data scraping was a serious battle for us during this project, we initially plan to use a live data unfortunately, we couldn’t find any suitable one for the visualization required. We eventually wrote down the relationship of all the columns in the dataset we finally got and rearranged them. One of the dataset used was the sickle cell data gotten from NCHS website and the other was an HIV dataset.

DATA CLEANING We finally decided on the data to use, loaded it into excel and powerbi for analysis to check for correct datatype, empty cells, duplicate entries using the Transform data option of the power bi where we concluded that our data was ready for visualization.

DATA VISUALIZATION All Visuals were done using Excel and PowerBI

FINDINGS In America, within the period of 3 years (2019, 2020,2021) the given data analysis shows the connection of Sickle cell mortality rate among the population in connection with other underlining ailments and also connection of Sickle cell mortality rate with Covid-19. the findings are follows;

1. Non Hispanic Blacks Race has the highest mortality rate of 2576 out the sum total of 3187 Sickle cell related deaths recorded generally in the space of 3 year
2. The sum total Sickle cell and Covid-19 related death rank the lowest compare to others.
3. Adults within the age of 40-59 years suffer higher mortality rate.
4. People suffering from multiple underlying ailments recorded the highest mortality rate generally.
5. The over all total deaths related to Sickle cell within these 3 years was 3187. In conclusion the Non Hispanic Black race suffers the highest mortality rate and the year 2020 recorded the highest mortality rate within the period of 3 years with 1640 recorded deaths.

RECOMMENDATIONS Sickle cell is a chronic disease that is inherited when both parents are carriers of the sickle cell gene, therefore the best recommendation would be a primary prevention. This is aimed at even disallowing the existence of the disease. This can be achieved by health education and health promotion. People should be counselled on the importance of knowing their genetic compatibility before marriage. Infact, we dare say this should be made part of first date questions. Know your genotype. Health policies should be in place to monitor patients diagnosed with sickle cell disease, they should be educated on the signs and symptoms of an impending crises, they should have enough information on what to do. Health care facilities should be well equipped with drugs and consumables required to manage acute cases of sickle cell disease exacerbation.

Thank you for reading. kindly drop your comments and recommendations. HIV data set source:catalog.data.gov/dataset/hiv-aids-cases-25f60 Sickle Cell dataset source: data.cdc.gov/NCHS/AH-Sickle-Cell-Disease-Pr..