Mid3 Quizzes
In creating the title for our chart in the treemap video, which of the following did we use?
A Window Function
Which of the following is true regarding dual-axis line charts?
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 when creating a filter?
A range filter could not be created for a discrete dimension such as the business category (e.g., shopping vs restaurants)
In creating a treemap, the initial chart that Tableau creates based on the dimensions and measures selected is a:
Bar Chart
The chapter discusses pie and donut charts. Which of the following is true about these charts?
Both pie and donut charts are considered poor choices, but the donut chart is slightly better.
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:
Each YEAR that users joined yelp
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.
False
In comparison to Spark, a parameter in Tableau is most similar to which of the following?
Integer Variable
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?
Mark Card
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?
The Name field from the business data
In the treemap exercise, why did we use a FIXED LOD expression in calculating the gender percentage for each name?
To calculate the percentage using data for the entire year range from 1910 to 2018, regardless of the years selected in the filter.
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)?
Treemap
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.
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).
True
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?
We could filter both businesses by state and users based on their review count.
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?
We have not included a geographic dimension such as the state or city in our chart yet.
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?
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.
Which of the following is true regarding selecting the chart type?
You can explore different common chart types with your data using the "show me" panel
