NUTRITION AND COVID-19 - HOW ARE PATIENT OUTCOMES AFFECTED?
Introduction
The fictitious, but prestigious Regional General Hospital has been very busy lately caring for many Covid 19 patients. The staff noticed, while taking patient histories, that many patients did not lead a very healthy lifestyle.
As one of the data analysts on staff, I was tasked with exploring and visualizing the COVID-19 Healthy Diet Dataset to determine if nutritional choices affect COVID-19 outcomes. This will help healthcare providers offer guidance on patients' nutritional choices to achieve better outcomes if infected with covid 19.
To view the full Tableau Dashboard click Here
Stakeholders
Two stakeholders/personas were created for this project:
Hospital Administrator: The main stakeholder is a hospital administrator who is trying to come up with a plan to help reduce Covid 19 severity and negative outcomes. She will present the findings and recommendations to the 3 department heads.
Hospital department heads: The final presentation is intended for the heads of the Medical, Nursing, and Dietary departments at the hospital. This will dictate how the members of each department will advise their patients when it comes to diet and Covid 19.
Business Questions
The dashboard story has 4 pages to navigate for insights on Obesity and food Consumption vs Covid-19 along with the Introduction and Conclusion pages. It also has filters and tooltips to extract more information.
About the Data
The Kaggle COVID-19 Healthy Diet Dataset by Maria Ren includes information about global COVID-19 case rates, world population, obesity rates, undernourished rates, and food data. The Covid data is from the week of 02/06/2021. The author calculated fat quantity, energy intake (kcal), food supply quantity (kg), and protein (as a percentage of total intake) for different categories of food.
The data is contained in 4 tables consisting of 32 fields in CSV format. 171 records contain country nutrition data but only 164 records contain country Covid data. Only 164 countries with complete data for COVID-19 and nutrition were used in this analysis, using an Inner Join in Tableau.
Tools Used
Excel (Data Cleaning)
Tableau (Visualization)
Insights
Obesity rates have been steadily increasing worldwide. Obesity puts people at increased risk for many diseases according to the CDC. It's no surprise to find that there is a positive correlation between Obesity Rates and Death Rates. Countries with higher Obesity Rates also have higher Covid-19 death rates.
Surprisingly countries such as Samoa, Kuwait, and Saudi Arabia have among the highest Obesity Rates but have low death rates. Many factors could be contributing to this, but it should be noted that these countries have high Vegetal and low Alcohol consumption.
Countries with higher Animal Products (excluding seafood) and Animal Fat consumption have more deaths overall than countries with higher Vegetal product consumption.
Although Seafood is an Animal Product, lower death rates were noted in countries with the highest consumption.
Countries with higher Grain, Pulse and Spice consumption had lower Death Rates.
Countries with higher Alcohol and Sugar consumption had higher death rates. Interestingly, Burkina Faso has the highest Alcohol consumption but has a low death rate. Note that they have low Animal and High Vegetal and Grain consumption.
Recommendations
The medical staff should advise patients to:
The medical staff should also help obese patients create a plan to achieve a healthy weight.
Data Limitations
Final Thoughts
I found this project interesting because I try to maintain a healthy diet/lifestyle and I was curious to see if it does indeed provide an advantage when it comes to Covid-19 infection outcomes. This was the Capstone Project for the UC Davis Data Visualization with Tableau Specialization.
Data Sources