Tableau Data Analyst Certification
Exam UPDATED ACTUAL Questions
and CORRECT Answers
/. Which of the following best describes the fundamental end to end workflow for
providing insights from data using Tableau ?A - Connect to, Clean & Share the DataB -
Connect to, Build Views to Analyse & Share the DataC - Connect to, Build Views to
Analyse & Certify the DataD - Connect to, Certify & Share the Data - Answer- - The
Tableau Desktop workflow consists of connecting to, analyzing, and sharing your data
/.What is the difference in functionality between tableau Desktop and Tableau Online
when it comes to configuring reference lines and reference bands? - Answer-Desktop
has an option for Box Plot, web version does not
/.What does the box in a box plot represent? - Answer-middle 50% of data, the 2 middle
quartiles of the data distribution
/.How do dynamic sets work? - Answer-The members of a dynamic set change when
the underlying data changes. Dynamic sets can only be based on a single dimension.
/.how do fixed sets work? - Answer-The members of a fixed set do not change, even if
the underlying data changes. A fixed set can be based on a single dimension or multiple
dimensions.
/.What options do you have when creating a combined set? - Answer-- All members in
both sets
- shared members in both sets
- Except shared members
/.What is the wildcard tab for when filtering on dimensions? - Answer-(Tableau Desktop
only): Use the Wildcard tab to define a pattern to filter on. For example, when filtering on
email addresses you might want to only include emails from a specific domain. You can
define a wildcard filter that ends with "@gmail.com" to only include Google email
addresses.
/.Are reference lines added to a discrete or continuous axis in a view? - Answer-
continuous
/.3 ways you can sort on a visualization in tableau - Answer-you can sort from the
header, axis, or field label
, /.What is the condition tab for when filtering on dimensions? - Answer-Use the Condition
tab in the Filter dialog box to define rules to filter by. For example, in a view showing the
average Unit Price for a collection of products, you may want to only show the Products
that have an average unit price that is greater than or equal to $25. You can use the
built-in controls to write a condition or you can write a custom formula.
/.What is the order of operations of Filters in Tableau? - Answer-1. Extract filters
2. Data source filters
3. Context filters
4. Filters on dimensions (whether on the Filters shelf or in filter cards in the view)
5. Filters on measures (whether on the Filters shelf or in filter cards in the view)
/.How do you add members to an existing group? - Answer--In the Data pane, right-click
the group field, and then click Edit Group.
- In the Edit Group dialog box, select one or more members and drag them into the
group you want.
Click OK.
/.What does the table calculation 'Table (across)' do ? - Answer-Computes across the
length of the table and restarts after every partition
/.What does the table calculation 'Table (across then down)' do ? - Answer-Computes
across the length of the table, and then down the length of the table.
/.What does the table calculation 'Pane ( down)' do ? - Answer-Computes down an
entire pane (NOT the whole of the table)
for example; if years are in rows it will only calculate each year, etc
/.What does the table calculation 'Specific Dimension' do ? - Answer-Computes only
within the dimensions you specify.
/.What does the table calculation 'Pane ( down then across)' do ? - Answer-Computes
down an entire pane and then across the pane
/.What does the table calculation 'Pane ( across then down)' do ? - Answer-Computes
across an entire pane and then down the pane.
/.What does the table calculation 'Table (down then across)' do ? - Answer-Computes
down the length of the table, and then across the length of the table.
/.What does the table calculation 'Table (down)' do ? - Answer-Computes down the
length of the table and restarts after every partition.
/.if you want to rename a dimension what can you do? - Answer-You can not rename
the original dimension; but you can create a duplicate and rename that to achieve this
Exam UPDATED ACTUAL Questions
and CORRECT Answers
/. Which of the following best describes the fundamental end to end workflow for
providing insights from data using Tableau ?A - Connect to, Clean & Share the DataB -
Connect to, Build Views to Analyse & Share the DataC - Connect to, Build Views to
Analyse & Certify the DataD - Connect to, Certify & Share the Data - Answer- - The
Tableau Desktop workflow consists of connecting to, analyzing, and sharing your data
/.What is the difference in functionality between tableau Desktop and Tableau Online
when it comes to configuring reference lines and reference bands? - Answer-Desktop
has an option for Box Plot, web version does not
/.What does the box in a box plot represent? - Answer-middle 50% of data, the 2 middle
quartiles of the data distribution
/.How do dynamic sets work? - Answer-The members of a dynamic set change when
the underlying data changes. Dynamic sets can only be based on a single dimension.
/.how do fixed sets work? - Answer-The members of a fixed set do not change, even if
the underlying data changes. A fixed set can be based on a single dimension or multiple
dimensions.
/.What options do you have when creating a combined set? - Answer-- All members in
both sets
- shared members in both sets
- Except shared members
/.What is the wildcard tab for when filtering on dimensions? - Answer-(Tableau Desktop
only): Use the Wildcard tab to define a pattern to filter on. For example, when filtering on
email addresses you might want to only include emails from a specific domain. You can
define a wildcard filter that ends with "@gmail.com" to only include Google email
addresses.
/.Are reference lines added to a discrete or continuous axis in a view? - Answer-
continuous
/.3 ways you can sort on a visualization in tableau - Answer-you can sort from the
header, axis, or field label
, /.What is the condition tab for when filtering on dimensions? - Answer-Use the Condition
tab in the Filter dialog box to define rules to filter by. For example, in a view showing the
average Unit Price for a collection of products, you may want to only show the Products
that have an average unit price that is greater than or equal to $25. You can use the
built-in controls to write a condition or you can write a custom formula.
/.What is the order of operations of Filters in Tableau? - Answer-1. Extract filters
2. Data source filters
3. Context filters
4. Filters on dimensions (whether on the Filters shelf or in filter cards in the view)
5. Filters on measures (whether on the Filters shelf or in filter cards in the view)
/.How do you add members to an existing group? - Answer--In the Data pane, right-click
the group field, and then click Edit Group.
- In the Edit Group dialog box, select one or more members and drag them into the
group you want.
Click OK.
/.What does the table calculation 'Table (across)' do ? - Answer-Computes across the
length of the table and restarts after every partition
/.What does the table calculation 'Table (across then down)' do ? - Answer-Computes
across the length of the table, and then down the length of the table.
/.What does the table calculation 'Pane ( down)' do ? - Answer-Computes down an
entire pane (NOT the whole of the table)
for example; if years are in rows it will only calculate each year, etc
/.What does the table calculation 'Specific Dimension' do ? - Answer-Computes only
within the dimensions you specify.
/.What does the table calculation 'Pane ( down then across)' do ? - Answer-Computes
down an entire pane and then across the pane
/.What does the table calculation 'Pane ( across then down)' do ? - Answer-Computes
across an entire pane and then down the pane.
/.What does the table calculation 'Table (down then across)' do ? - Answer-Computes
down the length of the table, and then across the length of the table.
/.What does the table calculation 'Table (down)' do ? - Answer-Computes down the
length of the table and restarts after every partition.
/.if you want to rename a dimension what can you do? - Answer-You can not rename
the original dimension; but you can create a duplicate and rename that to achieve this
