“Prevalence of obesity”

Part I
Preparation

1. Download and install Tableau
2. Download the latest version of Tableau Desktop and Tableau Prep Builder here (Links to an external site.)
3. Click on the link above and select “Download Tableau Desktop” and “Download Tableau Prep Builder”. On the form, enter your school email address for Business E-mail and enter the name of your school for Organization.
4. Activate with your product key: TC5A-E2B5-68E0-2DC3-94B0
5. Already have a copy of Tableau Desktop installed? Update your license in the application: Help menu → Manage Product Keys
   Tableau help - Data Analytics for University Students guide. (Links to an external site.) Online training videos (Links to an external site.) FAQs (Links to an external site.).
   Students can continue using Tableau after the class is over by individually requesting their own one-year license through the Tableau for Students program here (Links to an external site.).
6. Make an account on https://data.world (Links to an external site.) and sign in (you will have to verify your email first)
7. Download the file “Prevalence of obesity in adults by region” from world. https://data.world/informatics-edu/prevalence-of-obesity-in-adults-by-region (Links to an external site.)
8. In Tableau, select file, New. Upload the file on obesity prevalence to Tableau as a “data source.”

Homework

1. In the lower-left select the tab “Sheet 1”. Drag “Prevalence of obesity” from the left side MEASURES area to the row at the top center labeled “COLUMNS”
2. Drag the “region” under the DIMENSIONS area to the row at the top labeled “ROWS”
3. Click on the down arrow for Prevelance of obesity in the Columns section and select “MEASURE” then select Average
4. Your chart should now show average prevalence of obesity by region. What are the highest and lowest regions?
5. Label sheet 1 Prevalence of Obesity by Region
6. Select sheet 2 in the lower left.
7. Drag Year data in Dimensions to the Column section and
8. drag the Prevalence of obesity to the Row section.
9. In the drop-down for Prevalence, select MEASURE and then Average.
10. Your chart now shows the average prevalence of obesity from 1975 to 2016
11. Label sheet 2 Prevalence of Obesity by Year
12. What is the trend?
13. Scroll to the bottom and add a dashboard.
14. Drag the two sheets from the left work area into the dashboard.
15. Add a title that includes your last name (e.g. STUDENT NAME’s Obesity Dashboard).
16. Take a screenshot of your dashboard to turn in with your answers to 1c and 2c above.

Part II
Now you are on your own. You are on a team of public health analysts for the State of Connecticut and want to know more about why there are so many drug-related deaths in the state.
This section will use the dataset Accidental Drug Related Deaths 2012-2018 Connecticut https://data.world/informatics-edu/accidental-drug-related-deaths-2012-201 8-connecticut This file has been cleaned up for your use.
Preparation
Download the file and add it as a new data source to Tableau.
Homework

1. Create a dashboard that tells a story of what type of person dies from accidental overdoses and from what drugs.
2. What is the trend from 2012-2015?
3. What problems did you encounter?
4. The data needs more cleaning as there are columns such as “null” and “unknown” for race.
5. The CauseOfDeath Column is extremely messy with multiple labels meaning the same thing. For example – heroin intoxication and heroin toxicity (already fixed for you). For any meaningful interpretation some should be combined, and others deleted. Are there still some that should be combined?
6. What can you say about the trend after cleaning the data?
7. What races are most affected?
8. What gender is the most affected?
9. Where do most deaths occur?
10. What is the overall trend in drug-related deaths?
11. Provide screenshot of Tableau dashboard with your name as part of the dashboard title.
12. Using the dataset https://data.world/informatics-edu/chapter-4-exercise-3-data-sets/file/Figure%204.4%20Data%20Set.xlsx (Links to an external site.) and Tableau create the 6 charts found on page 76 in the Hoyt chapter 4 Data Analysis handout found in figure 4.3. Examples (youtube videos) are linked from table 4.2 on page 79 of the chapter. Send screenshots.
13. Using the dataset https://data.world/informatics-edu/chapter-4-exercise-3-data-sets/file/Figure%204.12%20Data%20Set.xlsx (Links to an external site.) and Excel, create the 7 charts found in figure 4.11 on page 80 in the chapter. Examples are found in table 4.3 on page 84. Send screenshots or the Excel file.

BIG DATA Homework
Read this article by a Google AI team that used AI to analyze big data from EHRs https://www. (Links to an external site.)nature.com/articles/s41746-018-0029-1 (Links to an external site.)

1. What was unique about the article? What did the FHIR standard contribute? What was the impact of being able to mine both structured and unstructured healthcare data? How was success measured?
2. Do a Google or Google Scholar search to determine how is healthcare data different from other data (e.g. economic data, etc.).
3. Why is healthcare data different from other types of data?
4. Include the citation for your source.

Sample Solution