Medical Data Analysis with Tableau
Budget: $30 – $250 USD
Tableau Assignment
Use the following dataset to do this assignment: Data 2017-2019F wo missing data.xlsxDownload Data 2017-2019F wo missing data.xlsx
Identify and create an appropriate chart to represent the following data. Use an appropriate title or caption for each graphic, and present each chart on a new sheet.
ED visits by the year
Stratify all visits by race
Stratify all visits by payer type
Stratify all visits by race and average age
Stratify all visits by payer type and average age
Create a stacked chart of ED visits by payer type and year.
Do urban areas vary from rural areas in its usage. Stratify the urban/rural use by race and comment on your findings.
Compute the average and total charges by the type of payer. From the Analytics Pane in Tableau, use the Box Plot to represent the distribution of average charge by the year. Comment on your findings.
Create an interactive dashboard with the following: a) Trend visualization, b) Payer and race mix c) Add filter control with year that is applicable to all worksheets in the dashboard.
Use the following dataset to do this assignment: Data 2017-2019F wo missing data.xlsxDownload Data 2017-2019F wo missing data.xlsx
Identify and create an appropriate chart to represent the following data. Use an appropriate title or caption for each graphic, and present each chart on a new sheet.
ED visits by the year
Stratify all visits by race
Stratify all visits by payer type
Stratify all visits by race and average age
Stratify all visits by payer type and average age
Create a stacked chart of ED visits by payer type and year.
Do urban areas vary from rural areas in its usage. Stratify the urban/rural use by race and comment on your findings.
Compute the average and total charges by the type of payer. From the Analytics Pane in Tableau, use the Box Plot to represent the distribution of average charge by the year. Comment on your findings.
Create an interactive dashboard with the following: a) Trend visualization, b) Payer and race mix c) Add filter control with year that is applicable to all worksheets in the dashboard.