BUS118D Exam 3

Marks Card

Assume we are creating a chart for our business data and want to show the number of businesses in each of the 10 metro areas in our data. If we wanted each show each metro area as a different color, which of the following features in Tableau would we use to set the color?

False

Calculated fields can be used in the row or column shelf, but they cannot be used in the marks card such as in the color shelf.

False

If we want to create multiple visualizations of the Yelp data, we need to re-import the data into a new workbook for each chart we want to create.

True

Similar to using the IF function in SQL, or the when().otherwise() function in PySpark, a calculated filter can be added in Tableau that contains an IF function based on other fields in the data.

True

The Yelp dataset contains 10 metro areas which are identified by state and the cities within each metro area, but not by country. We could filter data by state to include just Canadian cities, but we could also create a categorization for the Canadian cities by using the lasso tool in the map visualization.

Both pie and donut charts are considered poor choices, but the donut chart is slightly better.

The chapter discusses pie and donut charts. Which of the following is true about these charts?

We want to show those categories that tend towards the extremes - either 1 or 5 stars, so we are creating a chart with the average star ratings for each top-level category by metro area.

When creating a heat map, we can either use the default setting for color (minimum to maximum intensity) or we can select the "full color range" option. For which of the following charts based on the Yelp data would the full color range option be most appropriate?

True

When creating a treemap in Tableau, the size of the box and the color of each box both represent the aggregate value for that box (such as the sum of the number of people in our name treemap).

The name field from the business data

When loading Yelp data into Tableau (as a CSV file), which of the following fields would be characterized as a Dimension in the data pane?

We could filter both businesses by state and users based on their review count.

When wrangling our data in Spark, we could filter the Yelp data to include only businesses in certain states or only users who had written at least 10 reviews. Which of these could we also do in Tableau?

A dual-axis line chart will have two measures selected in the row shelf and the second measure is identified as dual-axis.

Which of the following is true regarding dual-axis line charts?

You can explore different common chart types with your data using the "show me" panel

Which of the following is true regarding selecting the chart type?

A range filter could not be created for a discrete dimension such as the business category (e.g., shopping vs. restaurants)

Which of the following is true when creating a filter?

We have not included a geographic dimension such as the state or city in our chart yet.

After loading the Yelp business data into Tableau, assume we drag the following two measures up to the row and column shelves respectively: Latitude (generated) Longitude (generated) Which of the following best describes why the map that is shown is still blank?

Each year that users joined Yelp

If you loaded the Yelp user data into Tableau and included the yelping_since date field, if you dragged that field to the columns shelf, by default, columns would be created for:

Integer variable

In comparison to Spark, a parameter in Tableau is most similar to which of the following?

Bar Chart

In creating a treemap, the initial chart that Tableau creates based on the dimensions and measures selected is a:

A window function

In creating the title for our chart in the treemap video, which of the following did we use?

To calculate the percentage using data for the entire year range from 1910 to 2018, regardless of the years selected in the filter.

In the treemap exercise, why did we use a FIXED LOD expression in calculating the gender percentage for each name?

Treemap

The categories used in the business data are hierarchical. For example, the top-level category "Active Life" includes a number of sub-categories for different activities, and one of those is "Diving". The Diving category includes the sub categories "Free Diving" and "Scuba Diving". If a business has "Scuba Diving" as a category, it will also always include "Diving" and "Active Life". If we wanted to show the number of businesses in each of the categories in Yelp (where each business is usually in multiple categories based on the hierarchy), Which of the following chart types would be a good choice for showing the relative size of each category (size being based on the number of businesses in that category)?