Homework answers / question archive / IS 335 – Business Analytics (Fall 2020 – Kishore – Sections 1005 and 1006) Tableau - Final Exam Questions:   Q1:          We want to compare using a bar-in-bar chart the total number of patient visits in 2018 with the total number of patient visits in 2017 for each of the hospital department which is contained within a department type which is contained within a hospital branch

IS 335 – Business Analytics (Fall 2020 – Kishore – Sections 1005 and 1006) Tableau - Final Exam Questions:   Q1:          We want to compare using a bar-in-bar chart the total number of patient visits in 2018 with the total number of patient visits in 2017 for each of the hospital department which is contained within a department type which is contained within a hospital branch

Accounting

Share With

---

IS 335 – Business Analytics (Fall 2020 – Kishore – Sections 1005 and 1006)

Tableau - Final Exam

Questions:

 

Q1:         

We want to compare using a bar-in-bar chart the total number of patient visits in 2018 with the total number of patient visits in 2017 for each of the hospital department which is contained within a department type which is contained within a hospital branch. In other words, the highest-level dimension in this chart will be hospital branch followed by department type followed by department. Further, we want this chart to only show data for patients who have a “high” patient risk profile. Additionally, please show the data for 2018 as a thinner bar and the data for 2017 as a thicker bar. Use the date of admit for counting the number of patient visits in a year. Also show all your legends including the filter, color, and size legends on your viz. The completed viz is shown below that you need to reproduce.

 

S

um                                                                 of                                                                   Number                                                       of                                                                   Patient                                                         Visits                                                             for                                                                 each                                                               Department                                               broken                                                                        down                                                           by                                                                   Hospital                                                       Branch                                                         and                                                                Department                                               Type.                                                                                                                                      Color                                                                        shows                                                          details                                                           about                                                           Date                                                               of                                                                   Admit                                                           Year.                                                                                                                                       Size                                                                        shows                                                          details                                                           about                                                           Date                                                               of                                                                   Admit                                                           Year.                                                               The                                                                 data                                                                        is                                                                     filtered                                                         on                                                                  Patient                                                         Risk                                                                Profile,                                                         which                                                           keeps                                                             High.

 

               

Q2:

We want to analyze using a stacked bar chart the total number of patient visits and percentage of total number of patient visits by hospital branch for only two department types – general and specialty. You will need to do a quick table calculation for calculating the percentage of total number of patient visits for this analysis. You should compute this percentage using the two department types above (i.e., general and intensive care) that will need to be filtered out as that is how we want to divide the percentages. Please show the percentages with two decimal points and also show the color legend for the two department types in your viz. The completed viz is shown below that you need to reproduce.

 

 

 

Q3:

We want to analyze using a heatmap the total minutes to service by the quarter of a year for both 2017 and 2018 (based on date of admit) shown in the columns and the department types and departments in the rows. We want to show the total minutes to service considering only patients who have a value of “low” on patient risk profile. Show the patient risk profile filter as a “Single value (dropdown)” filter in the view with “Low” selected in the filter. Also show in your viz the color legend for sum(minutes to service) with an “Automatic” and “Stepped” color palette having 6 steps. The completed viz is shown below that you need to reproduce.

 

 

 

Q4:         

We want to show a table of results as a Tableau viz where we show the total revenue, total days in the hospital, and average revenue per day of stay broken down by hospital branch, department type, and department with hospital branch at the highest level and department at the lowest level in the hierarchy. We wish to do this only for “High” risk profile patients, so please add a filter for Patient Risk Profile and choose the value of “High” for that filter. Show the filter on the canvas (i.e., in your view). Days in the hospital is calculated as the date difference between date of discharge and date of admit. Use the appropriate type of calculation for calculating the average revenue per day of stay keeping in mind that aggregate-level calculations are different from row-level calculations. Use column headings “Revenue”, “Days in the Hospital” and “Average Revenue Per Day of Stay” in your viz. The completed viz is shown below that you need to reproduce.

 

 

               

Q5:

We would like to analyze using a stacked bar chart the total number of patients by hospital branch and department (with hospital branch at the highest level) who received service in a reasonable amount of time. Using a parameter called “Reasonable Service Time (in mins)” and a calculated filed called “Service in Reasonable Time” with a value of

True/False, show the stacked bar chart for a value of 50 for the “Reasonable Service Time

(in mins)” parameter. Show both the parameter and the color legend for “Service in Reasonable Time?” field in your viz. The completed viz is shown below that you need to reproduce.

 

 

 

Sum                                                               of                                                                   Number                                                       of                                                                   Patient                                                         Visits                                                             for                                                                 each                                                               Department                                               broken                                                                        down                                                           by                                                                   Hospital                                                       Branch.                                                                                                                                Color                                                            shows                                                          details                                                           about                                                                        Service                                                           in                                                                    Reasonable                                                 Time?.                                                           

 

 

 

 

 

 

****