Question: Please submit your Tableau file with visualizations addressing the following questions from our Medicare Data Exploration. State with Highest Average Medicare Payments, and what is

Please submit your Tableau file with visualizations addressing the following questions from our Medicare Data Exploration. State with Highest Average Medicare Payments, and what is the number Most expensive (on average) procedure in terms of average total payments Procedure which Medicare spent the most on in aggregate Produce a Table showing total number of procedures in each state Pick a single hospital (maybe one from your home town, or an area you've enjoyed visiting), and filter the data you have to only that hospital. Build a Dashboard (single sheet, in Tableau) for your selected hospital that helps management answer these questions: Bottom 5 procedures by average total reimbursement rate (total average payments / covered charges) Bottom 5 procedures by average medicare reimbursement rate (medicare average payments / covered charges) Top 5 procedures by occurrence Your submitted file must have a Worksheet labeled for each of Questions 1-4, and a Dashboard that addresses the final item. Scoring will include visual appeal, labeling, etc.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!