Tableau Student Activation Key! Below is a website (landing page link) for your upcoming class - please forward this to your students. Each student should go to the landing page to download Tableau and enter the key noted below. This key will activate enough licenses for your entire class for the duration of the course Download the most recent version of Tableau Desktop Key: TDYR-5381-2050-DFF7-4866 Kind regards. Dr. Marie Kaplan University School of Health Sciences HS305 Research Methods for Health Sciences Unit 6 Assignment Introductions COURSE # In Unit 4, you learned about data visualizations and how to read them. As you learned in Unit 5, data mining is a technique used to find hidden patterns in big data. For the Unit 6 Assignment, you will exercise your ability to use data preparation software to create a data visualization report. Instructions For the Unit 6 Assignment, you will be completing a data mining activity using a predetermined data set that will produce data visualizations to give a picture of specific health issues. Please carefully follow each of the steps for creating your visualization. 1. Download a copy of the data set from Doc Sharing (Medicare_Provider_Charge_Inpatient_DRG100_FY2013.csv). Create an empty folder on your desktop or other easily located place on your computer called 'Unit 6 Assignment'. Save the data file in the folder 'Unit 6 Assignment'. 2. If you have not already done so, download Tableau to your computer. Your access code was provided by your instructor. a. Go to http://www.tableau.com/products/desktop. b. Follow the steps to download Tableau. You will need to enter your information to register your copy of the software. c. During the registration process you will be asked to enter your registration code, which you were provided at the beginning of the term. 3. Once your Tableau download is complete, open the software. 4. Open the previously downloaded data set (Medicare_Provider_Charge_Inpatient_DRG100_FY2013.csv) in Tableau. a. In the left navigation pane under Connect - To a file, click on Text file. b. Once the file navigation window opens, select the data set you downloaded. c. The data set will import into Tableau. When the transfer is complete, it should look something like this: 1 Kaplan University School of Health Sciences HS305 Research Methods for Health Sciences COURSE # 5. Click on \"Update Now\" in the center of the page. 6. Looking at the bottom left corner of the screen in Tableau, you will see that you are on the Data Source tab. Click on the tab next to it labeled Sheet 1. This will put you in the data canvas, which should look like this: 2 Kaplan University School of Health Sciences HS305 Research Methods for Health Sciences Create the dashboard: Follow the steps below to complete your assignment based on the Medicare_Provider_Charge_Inpatient_DRG100_FY2013.csv data set. These data are publically available from the Centers for Medicare and MedicaidCOURSE Services. It is # the inpatient charge data for FY 2013 (CMS, 2015). 1. Save your Workbook as \"Medicare Costs in FY2013\". (Make sure to save it in the 'Unit 6 Assignment' folder with the data set.) 2. Go to Sheet 1. 3. From the Measures area, put 'Longitude' on the Columns shelf. 4. Then, put 'Latitude' on the Rows shelf. 5. Next, drag 'Average Medicare Payment' over the 'Color' marks. 6. Click on the 'Average Medicare Payment' bubble in the marks box. (See picture.) 3 Kaplan University School of Health Sciences HS305 Research Methods for Health Sciences 7. From the menu, choose 'Measures', then click 'Median'. 8. From the Dimensions area, drag 'Provider State' over the 'Label' marks. 9. Next, click on the 'Color' marks box (see image). COURSE # 10. Choose Edit Colors (see image). 11. From the palattes, choose 'Gold-Purple Diverging'. Hit 'Apply'. 12. Rename Sheet 1 \"2013 Medicare Payments by State\". 13. Add a data canvas (Worksheet). The default name will be Sheet 2. 14. From the measures, put 'Average Total Payments' on the Columns shelf. 15. Then click on the 'Average Total Payments' bubble on the shelf. On the menu, choose 'Measure' and change it to 'Median'. 16. From dimensions, put 'Provider State' to the Rows shelf. 17. Just above the 'Columns shelf' there are three small images, click on the small graph icon to sort by descending. 18. From measures, drag 'Average Covered Charges' over the Color marks. 19. Click on the 'Average Covered Charges' bubble under the mark. 20. Choose 'Measure' from the menu, then click 'Median'. 21. Click on the 'Color' marks box again and choose 'Edit Colors'. 22. From the palettes, choose 'Red-Green diverging'. Hit 'Apply'. 23. Rename the x-axis (bottom of the graph) to 'Median Total Payment Average (USD)'. 24. Rename Sheet 2 \"2013 Medicare Charges & Payments by State\". 4 Kaplan University School of Health Sciences HS305 Research Methods for Health Sciences 25. Add a data canvas (Worksheet). The default name will be Sheet 3. 26. From the measures, put 'Average Medicare Payments' on the Columns shelf. 27. Click on the 'Average Medicare Payments' bubble on the shelf. Choose 'Measure' from the menu and change it to 'Median'. 28. Then, put 'Total Discharges' on the Rows shelf. COURSE # 29. From dimensions, drag 'Provider State' to the labels. 30. Change the y-axis (left of the graph) to 'Total Discharges in Thousands'. 31. Change the x-axis (bottom of the graph) to 'Median Medicare Payment Averages (USD)'. 32. Go to the 'Analysis' menu at the top, Choose 'Trend Lines' & click 'Show Trend Lines'. 33. Go back to the 'Analysis' menu again, Choose 'Trend Lines' & click 'Edit Trend Lines'. 34. Uncheck 'Show Confidence Bands' and press 'ok'. 35. Rename Sheet 3 \"Correlation between Discharges and 2013 Medicare Payments\". 36. Add a Dashboard. 37. Drag and drop the \"2013 Medicare Payments by State\" sheet first. Then, add the \"2013 Medicare Charges & Payments by State\" sheet. Finally, add the \"Correlation between Discharges and 2013 Medicare Payments\" sheet into the Dashboard. 38. Rename Dashboard 1 as \"2013 Medicare Payments\". 39. Save a copy of your dashboard with the name 'Medicare Costs in FY2013' in the 'Unit 6 Assignment' folder with the data set. Then go to the File menu and 'Export Packaged Workbook'. Video on creating on how to \"Export Packaged Workbook\": https://youtu.be/UdD5nQV2saY?t=2m18s Submitting Your Work To save the workbook you created, you must export the file... Go to 'File' and choose 'Export Packaged Workbook'. Your exported workbook file will be named 'Medicare Costs in FY2013.twbx'. Next, you will need to zip or compress the file 'Medicare Costs in FY2013.twbx' in order to upload it to the classroom. Upload 'Medicare Costs in FY2013.zip' to the assignment dropbox. Please refer to the your device-specific instructions for zipping or compressing files. For directions on how to submit your work and review your graded assignments, refer to the Dropbox Guide found on the Academic Tools tab. Make sure that you save a copy of your submitted work. 5 Kaplan University School of Health Sciences HS305 Research Methods for Health Sciences Reference Centers for Medicare and Medicaid Services (CMS). (2015, June 4). Inpatient charge data FY 2013. Retieved from https://www.cms.gov/Research-Statistics-Data-and-Systems/Statistics-TrendsCOURSE # and-Reports/Medicare-Provider-Charge-Data/Inpatient2013.html 6 First Name- Audrey Last Name- Ramos Business Email- Audrey.l.ramos2.mil@mail.mil Organization- US Army Department- Support Service Job Role- Student Business Postal Code- 36362 Phone- 334-255-7773