Assignment 3 (Tableau Part 2)

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.