What types of data sources can Tableau connect to?
Click to see answer
Tableau can connect to Tableau Servers, Excel spreadsheets, Google Sheets, and many more options.
Click to see question
What types of data sources can Tableau connect to?
Tableau can connect to Tableau Servers, Excel spreadsheets, Google Sheets, and many more options.
What is created by a calculated field that has a formula of SUM(Sales) / SUM(Profit)?
A measure.
What are two examples of a date value?
A. January 1, 1995 and D. 2020-05-01.
What will be the first data value in a visualization when using quick table calculations like Percent Difference from?
Null.
Which two types of aggregations can be applied to string fields?
Minimum and Count Distinct.
From which three locations can you sort a visualization in Tableau?
C. An axis, E. A field label, F. A header.
What does it mean when a post is upvoted?
It indicates that users found the content helpful or agreeable.
What type of field is NOT created by the formula SUM(Sales) / SUM(Profit)?
A dimension.
What is the purpose of connecting to data in Tableau?
To visualize the data needed for analysis.
Which two filter modes can you use with dimension filters?
C. Wildcard Match and D. Multiple Values (drop-down).
Why are A and D considered date values?
Because they represent continuous dates and can be transformed into numbers.
What are two methods for renaming a field in a visualization?
A. From the Data pane, use the field’s drop-down menu and select Rename. C. From the Data pane, click and hold on the field until the name is editable.
What is the correct answer for the formula SUM(Sales) / SUM(Profit) in terms of field type?
A measure.
Why is the first value in a year-over-year growth calculation left blank?
Because there is no previous year to compare to.
What should you configure for a field to provide additional information when hovering over it in the Data pane?
A default comment.
Why can't sum or average be applied to string fields?
Because string fields cannot be mathematically aggregated in that way.
What action should you perform to display the complete list of potential data connections when connecting to a server?
Select More under To a Server.
What is the correct answer for sorting a visualization in Tableau?
C, E, and F.
What option should you use to invert the color intensity of a quantitative range?
B. Reversed
What is the significance of the year format in date values?
AD indicates a date in the Anno Domini era, while BC refers to Before Christ.
What option allows you to rename a field by right-clicking it?
Replace References.
What are some filter modes available for dimensions in Tableau?
Single Value (List), Single Value (Dropdown), Single Value (Slider), Multiple Values (List), Multiple Values (Dropdown), Multiple Values (Custom List), Wildcard Match.
What percentage of community votes selected 'A measure' as the correct answer?
100%.
What is the significance of the letter 'C' in the context of answers?
It refers to the correct answer choice in a multiple-choice question.
What is the correct answer when calculating quick table calculations without a previous period?
B. Null.
What are the correct aggregation options for string fields?
Minimum, Maximum, Count, and Count Distinct.
How do you add a default comment to a data field in Tableau?
Right-click on the data field in the Data pane, choose Default properties, select comment, and add the comment.
What is the correct option to expand the list of server connections in Tableau?
C: Select More under To a Server.
How many locations can you sort a visualization from in Tableau?
Three locations.
Which menu can be used to select Field Labels for formatting?
The Format menu.
What is the purpose of relating tables in Tableau?
To combine data from different sources while maintaining their individual structures.
What does 'upvoted 2 times' signify?
The post received two votes of approval from users.
What happens when you select 'Reversed' in a sequential palette?
Lower values have a darker intensity.
When should you use a relationship instead of a join for two data sets?
When the data sets include similar data aggregated at different levels of detail.
What do relationships in a data model query?
Only the tables and fields needed to create a visualization.
What does the Connect Pane in Tableau show when you launch it?
The data connectors available to you.
What are aliases in the context of dimensions?
Aliases are alternate names for members in a dimension that change their labels in the view.
What calculated field produces an output of 'Sales' from the string 'Sales Data'?
B. LEFT('Sales Data', 5)
How can you add additional connections to different databases in Tableau?
From the Connections pane, select Add.
What are the benefits of using relationships over joins in Tableau?
Relationships allow for more flexible data modeling and can handle different levels of detail.
What does reversing a diverging color palette do?
It swaps the two colors in the palette and inverts the shades within each color range.
What is one use case for creating hierarchies from the Data pane?
To organize related fields together.
What is a key advantage of using relationships in Tableau?
Tableau adjusts join types intelligently and preserves the native level of detail in your data.
What is the purpose of clicking 'More' in the Connect Pane?
To see the complete list of data connectors you can use.
What is the correct answer for providing additional information in the Data pane?
C. A default comment.
Are relationships in Tableau supported only when using extracts?
No, relationships can apply to both extract and non-extract data sources.
Can aliases be created for continuous dimensions?
No, aliases can only be created for discrete dimensions.
Why is option A (LEFT('Sales Data')) incorrect?
It lacks an argument specifying the number of characters to return.
What happens if you select 'New Data Source' from the Data menu?
It will replace the current data source.
What is a key characteristic of relationships in Tableau?
They do not merge data until a visualization is created, preserving the original data structure.
What are the options for aggregating a dimension in Tableau?
Minimum, Maximum, Count, or Count (Distinct).
What is another use case for creating hierarchies from the Data pane?
To add drilldown functionality for fields.
What creates a line chart in Tableau when using the Marks card set to Automatic?
Placing measures on one shelf and a date dimension on the other.
What does Tableau allow you to see when using relationships?
Aggregations at the level of detail of the fields in your visualization.
What are three reasons to use joins instead of relationships?
A. You need to use a specific join type. C. You need to use row-level security. D. You need to use a data model that supports shared dimensions.
What is one characteristic of relationships regarding the native level of detail?
Relationships are aware automatically of the native level of detail of logical tables.
How can you access options to apply bold formatting to an axis in Tableau?
Right-click on the axis.
Do aliases change the actual database?
No, aliases do not change the real database.
How many positions does the word 'Sales' have?
5 positions.
What happens when you aggregate a dimension in Tableau?
It creates a new temporary measure column, making the dimension take on the characteristics of a measure.
What happens to the original dimension field when a new group is created in Tableau?
The grouped dimension replaces the original dimension field on Rows or Columns.
Why is option B the correct choice for adding connections?
It allows you to manage and add additional connections without replacing the current data source.
How do relationships affect data blending in Tableau?
They enable blending of data from different sources without requiring a common field.
Which statement accurately describes aliases in Tableau?
You can assign an alias to a field member before creating a visualization.
Which option is NOT a use case for creating hierarchies from the Data pane?
To concatenate all fields into a single field.
What is the correct combination of fields to create a line chart in Tableau?
A date dimension and one or more measures.
Which two types of fields appear blue in Tableau?
B. Discrete dimensions and C. Discrete measures.
When should you consider using joins in Tableau?
When you need to explicitly use a specific join type, implement row-level security, or use a data model that supports shared dimensions.
What is the correct answer for when to use a relationship?
C. The data sets include similar data aggregated at different levels of detail.
What happens when you select 'Field Labels' on the Format menu?
It will only bold the field, not the axis.
What is incorrect about how relationships query data?
Relationships do not query every table in a data model regardless of whether the fields are in the visualization.
What is the difference between discrete and continuous dimensions regarding aliases?
Aliases can only be created for discrete dimensions, not for continuous dimensions, dates, or measures.
What should you do to compare top and bottom hotel chains to all remaining chains in a crosstab?
Include an Other group.
What is the purpose of the Connections pane in Tableau?
To manage your data connections and add additional connections to different databases.
Which statement is true about the existence of a newly created group in Tableau?
A newly created group only exists in the current view.
Can aliases change the name in the database?
No, assigning an alias does not change the name in the database.
What are the correct answers for the use cases of creating hierarchies?
A. To organize related fields together and B. To add drilldown functionality for fields.
What is the correct syntax to extract 'Sales' from 'Sales Data'?
LEFT('Sales Data', 5)
Why won't a line chart be created if a date dimension and a measure are placed on the same shelf?
Because the line chart requires measures on one shelf and a date dimension on the other.
What color represents continuous fields in Tableau?
Green.
Can joins be used between data from different connections?
No, joins can only be done between data that come from the same connection, unless using newer versions of Tableau.
When can aliases be assigned in Tableau?
Aliases can be assigned before creating a visual, and it doesn't matter when they are assigned.
What is the correct answer to improve a crosstab showing hotel chains by cost?
C: Include an Other group.
What does the grouped dimension do in relation to the Color shelf?
The grouped dimension does not get added to the Color shelf.
What is one alternative way to format text in Tableau?
Select Format > Font from the menu.
Can you create an alias for a discrete measure?
No, aliases can only be created for discrete dimensions.
What is the minimum requirement for creating a line chart in Tableau?
At least one measure and one date dimension.
What should you do if you need to relate tables across different databases?
Add them as data connections within the same data source.
What happens when a continuous field is placed on the Rows or Columns shelf in Tableau?
An axis is created in the view.
What is a situation where you might still use joins?
When you want to continue using a data source from a pre-2020.2 version of Tableau.
What is automatically constructed when a new group is created in Tableau?
A default is automatically constructed using the combined member names.
What does placing a discrete field on the Rows or Columns shelf create in Tableau?
A header in the view.
Can you create an alias for a continuous dimension?
No, aliases cannot be created for continuous dimensions.
What is the correct method to format an axis in Tableau?
Right-click on the axis and select Format.
What does the header for a group mark show in Tableau?
It shows as a consolidated alias of Group members.
What is the definition of a continuous field?
Forming an unbroken whole, without interruption.
Can you change the font of the axis by clicking on the field?
No, you cannot change the font of the axis by clicking the field.
What happens when you assign an alias in Tableau?
It changes how the value is shown in the visualization, not in the database.
What are the 8Rs in Tableau relationships?
Retain, Remove, Recover, Relevant, Replicate, Resolve, and others.
What are two effective ways to distinguish sales from profit in a dual axis chart?
Change the mark types of sales and profit, and change the color of sales and profit.
What does the term 'discrete' mean in the context of Tableau fields?
Individually separate and distinct.
What does 'Retain' mean in the context of Tableau relationships?
All measure values represent unmatched measures as zero with ZN().
What is the correct answer choice for distinguishing sales and profit in a dual axis chart?
B and D.
What is the purpose of 'Remove' in Tableau relationships?
To remove unmatched values with filters.
What does changing the mark types help achieve in a dual axis chart?
It helps to visually differentiate between sales and profit.
How does 'Recover' function in Tableau relationships?
It recovers unmatched dimensions with measures.
Why is changing the color of sales and profit important in a dual axis chart?
It enhances visual distinction between the two measures.
What is one benefit of using extracts compared to live connections in Tableau?
Calculated fields perform better in workbooks connected to extracts than in workbooks with live connections.
What does 'Relevant' refer to in Tableau relationships?
Relevant dimension domains are shown across tables.
How do extracts improve query performance?
Extracts are stored in memory (RAM), resulting in faster query performance compared to live data connections.
What does 'Replicate' mean in the context of Tableau relationships?
Measures are replicated across lower levels of detail in the visualization.
What advantage do extracts provide regarding data storage on a client computer?
Extracts reduce the amount of data stored on a client computer compared to live data connections.
What does 'Resolve' indicate in Tableau relationships?
Aggregations are resolved to the measure's native level of detail.
Why can live connections be slow?
Live connections can be slow due to network and user traffic, whereas extracts improve performance.
Can relationships still be used with live connections in Tableau?
Yes, relationships can still be used when selecting a live connection to data.
What is a key advantage of extracts for large datasets?
Extracts can support large datasets, including billions of rows of data.
What functionality do extracts support that may not be available with live connections?
Extracts allow you to compute Count Distinct, which may not be supported by the original data.
How do extracts provide offline access to data?
Extracts allow you to save and work with data locally when the original data is not available.
