Reference no: EM132695990

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.