Learning Tableau

Welcome to your Specialist Quiz - Exploring & Analyzing Data

1. To flip a vertical bar chart to horizontal bar chart in Tableau –

a) Drag the measure to the columns shelf and the dimension to the row shelf

b) Drag the measure to the rows shelf and the dimension to the column shelf

c) Drag the measure to both the row shelf and the columns shelf

d) Drag the dimension to both the rows shelf and the column shelf

2. Types of Trend Lines that Tableau uses – [Select All that Apply]

a) logistic

b) Linear

c) Logarithmic

d) Multinomial

e) Polynomial

3. How to create a Geographical Hierarchy –

a) In the Analytics pane right-click the geographic field -> Create Hierarchy

b) In the Analytics pane right-click the create Hierarchy -> Select Hierarchy -> Ok

c) In the Data pane right-click the geographic field-> Hierarchy -> Create Hierarchy

d) In the Data pane right-click the geographic field-> Transform -> select Hierarchy -> Create Hierarchy

4. Are the Dual Axis chart and Combined Axis chart same? –

a) Both are the same

b) Dual axis chart creates two independent axes that whereas a combined axis chart merges two or more measures into a single axis

c) Combined axis chart creates two independent axes that whereas a dual axis chart merges two or more measures into a single axis

d) Dual axis chart is named as combined axis chart after merging two or more measures into a single axis

5. How to create a dual axis chart in Tableau? – [Select All that Apply]

a) Drag one dimension to Column and drag two measures to Row -> In the Rows right click any of the measure -> Select Dual axes -> Go to marks type of any of the measure and choose the chart type as Bar

b) Drag two dimensions to Column and drag one measures to Row -> Go to marks type of any of the measure and choose the chart type as Bar

c) Drag one dimension to Column and drag one measures to Row -> drag another measure to the chart itself and as the rectangle shape appears drop it -> Go to marks type of any of the measure and choose the chart type as Bar

d) Drag one dimension to Column and drag one measure to Row -> Go to marks type of any of the measure and choose the chart type as Bar

6. How to create a stacked bar chart while using a separate bar for each measure? – [Select All that Apply]

a) 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 -> Ok

b) Drag a dimension to Color -> Drag Measure Names to Rows and also drag Measure Values to Rows -> On the Columns shelf right-click Measure Names -> select Filter -> select the check boxes for the measures to display -> Ok

c) Drag a dimension to Color -> Drag Measure Names to Columns and drag Measure Values to Rows -> On the Columns shelf right-click Measure Names -> Ok

d) Drag a Measure Values to Color -> Drag Measure Names to Columns and drag Dimension to Rows -> On the Columns shelf right-click Measure Names -> select Filter -> select the check boxes for the measures to display -> Ok

7. 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 neighbourhood.

8. How to create Highlight Table or Heat Map in Tableau –

a) Drag one or more dimensions on the Columns shelf and one or more dimensions on the Rows shelf -> place a measure of interest on the Colour shelf -> Select Square as the mark type

b) Drag one or more dimensions on the Columns shelf -> Select Square as the mark type -> place a measure of interest on the Colour shelf.

c) Drag one or more dimensions on the Rows shelf-> Select Square as the mark type -> place a measure of interest on the Colour shelf.

d) Drag one dimension on the Columns shelf and one measure on the Rows shelf -> place a measure of interest on the Colour shelf.

9. How to create a group from a field in the Data pane? –

a) 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 -> Ok.

b) In the Data pane right-click a field -> select Group.

c) In the Data pane right-click a field -> Group

d) In the Analytics pane right-click a field -> select Group -> Ok

10. Which of the following are the types of sets in Tableau? – [Select All that Apply]

a) Singleton set

b) Dynamic set

c) Fixed set

d) Equal set

11. How to create a Hierarchy in Tableau? –

a) In Data pane drag a field and drop on top of another field -> enter a name of the hierarchy -> ok

b) Right click on a field -> Create Hierarchy -> Choose the fields -> ok

c) Right click on a field -> Create Hierarchy -> ok

d) Right click on a field -> Choose the fields -> Create Hierarchy -> ok

12. Filter dialog box offers the following tabs for filtering – [Select all that Apply]

a) Report

b) Wildcard

c) Condition

d) Top

13. How to create Relative Date Filters–

a) Drag a date field to the filter shelf -> Ok

b) Drag a date field to the filter shelf -> Select a time unit -> Ok

c) Drag a date field to the filter shelf -> Select a time unit -> Define the date period -> Ok

d) Drag a date field to the filter shelf -> Define the date period -> Ok

14. Which of the following are applicable for nested sort in Tableau? – [Select all that Apply]

a) Nested sort considers each pane independently and sorts the rows per pane

b) Nested sorts look correct within the context of the pane, but don’t convey the aggregated information about how the values compare overall

c) Sorting from an axis does not give a nested sort by default

d) While creating a nested sort, the sort is inherited when we drill down through the dimensions

15. Which of the following quick table calculations are available in Tableau? – [Select all that Apply]

a) Z-score

b) Percent of total

c) Rank

d) Percentile

16. How do you create a Binned Dimension in Tableau? –

a) In the Data pane right-click a measure -> select Create > Bins -> Create Bins dialog box accept the proposed New field name or specify a different name for the new field -> Mention the size of bins -> Ok.

b) In the Data pane right-click a measure -> Create Bins dialog box accept the proposed new field name or specify a different name for the new field -> Mention the size of bins -> Ok

c) In the Data pane right-click a measure -> select Create bins > Ok

d) Select Create > Bins -> Create Bins dialog box accept the proposed New field name or specify a different name for the new field -> Mention the size of bins -> Ok

17. The main types of calculations you can use to create calculated fields in Tableau: – [Select all that Apply]

a) Basic calculations

b) Level of Detail (LOD) expressions

c) Statistic Calculations

d) Table calculations

18. In which of the following scenarios parameter value or list of values can’t refresh – [Select all that Apply]

a) The default field returns null.

b) The default field returns a value whose data is incompatible with the parameter’s data type.

c) The default field is in a data source that’s not yet connected.

d) The user cancels the query to the data source while Tableau is attempting to connect.

19. How to show subtotals in a visualization in Tableau –

a) Click the Analytics pane -> In the Analytics pane under Summarize drag Totals into the Add Totals dialog -> drop it over Subtotals

b) Click the Analytics pane -> Click the Subtotals

c) Click the Data pane -> In the Data pane under Summarize drag Totals into the Add Totals dialog -> drop it over Subtotals

d) Click the Data pane -> Click the Subtotals

Learning Tableau

Learning Tableau

Specialist Quiz – Exploring & Analyzing Data

Leave a Reply Cancel reply

Download Practice Quizzes

Data Analyst Practice Quizzes

Specialist Practice Quizzes

Online Courses

Power BI