Unit 5

Question 1

Moving average is

Answer 1

1. Re-expressing
2. aggregating

Question 2

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

Answer 2

All of above:
#Exploratory analysis begins by looking at the data without predetermining what you expect to find, proceeds to noticing things in the data that are interesting and asking a question about it, then proceeds in a directed fashion in search of an answer to that question
# Directed analysis begins with a specific question that you wish to answer, proceeds to a search specifically for the data that will answer that question, such as a particular pattern, and hopefully results in finding the answer.
# Comprehensive analysis requires that you sometimes start with a blank slate and let the data itself direct you to items worth examining.

Question 3

Select the most accurate statement about adding variables

Answer 3

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

Question 4

Exceptionally well organized

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

Answer 4

All of above:
#Overview first
#Zoom and filter
#Details on demands

Question 5

Which statement is true about aggregating?

Answer 5

Viewing data at different categorical levels (e.g., country, state, zipcode) is aggregating

All of above

# The median is one way to aggregate measures
# Defining a group of values of a certain dimension or measure (such as grouping all elective procedures into a single “elective procedures” group) is one way of aggregating

Question 6

Condensed, primarily in the form of summaries

Suppose you have the following data in Excel:

and you would like to produce the following graph:

Answer 6

Use Measure Names and Measure values

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
• Either a dual axis display or using Measure Names and Measure Values would both work

Question 7

Specific to the task at hand and to those who will use it

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

Answer 7

Comparing and Contrasting

Question 8

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

Answer 8

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

Question 9

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

Answer 9

All of above :
#Re-expressing
#Annotating
#Aggregating

Question 10

Select the most accurate statement about filtering

Answer 10

All of above :

#Filtering is the act of reducing data to a subset
# The goal of filtering is to get any information we don’t need out of the way for the moment
# Filtering can change calculations in Tableau

Question 11

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?

Answer 11

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

Question 12

You have an Excel spreadsheet with a column that looks like this:

Date
January, 2015
February, 2015
March, 2015

and so on through May, 2015.

When you connect to this data from Tableau, what data type will Tableau use for the Date field?

Answer 12

String -
Since Month, Year is not a date format that Tableau recognizes it will treat the field as a String. You must specify a complete date, such as 1/1/2015. You cannot leave out the day and just specify the month and year.

Question 13

Select the most accurate statement about dimensions and measures

Answer 13

A dimension is a field that is treated as a categorical variable, such that a measure can be aggregated for each categorical value of the dimension. For example, if surgical unit is a dimension and admissions is a measure, then number of admissions can be aggregated for each surgical unit.

All of above :
# A dimension is a field that is treated as a categorical variable, such that a measure can be aggregated for each categorical value of the dimension. For example, if surgical unit is a dimension and admissions is a measure, then number of admissions can be aggregated for each surgical unit.
# A measure is a field that is a numerical variable. Measures can be aggregated for other dimensions on the worksheet. For example, if surgical unit is a dimension and admissions is a measure, then number of admissions can be aggregated for each surgical unit.
# By default, Tableau treats any field containing qualitative, categorical information as a dimension
# By default, Tableau treats any field containing numeric (quantitative) information as a measure

Question 14

If you want a visual object to stand out and be easy to find you should

Answer 14

use a strong preattentive attribute for the target and ensure it is very different from all distractors

Question 15

A scatterplot encodes age as the size of the marks and as the intensity of the mark’s hue. This is an example of an

Answer 15

redundant coding -
A redundant code is one in which two or more visual features are used to encode the same variable. Here, both size of marks and intensity encode age.

Question 16

A scatterplot encodes age as the width of the marks and weight as the orientation of the marks. This is an example of

Answer 16

an orthogonal coding
Yes, an orthogonal code is one that uses two or more visual features to encode different variables

Question 17

Select the most accurate statement about filtering

Answer 17

All of above :
#Filtering is the act of reducing data to a subset
# The goal of filtering is to get any information we don’t need out of the way for the moment
# Filtering can change calculations in Tableau

Question 18

Select the most accurate statement about adding variables

Answer 18

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

Question 19

In Tableau, Keep Only and Exclude support

Answer 19

Filtering

Question 20

Why do we need to provide an overview first?
It helps to give an overall sense of patterns in the data
It helps the user decide the next move in information retrieval
It helps in deciding where the important details lie in a graph

Answer 20

All of above :
#It helps to give an overall sense of patterns in the data
# It helps the user decide the next move in information retrieval
# It helps in deciding where the important details lie in a graph

Question 21

Suppose you want to produce a visualization that shows the total cost of disease for each of 10 different diseases. Of the following options, what is the best way to encode the cost of each disease to ensure precise quantitative perception and comparison of values?

Answer 21

Use a bar chart with a bar for each disease where the height of each bar encodes the cost of a single disease