Using the same data set, Surgical Data in “MSDA 673 M1 HW Data file.xlsx”. (you do not need to import it again, just add a new worksheet in Tablea

MSDA 673 MODULE 1 HOMEWORK (40 POINTS)

• You are now ready to manipulate and visualize the data. 
• Please download the attached “MSDA 673 M1 HW Data file.xlsx”
• Add your full name to the title of each chart (e.g. Chart A by Ying Wang). Otherwise, I will give you 0 points.  
• Be sure to save your Tableau file as “.twbx” type, upload it to your Tableau Public account, and paste the link in this file.

Visual 1 (7 points): Text Table

1. Using Tableau, connect the data set, Preoperative Risk Factors in “MSDA 673 M1 HW Data file.xlsx”. 
2. Create a text table to show Comparison % and Hospital % by Preoperative Risk Factors.
3. Modify the chart size manually to show all text information completely.
4. Add a title
5. Rename the worksheet tab
6. Hide field labels for the row

Visual 2 (7 points): Horizontal Bar Chart

1. Using the same data set, Preoperative Risk Factors in “MSDA 673 M1 HW Data file.xlsx”. (you do not need to import it again, just add a new worksheet in Tableau) 
2. Create a horizontal bar chart to show Comparison % by Preoperative Risk Factors
3. Format the chart:

• Sort the bars in descending order
• add labels to the bars
• make the chart fit the entire view

4. Add a title
5. Rename the worksheet tab
6. Hide field labels for the row; uncheck ‘Show header” for the x-axis
7. Answer the question: Which preoperative risk factor has the highest comparison %?

Visual 3 (7 points): Highlighted Table

1. Using Tableau, connect the data set, Surgical Data in “MSDA 673 M1 HW Data file.xlsx”. 
2. Create a highlighted table to show Turnover (minutes) by Service and Add-on vs Scheduled Flag
3. Modify the chart size manually to show all text information completely.
4. Add a title
5. Rename the worksheet tab
6. Hide field labels for the row
7. Answer the question: What type of surgery has the highest turnover?  

Visual 4 (7 points): Clustered (Side-by-Side) Bar Chart 

1. Using the same data set, Surgical Data in “MSDA 673 M1 HW Data file.xlsx”. (you do not need to import it again, just add a new worksheet in Tableau) 
2. Create a clustered bar chart to show Room Minutes Actual and Room Minutes Scheduled by Service.
3. Format the chart:

• Change the colors based on your preference
• Show mark labels (show numbers of room minutes for each bar)
• make the chart fit the entire view
• adjust the size of the x-axis label to show labels completely

4. Add a title; make the colors of the corresponding text consistent with the colors used in the visual. 
5. Rename the worksheet tab
6. Hide field labels for the column (Hide Service on the top of the chart)
7. Answer the question: Which service has the highest value of Room Minutes Actual?

Visual 5 (7 points): Stacked Bar Chart 

1. Using the same data set, Surgical Data in “MSDA 673 M1 HW Data file.xlsx”. (you do not need to import it again, just add a new worksheet in Tableau) 
2. Create a stacked bar chart to show Surgical Site Infection by Service and Add-on vs Scheduled Flag.
3. Format the chart:

• Show mark labels (the number of surgical site infections for each bar)
• make the chart fit the entire view

4. Add a title
5. Rename the worksheet tab
6. Hide field labels for the column (Hide Service on the top of the chart)
7. Answer the question: Which service has the highest surgical site infection?

Submission (5 points):

1. Save your work as (*.twbx) file and name it “MSDA 673 M1 HW – Your Name”. 
2. Submit it to your Tableau Public account
3. Paste the link here:

URL: 

4. Submit this word document and your tableau file to the blackboard.