Place your order today at a 20% discount
Congratulations, you have just landed a position as a data analytics technician at Memorial Hospital . As the data analytics technician, you have been asked to create simple data visualizations for an upcoming board meeting on various hospital expenditures. You will use Tableau to complete this assignment and create your visualizations.
To complete this assignment, you will do the following:
Download the Microsoft Excel assignment 4 workbook located in course documents
Part I: Preparing Data
Connect the data set
Clean the data
Under sheets in the left pane select the clean with data interpreter button
Part II: Creating Visualizations
Create a bar graph that shows the number of patients per day.
Drag sum of patients to columns
Drag month of May to the rowsExpand until the graph shows the number of patients by day
Create a visualization that shows total costs per day.
Drag total costs into columns
Drag month of May into rowsExpand until the graph shows the costs by day
Part III: Analysis
Recreate the patients per day visualization in a new sheet
Compute the following within the table.
Compute the average
Compute the standard deviation
Compute the min
Compute the max
Part IV: Tableau Story
Create a Tableau Story presentation with a narrative explaining each sheet. In your story narrative, be sure to point out the average, standard deviation, and minimum and maximum calculations. Explain how the Define, Measure, Analyze, Improve and Control (DMAIC) model can be used with your results.
About ASAP Essays
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.
Hire a tutor today CLICK HERE to make your first order