Tableau Storyboard / Dashboard
Assignment Introduction:
You have been asked to assess and evaluate trends in healthcare using data analytic tool (Tableau) to guide decisions about health care practices. Mi’Amore Medical Center would like to look at breast cancer screening rates and mammograms. Women ages 40–44 have the choice to start breast cancer screening with mammograms, and women ages 45–54 should get mammograms each year. Detecting breast cancer early means decreases in cancer mortality and decreases in treatment costs, as treating more advanced stages of breast cancer means more expensive procedures.
Download the Microsoft Excel assignment 8 workbook located in course documents. As a health data analyst, use the sample data set to assess breast cancer screening rates for the years 2015–2017 for both Memorial Hospital Group and Southern Hospital Group.
Assignment Directions:
1. Create a table showing the average breast cancer screening rates by year for both hospitals.
2. Create a table showing the total and average breast cancer costs by year for both hospitals.
3. Using one bar chart, display the average breast cancer screening rates by year for each hospital.
4. Using one bar chart, display the average breast cancer costs by year for each hospital.
5. For each hospital, use a pie chart to show the percentage of cancer cost contribution by year to the overall 2015–2017 cancer total costs. Which year was responsible for most of the cancer cost during this period?
6. Create a visualization to forecast screening rates for each hospital.
7. Summarize your findings in one paragraph by comparing hospitals’ breast cancer screening rates. Which hospital needs a change in breast cancer screening policy? Why does this policy change matter to health care?
8. Compute a correlation statistic to examine the association between breast cancer screening rates and breast cancer costs for both hospitals. Interpret both correlation statistics in terms of direct/inverse association and terms of weak/moderate/strong association. What is your overall conclusion about the relationship between breast cancer screening rates and breast cancer costs? What specific policy recommendations could you provide to the hospital board at Southern Hospital Group?
9. Create a storyboard with a narrative.
10. Create a dashboard.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
