More practice Q's

Which of the following describes what Trend Lines are?

A feature Tableau to show a line that represents the relationships between a set of data points that have been plotted (i.e. regression)

You created a scatterplot in Tableau that contains plotted data points showing the number of class periods attended for a course vs. the grade assigned for students. You are trying to see if there is a positive relationship between the two. Which feature / function will best aid you in this?

Adding trend lines to the scatterplot

Jim is creating a visualization in Tableau. What would the chart look like if he: 1 / 1 point Drags state (which is designated as a location field) to detail • Drags order number to color • Sets the calculation type (measure) set to order number to count distinct (CNTD)

Ageographic map using a gradient color scheme to shade states based upon the number of orders for each state

On a dashboard, a filter can apply to which of the following?

All visualizations Only one visualization Only certain selected visualizations • All of the above

If you have a bar chart in Tableau showing the total sales by month and you also want to be able to show the returns by month in the same visualization, which of the following would be the best to use?

Color Mark

Which of the following features in Tableau is NOT found in the "marks" shelf?

Columns

Bree has data that contains a field, [avgSpeed], showing the by day the average speed or vehicles recorded by a sensor on the highway (ex. 65, 70, 73, 40, etc.) by day. The speed limit is 70. She wants to be able to show the one of two categories for each day based upon the average speed, where the average must exceed 5 over the limit of 70 to be considered speeding: a) Avg Speeding: >75 b) Avg Not Speeding: <= 75

Create the following calculated field: IF [avgSpeed] > 75 THEN "Avg Speeding" ELSE "Avg Not Speeding" END

What type of analytics are used when creating a bar chart showing the top selling real estate agents in the state and the amount of sales they had in the past month?

Descriptive analytics

Jackson has a set of data that lists profits for a particular product line based upon each of the states in which the products are sold. The range of values (by state) vary from $-128,319.34 to $267,987 for the month of April. Which of the following color schemes would be the best option for him to use for the profits for each state?

Diverging

A diverging color scheme would be one that shades of a single color diverge.

False

In a dual-axis chart, the scale for each axis must be the same. (For example: If a chart has a scale of 1 to 500 for the axis for sales, if profit was the second axis then the scale for profit must be set to 1 to 500)

False

What type of chart uses bins to represent ranges of values?

Histogram

Eric created a visualization with a lot of parallel bars, each of the same color. A pattern in the bars emerges making the visualization hard to see due to visual noise created by the effect of the bars. Which of the following describes this scenario?

Moire effect

A combination (combo) chart is one in which:

Multiple types of marks (i.e. line, bar, etc.) are utilized in a single visualization / chart

If you wanted to compare values in a time series to the prior value in the series, which of the following would allow you to accomplish this easiest in Tableau?

Quick Table Calculation

You are creating a line graph showing the number of students that have graduated from MSU over time. You want the line to show a running total of the number of students. Which Tableau feature would make this task easy?

Quick table calculation

When comparing two continuous measures (such as speed and acceleration), which of the following charts would be the best to visualize whether or not there is a relationship between the two?

Scatterplot

In Tableau, creating relationship between certain fields (such as city, state and country) is accomplished through which feature?

Select Hierarchy -> Create Hierarchy on the selected data fields

George has created a bubble chart in Tableau to show different colleges and the number of students at each. Which mark with the bubble chart would be most effective at showing the number of students at each college, if each college is represented by a bubble?

Size

You created a scatterplot in Tableau that contains plotted data points showing the number of bedrooms in a house vs. the price of the house. You are trying to see if there is a positive relationship between the two. Which feature / function will best aid you in this?

Trend lines

Continous data can take on any value within a range.

True

One example of continuous data is height.

True

Tableau can import static data (such as that from a spreadsheet or cv file) and/or can also connect to live data sources such as databases for real time data.

True

Trinity is holding a competition for her sales associates. The sales associate (field SalesAssociate) with the most sales at the end of the year will get an addition to their bonus. Sales numbers are reported each week showing how much her sales associates sold that week (field Sales). Which of the following would allow her to show on a line graph who is in the lead over time?

Utilizing Running Totals under Quick Table Calculation on SUM(Sales)

When would it be better to use diverging colors instead of sequential colors in a visualization?

You would use diverging colors when there is a meaningful middle point (such as O) that you want the visualization to demonstrate differences from.

Which of the following charts are good for showing data changes over time?

line chart

What chart type would be the best to show the hierarchical nature of data (i.e. how sub-components build up to their parent components)?

tree map