My Dashboard

How to Promote Community Health and Pursue a Healthier Lifestyle in Tennessee?

Examined the relationship between lifestyle choices and obesity in Tennessee

Executive Summary

Tennessee has one of the highest chronic disease rates among states including obesity problems. 90 % of health happens outside doctor offices and hospitals. Lifestyle choices are one of the significant determinants of health. Often, people would ignore the seriousness of their lifestyle that could potentially lead to serious health issues.

Motivation

-Good nutrition, physical activity, and a healthy body weight are essential parts of a person’s overall health -Examine the lifestyle factors and obesity for TN at state and city level -Raise public health awareness to improve preventive care on lifestyle changes perspective

Data Source

• Used five datasets with one million+ rows from the Centers for Disease Control and Prevention (CDC) to look at obesity problems at national, state and city levels

Technologies

-Excel, Python and Tableau

Scope of the Project

-Leading Health Indicators: Physical Activity 🏓 , Nutrition intakes: Fruits 🍍 and Vegetables 🥒

-Measurement Unit: Crude Prevalence

-Survey: Behavioral Risk Factor Surveillance System (BRFSS)

• Asked Data Questions on assessing health issues, prioritizing needs and actions needed

Data Questions

1. Assess Health Issues

-What are the overall Health in chronic diseases indicators (CDIs) between states ?

-What are the obesity rankings between states ?

-What are the social determinants of health in obesity?

2. Prioritize needs

-What are the lifestyle factors and their relationship with obesity ?

--Why empathsizing on no activity in TN?

-Where are the obese population with no activity?

(map of largest cities in Tennessee)

(community census tract map of obese match with no activity)

3. Take Action

-What should we do with the analysis?

-Shape policies, programs, and neighborhood activities that address health needs and promote a high quality of life for all

-Health Insurance wellness incentives

-Community Program

Challenges

-The datasets were large with more than one million rows, and I spend a lot of time to understand the data and healthcare terms ,as well as statistical measurements in the survey.

Rewards

-The completion of the project allows me to experience the whole process of a business analysis project, includes, finding and understanding data sources, cleaning data and analyzing the data with Python and Excel, and finally create a storyline in Tableau Dashboard to present and able to provide insights into the business problem.

Reference

Data Source

https://chronicdata.cdc.gov/Chronic-Disease-Indicators/U-S-Chronic-Disease-Indicators-CDI-/g4ie-h725
https://chronicdata.cdc.gov/Behavioral-Risk-Factors/BRFSS-Table-of-Overweight-and-Obesity-BMI-/fqb7-mgjf https://chronicdata.cdc.gov/Behavioral-Risk-Factors/Behavioral-Risk-Factor-Surveillance-System-BRFSS-P/dttw-5yxu
https://chronicdata.cdc.gov/500-Cities/500-Cities-Obesity-among-adults-aged-18-years/bjvu-3y7d
https://chronicdata.cdc.gov/500-Cities/500-Cities-No-leisure-time-physical-activity-among/axqz-rkkp

Others

https://www.cdc.gov/places/measure-definitions/unhealthy-behaviors/index.html#obesity https://www.cdc.gov/nccdphp/dnpao/state-local-programs/reach/index.htm https://www.cdc.gov/nccdphp/dnpao/state-local-programs/reach/pdf/REACH-overview-2017-508.pdf https://www.vumc.org/pophealth/ https://www.healthypeople.gov/2020/leading-health-indicators/2020-lhi-topics/Nutrition-Physical-Activity-and-Obesity https://www.tn.gov/health/cedep/environmental/healthy-places/healthy-places/tools-and-resources/tr/data-and-indicators.html https://www.cdc.gov/healthyplaces/toolkit/sources_of_health_data.pdf https://www.cdc.gov/cdi/overview.html