Tableau Qualified Associate
The row and column shelves contain these Grand Totals Pills Filters
Pills
Tableau can create worksheet-specific filters. a. True b. False
True
A ___ action allows Tableau to open a page on an external website. URL Filter Highlight Web
"A URL action is a hyperlink that points to a Web page, file, or other web-based resource outside of Tableau."
A trendline using an exponential model type will be fit using exponential regression
"Although trend lines may be of type linear, logarithmic, exponential, or polynomial, this does not indicate that any of these models is not a linear regression."
The term "addressing" refers to the direction of a calculation
"The dimensions that define how to group the calculation, that is, define the scope of data it is performed on, are called partitioning fields. The table calculation is performed separately within each partition. The remaining dimensions, upon which the table calculation is performed, are csed addressing fields, and determine the direction of the calculation."
Which of the following is used to assess trendline significance: a. SSE b. R-Squared c. p-value d. slope e. None of the above
"The smaller the p-value, the more significant the model is. A p-value of 0.05 or less is often considered sufficient."
Gantt charts are useful for: a. Showing changes to a continue variable over time b. Displaying duration of events or activities over time c. Showing how a measure varies with respect to one or more dimensions d. Display the distribution of a continuous variable
"Use Gantt charts to show the duration of events or activities."
When you sort data in a hierarchy, Tableau rearranges headers that appear before the sorted field.
(FALSE) "Tableau does not rearrange [hierarchy] headers that appear before the sorted field."
Knowledge: Bins acts as containers that summarize data for a specific range of values. Without using a calculated field, Tableau's bin feature allows you to create variable sized bins.
(FALSE) If you want to create variable sized bins, you'll need to create a calculated field with IF THEN ELSE statements.
SUM is a table calculation
(FALSE). Sum is an aggregate calculation, but not a table calculation
You can combine multiple worksheets in a single dashboard.
(TRUE) "A dashboard is a collection of several worksheets and supporting information shown in a single place so you can compare and monitor a variety of data simultaneously."
Context Filters are executed after data source filters.
(True) Context filters are executed after data source filters but before dimension source filters.
To connect to multiple tables in a single data source at one time, what must be specified? a. A blend b. A calculation c. A join d. A hierarchy
A Join
Pareto charts combine the following elements: a. Tree maps & heat maps b. Bar & trend lines c. Pie charts & packed bubbles d. Left and right axis line graphs e. None of the Above
A Pareto chart is a type of chart that contains both bars and a line graph.
If you see duplicate data after doing a join you can do the following: Combine the tables using a cross database join rather than a standard join. Add a duplicate filter to your data. Change the join condition. Change to a full outer join.
Change the join condition There is no option to filter duplicates. A full outer join can still include duplicates if there are multiple matches on the join condition. In some situation blending data can avoid duplication you would get with a join, but this wasn't one of the answers. Changing the join condition can remove duplicates if the original condition was giving more matches that the modified join condition.
_______ is a technique in Tableau which will identify marks with similar characteristics. a. Trendline b. Clustering c. Box Plots d. Distribution Bands
Clustering
If you would like your Top N or Bottom N set to change depending on what filter choices are changed, what type of filter should use use? a. Context b. Dimension Filters c. Measure Filters d. None of the above
Context filters are applied before the Top N filters are applied. For example, you have a context filter on Region = West and set showing the top 5 customers with the highest sales, the filter on region will first limit your data to show only rows with the West region, and then the set will determine the top 5 customers for those rows.
Tableau displays an axis when you drop this onto the Rows or Column shelf. Continuous field Discrete field Measure names Measure values
Continuous field Measure values Tableau displays and axis when you drop a continuous field onto the row or columns shelf. The automatically generated Measures Values field is always a continuous field.
If a field has a blue background, that means the field is Continuous Discrete Dimension Measure
Discrete
A dimension is a field that typically holds ___________ Numerical data Discrete qualitative data
Discrete qualitative data
Adding a dimension to the row or column shelf will filter your data. True False
FALSE
All rows from both tables are returned in an INNER JOIN. True False
FALSE
A visual best practice is that if you are using a color gradient to represent a continuous variable which can be negative or positive, you should use a single color range.
FALSE Tableau suggests a two color range if the variable can be negative or positive
The metadata grid displays the fields in your data source in columns.
FALSE "The metadata grid displays the fields in your data source as rows so that you can quickly examine the structure of your Tableau data source and perform routine management tasks, such as renaming fields or hiding multiple fields at once."
Sorts can break the dimension hierarchy. In other words, Tableau will rearrange any the headers of the fields that appear to the left of the sorted field.
False
Which of the following are generated fields in Tableau (select all that apply) a. City b. Number of Records c. State d. Measure Names e. Distinct Values Generated fields
Generated fields include: Measure Values, Measure Names, Number of Records, Latitude and Longitude
Suppose that your data has a dimension called "Product Category," which has the values "Furniture," "Office Supplies," and "Technology." Which of the following should you use to combine Furniture and Office Supplies into a single category? Hierarchy Group Filter
Group
Which of the following charts uses binned data? Pie Chart Box Plot Histogram Bullet Graphs
Histogram
When using a _____ join the result is a table that contains all values from the left table and corresponding matches from the right table. INNER LEFT RIGHT FULL OUTER BLEND
LEFT
Dates are typically treated as ________________? Dimensions Measures
Measures
Which of the following charts types always includes bars sorted in descending order? Gantt Chart Pareto Chart Combo Chart Bar in Bar
Pareto Chart
A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead. True False
TRUE
LEFT JOIN returns all rows from the left table, with the matching rows in the right table. True False
TRUE
The benefits of creating a Tableau data extract include improving performance and allowing offline access to the data.
TRUE These benefits are described here: http://onlinehelp.tableau.com/current/pro/desktop/en-us/extracting_data.html
You want to email a packaged workbook containing a Tableau Dashboard to a coworker who does not have a license for Tableau Desktop. Which application will allow her to view the dashboard you send via email? a. Tableau Public b. Tableau Server c. Tableau Viewer d. Tableau Reader
Tableau Reader is a free application that can be used to open and see workbooks that have been built in Tableau
What does the box in a box plot represent? a. Maximum extent of the data b. The range of the middle half of the data points c. The median of the middle half of the data points d. The outliers of the data
The range of the middle half of the data points
Bullet graphs combine bar charts and reference lines.
True
When might you want to use a context filter? When you want to FIRST apply a filter and THEN show the Top N or Bottom N elements. When you want to filter on a range of values rather than a single value. When you want to FIRST show the Top N and Bottom N and THEN apply a filter. When you want to filter on you data based on a secondary data source.
When you want to FIRST apply a filter and THEN show the Top N or Bottom N elements
This type level of detail expression computes total sales for the region, regardless of what dimensions are shown in the view. {SUM([Sales])} { FIXED [Region] : SUM([Sales]) } { ONLY [Region] : SUM([Sales]) } { EXACT [Region] : SUM([Sales]) }
{ FIXED [Region] : SUM([Sales]) }
