Tableau Data Analyst Test - 9

Prepare these free Tableau certified data analyst certification test to get ready for getting hired as a data analyst or data scientist

Welcome to your Tableau Data Analyst – Test-08

Name

Phone

Q1. How can you create a dual-axis bar chart in Tableau?

Select 1 option(s):

Use the “Dual-Axis“ option from the “Analysis“ menu

Apply the “Bar Chart“ option from the “Show Me“ menu

Create a calculated field for the second axis

Drag and drop two dimensions onto the Columns shelf

Q2. How can you create a calculated field that calculates the quartiles of a measure in Tableau?

Select 1 option(s):

Utilize the WINDOW_QUARTILE() function

Apply a table calculation for quartiles

Create a calculated field with a quartile formula

Use the QUARTILE() function

Q3. How can you create a calculated field that calculates the percentage difference between two measures in Tableau?

Select 1 option(s):

Create a calculated field with a percentage difference formula

Apply a table calculation for percentage difference

Use the PERCENT_DIFF() function

Utilize the DIFFERENCE() function

Q4. How can you create a calculated field to calculate the percentage of total sales for each region in Tableau?

Select 1 option(s):

Use the PERCENTAGE_OF_TOTAL() function

Apply a table calculation for percentage of total

Create a calculated field with a percentage formula

Utilize the TOTAL() function

Q5. How can you create a calculated field that calculates the difference between two date fields in Tableau?

Select 1 option(s):

Apply a table calculation for date difference

Utilize the TOTAL() function

Use the DATE_DIFF() function

Create a calculated field with a date difference formula

Q6. How can you create a calculated field that calculates the year-over-year growth rate in Tableau?

Select 1 option(s):

Apply a table calculation for year-over-year growth

Create a calculated field with the percentage difference

Utilize the TOTAL() function

Use the YEAR_OVER_YEAR() function

Q7. In Tableau, what is the purpose of the “Data Source Filters“?

Select 1 option(s):

Apply filters to visualizations on a worksheet

Restrict data at the data source level before connecting

Filter data based on user-defined criteria

Create dynamic filters for dashboards

Q8. How can you create a calculated field that calculates the percentage change from the previous row in Tableau?

Select 1 option(s):

Apply a table calculation for percentage change

Use the PERCENT_CHANGE() function

Create a calculated field with a percentage change formula

Utilize the DIFFERENCE() function

Q9. How can you create a calculated field that calculates the moving average of a measure in Tableau?

Select 1 option(s):

Apply the WINDOW_AVG() function

Create a table calculation with a running total

Implement a calculated field with a moving average formula

Utilize the MOVING_AVG() function

Q10. How can you create a calculated field that calculates the percentage of null values in a dataset in Tableau?

Select 1 option(s):

Use the ISNULL() function

Apply a table calculation for percentage of null values

Create a calculated field with a null percentage formula

Utilize the WINDOW_SUM() function

Q11. In Tableau, what is the purpose of the “Table Calculation“ feature?

Select 1 option(s):

Perform calculations at the row or cell level

Merge tables in the Data Source tab

Create calculated fields based on user-defined criteria

Aggregate data in a table format

Q12. What is the purpose of the “Map Layers“ feature in Tableau?

Select 1 option(s):

Add layers to map visualizations for enhanced detail

Create calculated fields for map layers

Customize background colors for map visualizations

Filter data based on map layers

Q13. How can you create a combined set in Tableau?

Select 1 option(s):

Use a blend on common dimensions

Union multiple data sources

Merge tables in the Data Source tab

Combine two or more sets using Set Actions

Q14. What is the purpose of the “Data Highlighter“ feature in Tableau?

Select 1 option(s):

Apply conditional formatting to the entire workbook

Create custom filters for the dashboard

Highlight specific data points on a worksheet

Aggregate data based on user-defined criteria

Q15. In Tableau, what does the “Include All“ option do in a filter?

Select 1 option(s):

Resets the filter to its default state

Includes selected values in the filter

Includes all values in the filter

Excludes all values from the filter

Q16. What is the purpose of the “Clusters“ feature in Tableau?

Select 1 option(s):

Apply conditional formatting to specific data points

Display hierarchical relationships in data

Aggregate data based on user-defined criteria

Group similar data points based on clustering algorithms

Q17. How can you create a calculated field that assigns a custom rank to each data point in Tableau?

Select 1 option(s):

Apply a table calculation for custom ranking

Create a calculated field with a custom rank formula

Use the RANK() function

Utilize the TOTAL() function

Q18. In Tableau, what is the purpose of the “Box Plot“ chart type?

Select 1 option(s):

Aggregate data based on trend analysis

Compare data points across different categories

Highlight specific data points on a scatter plot

Display the distribution of data and identify outliers

Q19. What is the purpose of the “Parameter“ feature in Tableau?

Select 1 option(s):

Allow users to switch between different parameter values

Aggregate data based on user-defined criteria

Dynamically control set membership based on user interaction

Create calculated fields for custom parameters

Q20. How can you create a calculated field that calculates the average of a measure for each category in Tableau?

Select 1 option(s):

Apply a table calculation for average

Utilize the TOTAL() function

Use the AVG() function

Create a calculated field with an average formula

Tableau Data Analyst Test - 9

Q1. How can you create a dual-axis bar chart in Tableau?

Q2. How can you create a calculated field that calculates the quartiles of a measure in Tableau?

Q3. How can you create a calculated field that calculates the percentage difference between two measures in Tableau?

Q4. How can you create a calculated field to calculate the percentage of total sales for each region in Tableau?

Q5. How can you create a calculated field that calculates the difference between two date fields in Tableau?

Q6. How can you create a calculated field that calculates the year-over-year growth rate in Tableau?

Q7. In Tableau, what is the purpose of the “Data Source Filters“?

Q8. How can you create a calculated field that calculates the percentage change from the previous row in Tableau?

Q9. How can you create a calculated field that calculates the moving average of a measure in Tableau?

Q10. How can you create a calculated field that calculates the percentage of null values in a dataset in Tableau?

Q11. In Tableau, what is the purpose of the “Table Calculation“ feature?

Q12. What is the purpose of the “Map Layers“ feature in Tableau?

Q13. How can you create a combined set in Tableau?

Q14. What is the purpose of the “Data Highlighter“ feature in Tableau?

Q15. In Tableau, what does the “Include All“ option do in a filter?

Q16. What is the purpose of the “Clusters“ feature in Tableau?

Q17. How can you create a calculated field that assigns a custom rank to each data point in Tableau?

Q18. In Tableau, what is the purpose of the “Box Plot“ chart type?

Q19. What is the purpose of the “Parameter“ feature in Tableau?

Q20. How can you create a calculated field that calculates the average of a measure for each category in Tableau?

Q21. What is the purpose of the “Exclude“ option in Tableau set filters?

Q22. How can you create a calculated field that calculates the median of a measure for each sub-category in Tableau?

Q23. How can you create a calculated field to calculate the difference between the maximum and minimum values of a measure for each category in Tableau?

Company

Some Useful Links

Our Services

Oh yeah, we're on social media too!