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.

Leave a Reply

Your email address will not be published. Required fields are marked *