Health Care Database Design and Management Assignment

HCA 542: Health Care Database Design and Management
Assignment V
Your task
Through this exercise, you will conduct a data analysis that practices some of the concepts outlined in your text, The
Accidental Analyst.
Deliverables
A Tableau packaged workbook. Reference https://help.tableau.com/current/pro/desktop/enus/save_savework_packagedworkbooks.htm for more information. Note that you must save your work as a packaged
workbook otherwise it cannot be graded.
Software
Note that this assignment uses a demo version of Tableau Desktop that you will need to obtain and use yourself. Given
that this is an optional assignment, you will not find this software supported by the Enderis computer lab and is likely
not found anywhere else on campus. Directions for obtaining the software are included in the directions below.
Individual work
This assignment will be completed individually without collaboration with other students.
Submission
Submit your assignment to the D2L Submit your assignment to the D2L dropbox by 11:55 on the due date in the course
schedule on D2L.
It is your responsibility to correctly submit the entire assignment on time in D2L. To ensure that your items are correctly
uploaded, reopen your files from the D2L dropbox to test it.
Grading
This project is worth 100 points and will replace your lowest score of another assignment if higher.
10 pts per Tableau Worksheet (10 sheets x 10 pts each = 100 pts)
Data Analysis
Choose your questions:
You have been asked to determine the categories of diagnoses and procedures with the highest reimbursement levels in
the Milwaukee metro area. We will be using DRGs to help answer this question:
http://en.wikipedia.org/wiki/Diagnosis-related_group
Preparation Step:
Download and install Tableau Desktop from http://www.tableausoftware.com/products/trial.
Click “Get Started” this will download the install file for Tableau. Install the program. Once you are done installing and
when Tableau starts for the first time, select “Start Trial Now” and then register. The following screen will appear and
you are ready to use Tableau.
Collect your data:
Obtain the Inpatient Prospective Payment System (IPPS) Provider Summary for the Top 100 Diagnosis-Related Groups
(DRG) – FY2011 from the federal government. Go to https://data.cms.gov/ and use the search box on the page. On the
results page you should see:

Click on the link (you may want to review this page about the data set) and then the View Data button. On the next
screen there is an Export menu option that will show the following download menu. Select CSV to obtain the data file.
Save this file to an appropriate folder.
Back in Tableau, use the Connect to a Text File, and make sure you pick .csv, in order to find the downloaded file from
the data website. In the next screen, select the Extract option and then Go to Worksheet. You will be asked to save an
extract file. Place this in the same folder as your CSV file.

Tableau will now look like the following:
Save your Tableau workbook as a packaged workbook. Reference https://help.tableau.com/current/pro/desktop/enus/save_savework_packagedworkbooks.htm for more information
Check out your data
Now it’s time to explore your data. Create the following worksheets:
Sheet 1: The count of the number of records. Did you get the same number of rows as the CSV if you open it in Excel?
Sheet 2: Provider City. Are you getting hospitals from all 50 states?
Sheet 3: Provider Name. Are you getting values from A to Z?
Sheet 4: Total Discharges. Did you get a sum of 6,975,318?
If you answered yes to all of these questions, then you appear ready to move to the next step.
Clean up your data
While we are not going to exclude any data from our analysis, it is important to understand if you have extreme values
or outliers that may be candidates for exclusion or may impact your interpretation of your analysis.
Sheet 5: Create a box and whisker plot consisting of Provider ID, Provider Name, and the sum of Total Discharges. What
hospital has the most discharges? How many more discharges does this hospital have compared to the next? Hovering
over each dot should pop up a context menu with the 3 data elements (Provider ID, Provider Name, and the sum of
Total Discharges).
Chart your analysis
Create individual sheets to answer the following questions:
Sheet 6: Where are the hospitals in Wisconsin? What is the size of each in terms of discharges?
Create a map of Wisconsin using Provider Zip Code. Zoom to Wisconsin. Drag Total Discharges onto Size in the
Marks Panel. Drag Provider Name onto Label in the Marks Panel.
Sheet 7: Show a list of Wisconsin hospitals ranked by size terms of discharges (Hint: Filter by Provider State and sort the
data).
Sheet 8: Which hospital has the most discharges in the Madison market? How about Wausau?
Duplicate Sheet 7 and create a multi-pane bar chart using Hospital Referral Region Description.
Customize your analysis
Sheet 9: Which DRGs have the highest average total payments in the Milwaukee referral region?
Create a highlight table using DRG Definition and Provider Name. Filter on Hospital Referral Region.
Sheet 10: For each DRG, how do Milwaukee region hospitals compare in terms of Total Discharges and Average Total
Payments?
Create a scatter plot table using DRG Definition in the Pages panel and filtering on Hospital Referral Region. The
scatterplot is uses Total Discharges and Average Total Payments. The marks used are Provider Name in order to colorcode each circle. You should be able to hit play and have the graph switch from one DRG to the next (note that in the
latest version of Tableau that the play feature may show up on the right-hand side of the screen).
Communicate your results
Save your Tableau packaged workbook and submit it to the D2L dropbox. Make sure your file has an extension of
*.twbx (note the x at the end).

Get professional assignment help cheaply

Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?

Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.

Our essay writers are graduates with diplomas, bachelor, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.

Why choose our academic writing service?

  • Plagiarism free papers
  • Timely delivery
  • Any deadline
  • Skilled, Experienced Native English Writers
  • Subject-relevant academic writer
  • Adherence to paper instructions
  • Ability to tackle bulk assignments
  • Reasonable prices
  • 24/7 Customer Support
  • Get superb grades consistently

Get Professional Assignment Help Cheaply

fast coursework help

Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?

Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.

Our essay writers are graduates with diplomas, bachelor's, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.

Why Choose Our Academic Writing Service?

  • Plagiarism free papers
  • Timely delivery
  • Any deadline
  • Skilled, Experienced Native English Writers
  • Subject-relevant academic writer
  • Adherence to paper instructions
  • Ability to tackle bulk assignments
  • Reasonable prices
  • 24/7 Customer Support
  • Get superb grades consistently

How It Works

1.      Place an order

You fill all the paper instructions in the order form. Make sure you include all the helpful materials so that our academic writers can deliver the perfect paper. It will also help to eliminate unnecessary revisions.

2.      Pay for the order

Proceed to pay for the paper so that it can be assigned to one of our expert academic writers. The paper subject is matched with the writer’s area of specialization.

3.      Track the progress

You communicate with the writer and know about the progress of the paper. The client can ask the writer for drafts of the paper. The client can upload extra material and include additional instructions from the lecturer. Receive a paper.

4.      Download the paper

The paper is sent to your email and uploaded to your personal account. You also get a plagiarism report attached to your paper.

 

smile and order essaysmile and order essayPLACE THIS ORDER OR A SIMILAR ORDER WITH SMART HOMEWORK HELP TODAY AND GET AN AMAZING DISCOUNT

order custom essay paper

Leave a comment

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