Assignment 3 (Tableau Part 2)
Source Data: Same data source that we have used in previous Tableau Assignment (Medicare Part D Prescriber Data. So, please use the same dataset that you have used for the previous assignment.
Task 1:
- Create geographic distribution of total incurred cost by each state.
- Fill the map by color intensity of total drug cost (e.g. higher utilization should have a stronger color and lower should have lighter color)
- Which US states appears to have higher cost utilization (name 4-5 states)?
- On the tooltip display important information such as Drug Name, Beneficiary Count, Total Drug Cost, Total Claim Count, Cost Per Patient, Cost Per Claim
Task 2:
- Create geographic distribution by # of claims by each state.
- Fill the map by color intensity of total # of claims (e.g. higher utilization should have a stronger color and lower should have lighter color)
- Which US states appears to have higher # of claims (name 4-5 states)?
- The tooltip should have similar information as above chart.
