|
The potency of analysis and deduction becomes a formidable tool when wielded with precision. My fascination with environmental and social impacts led me to conduct a systematic review centered on one of the largest inland bodies of water in the United States, the Great Lakes. This exceptionally dynamic region is susceptible to water toxicity, leading to a concentration of health issues among populations residing in close proximity to the Great Lakes. Please continue reading below.
SQL example
Large sets of data can be confounding, yet crafting SQL queries can assist in extracting the desired information needed to answer questions. Below is an example of how to write a SQL query when searching through a database to determine the number of people who were vaccinated for COVID-19 in the year 2022 and were aged 65 and older. Adjustments can be made to the code to further refine the query.
SELECT
COUNT(*) AS vaccinated_65_and_older
FROM
Immunizations
WHERE
vaccine = 'COVID-19'
AND age >= 65
AND vaccination_date >= '2022-01-01'
AND vaccination_date < '2023-01-01';
Tableau example
One topic that I explored using Tableau was on Chronic Obstructive Pulmonary Disease (COPD). COPD is a condition suffered by almost 15.7 million US citizens, as reported from the Centers for Disease Control and Prevention (2018), with numbers anticipating to rise. In the following visualization, I unified two separate databases raw data, cleansed the data, aggregated tables, and united data in tableau to create a COPD prevalence visual per state's expenditure.
Reference
Centers for Disease Control and Prevention (2021, June 9) Basics about COPD. https://www.cdc.gov/copd/basics-about.html.
Centers for Disease Control and Prevention (2021, June 9) Basics about COPD. https://www.cdc.gov/copd/basics-about.html.