Unit 5

What is the most useful, frequently used process in interaction?

Comparing and Contrasting

If we are interested in seeing how the proportion of patients change across age groups for a single region, which graph is best? For example, consider the question: how does the proportion of patients vary across age groups for the South region?

Either Percent of Total or Small Multiples

You have 10 years of data showing the number of children (in thousands) who live in a home with only their mother. The data is grouped by the status of their mother as shown below: Consider the following graphs of year-to-year deviation by each status. This means that each bar or point in the graph shows the difference between the previous and the current year. For example, if you look at the data for Divorced mothers in 2013, it is -133, which means that the number of children living in a mother-only home with a divorced mother dropped by 133,000 from 2012 to 2013.

NOT Small multiples line chart of annual deviation Grouped bar chart of annual deviation

Based on the Pareto chart above, select the smallest number of diseases that account for over 60% of total insurer costs

hypertention Diabetes acid reflux

Suppose you have connected Tableau to the following data file:Before you can create a Bullet Graph in Tableau that displays both a current performance metric and projected future (year end) performance, such as you must define a calculated field, Expected Remaining, with the formula:

(([Units Using Process]/[Months])*12)-[Units Using Process]

Which statement is true about aggregating?

All of above

In the bump chart above, which status has the second-most number of children from 2000 to 2013?

Divorced

What do you need to do in Tableau to create the line portion on the Pareto chart above for Insurer Cost, such that it shows a running sum of % of Insurer Cost?

NOT Define a calculated field using the formula SUM([Insurer Cost]) and use the calculated field to make the line, then choose Quick Table Calculation->Percent of Total Finally, right click the rightmost axis and select Synchronize Axis Select Disease and Insurer cost in the Dimensions and Measure windows and then select the Pareto chart type in Show Me

Suppose you have the following data in Excel: and you would like to produce the following graph:

NOT Select both Actual Readmissions and Readmission Goal in the measures pane and then click Show Me's side-by-side bars icon Use a dual axis display

Why do we need to provide an overview first?

NOT It helps to give an overall sense of patterns in the data

Which of the following can be treated as a method of analytical interaction:

all of above

You have data showing the rate of hospital acquired infections for each of 20 units for the past 12 months. You would like to show how each unit ranks (with lowest rate being best) each month so that you can see how the ranking changes over time. What is the best chart to show change in rank by month?

A bump chart with month on the X axis and rank on the Y axis

Select the most accurate statement about filtering

ALL

The concept of a common baseline in charts such as the Grouped Bar Chart and Small Multiples is most related to which graphic design principle?

Alignment

At the most fundamental level, analytical navigation can be divided between two approaches: directed and exploratory. Which statement about these two approaches is true?

All of above

When constructing information visualizations, which of the following should you support?

All of above

Why do we want to avoid the pie chart in part-to-whole analysis, such as that shown above in the pie chart series?

All of above

To create a histogram in Tableau you will need to use

BINS

Which of the following is a valid Pareto chart?

C

In the graphs above, the color palette used to encode the three regions uses which graphic design principle to visually differentiate the regions?

Contrast

You create a dynamic dashboard in Tableau that uses a bar graph to show a hospital's readmission rate for each month. The data is subject to revision up to several months later as clinical records are updated. You would like the months in which the readmission rate goal of 2% was exceeded to use red bars and the other months to be in blue. What is the best way to do this in Tableau so that if the data changes the coloring will reflect these changes?

Create a calculated set that includes months where the readmission rate is above 2%

You have an Excel Spreadsheet with 3 years of monthly readmission data arranged in 3 columns: You import this data into Tableau and then would like to create a bar chart showing the number of patients above or below the readmission goal for each month. Select the best approach for doing this in Tableau

Create a new calculated field variable called Difference, defined as [Readmission Goal] - [Actual Readmission], then use Difference, instead of Readmission Goal and Actual Readmission to create the bar chart

Dashboards are used to Monitor Information at Glance and must provide all the details necessary to take action

FALSE

Quantitative data is required for an information display to be considered a dashboard.

FALSE

In Tableau, Keep Only and Exclude support

Filtering

Which of the following statements are true about the color coding used in Graph A? Note that for Graph A all Target bars are green and all Units Using Process bars are Red. Select all that apply.

Graph A may be somewhat misleading because green typically means good and red bad, so at a glance a user might assume that all the green bars mean good performance and the red bars bad performance and 2 more

If we want to know which region has the lowest proportion of patients in an age range, what is the most effective graph? For example, consider the question: which region has the lowest proportion of patients in the 41-54 age range?

Grouped Bar Chart

What function do the blue bars and lines best illustrate on this dashboard?

Highlighting

Select the most accurate statement about adding variables

In order to get a better perspective or context or to greater realize a potentially strong connection, we might need to add an additional variable

A dashboard is a VISUAL display of the most important INFORMATION needed to achieve one or more objectives that has been consolidated on a SINGLE computer screen so it can be monitored at a glance.

NEFN

Which should not be considered when designing an dashboard?

NONE

The position of the labels and bars on the grouped bar chart represents which graphic design principle?

NOT Alignment Proximity

The most direct way to display deviations is by calculating and plotting (such as on a bar chart) the difference between the comparative measure and the performance measure. For example, we could calculate and plot the target number of units - actual number of units. However, when we do this, the underlying raw data is not visible on the display. Which of the following are effective ways to supply this data? Select all that apply.

NOT For interactive visualizations, provide a tooltip on each performance measure and target that shows the raw performance and comparative measures. Use a diverging color palette to color code the raw data on the bar for the performance measures and the symbol for the comparative measures

Which of the following questions best represents a deviation analysis?

NOT What percentage of time do patients spend in a clinic's waiting room during their visit?

You have a number of units using a new quality improvement process for one year in three different hospitals. Each hospital has a different target number of units that were supposed to adopt the new process during the year. What is one way to normalize values in order to compare the hospitals' relative performance toward meeting the goal?

NOT Calculate the average number of units using the new process across all hospitals and compare each hospital to that number

What are some possible ways to use a bullet graph to display performance measures where lower is better? Select all that apply.

NOT Use a different color for the bar that encodes the performance measure. Reverse the background fill color so that the bar runs in the usual left to right direction, but the fill color for the performance regions runs from right (high values) to left (low values).

You have a number of units using a new quality improvement process for one year in three different hospitals. Each hospital had a different target number of units that were supposed to adopt the new process during the year. Which of the visualizations below are best for comparing the normalized performance of the hospitals toward meeting their targets? Select all that apply.

NOT C and D

Moving average is __

Re-expressing aggregating

In the stacked bar chart it is difficult to perceive the changes in proportion across age ranges for the South region (orange) becasue

The orange segments do not share a common baseline and are fairly similar in length

Select all of the problems below that apply to the specific Pareto chart above.

Visual clutter from many small values Handling values that vary greatly in magnitude

For which question would it be best to use a Pareto chart?

You know the percentage of patients who were readmitted and the reason for their readmission and you want to know the smallest number of readmission reasons that account for a total of 80% of readmissions

You have a worksheet with four variables: Hospital, Units Using Process (the actual number of units converted to a new process), Target (the number of units that was set as a goal for converting to the new process), and Missed Target (True if a hospital missed--fell below--its target, otherwise False). In Graph A above all Target bars are green and all Units Using Process bars are red. To create graph A, above, you must

drag Hospital to Columns Measure Names to Columns Measure Values to Rows then color the graph by dragging Measure Names to Color and finally filter Measure Names so that bars are shown only for Units Using Process and Target.

You have a number of units using a new quality improvement process for one year in three different hospitals. Each hospital had a different target number of units that were supposed to adopt the new process during the year. Which of the visualizations below are best for comparing 1) the difference in number of units using the process among the hospitals and 2) how many units each hospital is over or under its target? Select all that apply.

not D or E