Connecting to and Preparing Data
While assigning geographic role to a field, Tableau adds two fields to the Measures area of the Data pane:
Latitude and Longitude
Filter dialog box offers the following tabs for filtering – [Select all that Apply]
a) Report
b) Wildcard
c) Condition
d) Top
b, c, d
How do you change the color of a chart from Marks card in Tableau?
There are two ways to change color from Marks card – For an existing chart select the All in Marks card -> Select Color -> Edit Colors -> From the Select Color Palette select any of the desired option -> From the select Data item choose desired color for each of the measure -> Apply
In Tableau, a discrete field is shown in which color?
Blue
In a Relationship we need to define the following Join type –
a) Inner Join
b) Left Join
c) Right Join
d) It is not required to define a join type in a relationship
d) It is not required to define a join type in a relationship
How do you create a group from a field in the Data pane?
In the Data pane right-click a field -> select Create -> In the Create Group dialog box select the members that needs to be grouped -> Group
In the Data pane right-click a field -> select Group
How can we change the size of marks in Tableau?
To change the size of marks in Tableau - After creating any chart go to Marks card -> Select the size -> Move the slider to the right or left to increase or decrease the size of the chart
How can we disaggregate data in Tableau?
For any visualization Go to Analysis -> Uncheck the Aggregate Measures
Which option leads to adjusting the granularity of data in Tableau?
a) Aggregate
b) Group by
c) Grouped Fields
d) Extract
a) Aggregate
What is the difference between a dual axis chart and a combined axis chart?
Dual axis chart creates two independent axes while a combined axis chart merges two or more measures into a single axis.
How do you create a viz in tooltip in Tableau?
Create a visualization in the source worksheet in Tableau and create a visualization in a target worksheet view to serve as the Viz in Tooltip and rename it to identify. In the source worksheet, click Tooltip in the Marks card and select insert and select the target worksheet.
What are the differences between dimensions and measures?
Measures contain quantitative values whereas Dimensions contain names, dates or Geographical data
Dimensions increase the level of detail in the view while measures are aggregated when added to the view.
Advantages to using relationships to combine tables
Make it easier to analyze data across multiple tables at different levels of granularity
Tables are only queried when fields from the tables are added to the viz.
Which of the following applies for Density map in Tableau – [Select All that Apply]
a) To create a density map, the data source should contain Latitude and Longitude coordinates or location names
b) Tableau cannot recognize location names and create a density map using the point locations assigned to Tableau geocoding locations
c) Density maps are most effective when the location data is very precise, such as location coordinates in a limited space
d) Density marks work best where the specific locations change continuously and smoothly across space, rather than values constrained to discrete locations like borough or neighborhood.
a, c, d
How can we publish a workbook for Tableau?
Open the desired workbook for publish. Go to File. Click on Save to Tableau Public As. Sign in to the server. Name the workbook for publish.
What happens to the display of a discrete field when dragged to Color in Marks Card?
When dragged to the color of Marks Card, Tableau displays both the categorical palette and a legend with a color for each value of the field.
What is the correct pathway to edit a data source?
On the Data menu, select a data source, and then select Edit Data Source. And, then on the data source page, make the changes to the data source.
How to create a stacked bar chart while using a separate bar for each measure?
To create a stacked bar chart while using a separate bar for each measure we need to follow the steps - Drag a dimension to Color -> Drag Measure Names to Columns and drag Measure Values to Rows -> On the Columns shelf right-click Measure Names -> select Filter -> select the check boxes for the measures to display
How can we manually add separate device layout in Tableau?
To manually add separate device layouts we need to open a dashboard. On the Dashboard tab on the left, click Device Preview. Then take a moment to click through the Device types and Models and explore the different screen sizes. Also there is a button to turn the dashboard into landscape or portrait mode
What are the differences between discrete date and continuous date values? [Select all that Apply]
a) Discrete date part color is Blue whereas the Continuous date part color is Green
b) Discrete date creates labels whereas the Continuous date creates axes
c) Discrete date aggregates data at the selected unit whereas the Continuous date uses individual date values
d) Continuous date part color is Blue whereas the Discrete date part color is Green
a, b, c