Tableau Data Analyst Test - 7

Welcome to your Tableau Data Analyst – Test-07

Name

Phone

Q1. What is the purpose of the “Data Connection“ tab in Tableau Desktop?

Select 1 option(s):

Manage data sources and connections

Customize dashboard formatting

Design data visualizations

Create calculated fields

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

Select 1 option(s):

Create a calculated field with a custom rank formula

Apply a table calculation for custom ranking

Use the RANK() function

Utilize the TOTAL() function

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

Select 1 option(s):

Filter data based on user-defined criteria

Create dynamic filters for dashboards

Restrict data at the data source level before connecting

Apply filters to visualizations on a worksheet

Q4. How can you create a calculated field to calculate the standard deviation of a measure in Tableau?

Select 1 option(s):

Apply a table calculation for standard deviation

Create a calculated field with a standard deviation formula

Use the STDEV() function

Utilize the WINDOW_STDEV() function

Q5. How can you create a calculated field to calculate the average discount per product category in Tableau?

Select 1 option(s):

Utilize the WINDOW_AVG() function

Use the AVG() function

Apply a table calculation for average discount

Create a calculated field with an average discount formula

Q6. In Tableau, what is the purpose of the “Reference Line“ feature?

Select 1 option(s):

Apply conditional formatting to reference lines

Aggregate data based on reference criteria

Create a calculated field with reference values

Display reference lines at specified values

Q7. In Tableau, what is the purpose of the “Actions“ feature in dashboards?

Select 1 option(s):

Enable or disable user interactions on dashboards

Create calculated fields for custom actions

Dynamically control dashboard elements based on user interaction

Apply conditional formatting to action elements

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

Select 1 option(s):

Dynamically control set membership based on user interaction

Aggregate data based on user-defined criteria

Allow users to switch between different parameter values

Create calculated fields for custom parameters

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

Select 1 option(s):

Utilize the PERCENTAGE_OF_TOTAL() function

Create a calculated field with a percentage formula

Apply a table calculation for percentage of total

Use the TOTAL() function

Q10. What is the purpose of the “Show at Default Position“ option in Tableau maps?

Select 1 option(s):

Customize the color of map labels

Adjust the default position of map labels

Display map labels at their default locations

Enable or disable map labels

Q11. In Tableau, what is the purpose of the “Custom Shapes“ feature?

Select 1 option(s):

Add custom images to data points in a visualization

Apply conditional formatting to shape elements

Customize the shape of data points on a scatter plot

Create calculated fields for custom shapes

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

Utilize the DIFFERENCE() function

Apply a table calculation for percentage difference

Use the PERCENT_DIFF() function

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

Select 1 option(s):

Utilize the TOTAL() function

Use the DATE_DIFF() function

Create a calculated field with a date difference formula

Apply a table calculation for date difference

Q14. How can you create a calculated field to calculate the running total of a measure in Tableau?

Select 1 option(s):

Use the WINDOW_SUM() function

Utilize the RUNNING_SUM() function

Apply a filter to show running totals

Create a table calculation with a running total formula

Q15. What is the purpose of the “Custom Sort“ option in Tableau?

Select 1 option(s):

Create calculated fields for custom sorting

Customize the appearance of sort elements

Apply conditional formatting to sort elements

Sort data based on user-defined criteria

Q16. How can you create a calculated field to calculate the weighted average profit in Tableau?

Select 1 option(s):

Utilize the AVG() function

Apply a table calculation for weighted average

Create a calculated field with a weighted average formula

Use the WEIGHTED_AVG() function

Q17. How can you create a calculated field that calculates the percentage of total sales for each region in Tableau?

Select 1 option(s):

Create a calculated field with a percentage formula

Use the PERCENTAGE_OF_TOTAL() function

Utilize the TOTAL() function

Apply a table calculation for percentage of total

Q18. In Tableau, what is the purpose of the “Forecast“ feature?

Select 1 option(s):

Predict future data points based on historical trends

Display aggregated data in a time series format

Aggregate data based on forecast criteria

Create a predictive model using machine learning algorithms

Q19. How can you create a parameter that allows users to switch between different measures in a scatter plot?

Select 1 option(s):

Create a dual-axis scatter plot

Use a calculated field for each measure

Implement a parameter and use it in the scatter plot formula

Apply a filter for each measure

Q20. What is the purpose of the “Distribution“ feature in Tableau?

Select 1 option(s):

Aggregate data based on distribution criteria

Apply conditional formatting to distribution elements

Display the distribution of data points in a histogram

Create calculated fields for distribution analysis

Q21. In Tableau, what is the purpose of the “Show Empty Rows“ option in the Data pane?

Select 1 option(s):

Include or exclude empty rows based on user-defined criteria

Hide rows with null or missing values

Display rows with null or missing values

Adjust the sorting of empty rows

Q22. What is the purpose of the “Filter Actions“ feature in Tableau dashboards?

Select 1 option(s):

Dynamically control filter criteria based on user interaction

Create calculated fields for custom filters

Apply filters to visualizations on a worksheet

Enable or disable filter interactions on dashboards

Q23. How can you create a calculated field that calculates the compound growth rate in Tableau?

Select 1 option(s):

Utilize the ANNUALIZE() function

Create a calculated field with a compound growth formula

Apply a table calculation for compound growth rate

Use the CAGR() function

Q24. In Tableau, what is the purpose of the “URL Action“ feature?

Select 1 option(s):

Embed JavaScript code in worksheet elements

Create hyperlinks to external web pages within a worksheet

Filter data based on URL parameters

Share worksheets through URL links

Q25. How can you create a parameter that allows users to switch between different dimensions in Tableau?

Select 1 option(s):

Create a dual-axis chart with synchronized dimensions

Implement a parameter and use it in the dimension formula

Use a calculated field for each dimension

Apply a filter for each dimension

Q26. How can you create a calculated field to calculate the percentage of change from the first data point for each category in Tableau?

Select 1 option(s):

Apply a table calculation for percentage of change

Use the FIRST() function

Create a calculated field with a percentage change formula

Utilize the DIFFERENCE() function

Q27. How can you create a calculated field to calculate the average profit margin for each product category in Tableau?

Select 1 option(s):

Utilize the WINDOW_AVG() function

Create a calculated field with an average profit margin formula

Apply a table calculation for average profit margin

Use the AVG() function

Q28. In Tableau, what is the purpose of the “Show Field Labels“ option in the “Analysis“ menu?

Select 1 option(s):

Display field labels on the worksheet

Aggregate data based on field label criteria

Apply conditional formatting to field labels

Customize the appearance of field labels

Q29. How can you create a calculated field to calculate the correlation coefficient between two measures in Tableau?

Select 1 option(s):

Utilize the WINDOW_CORR() function

Create a calculated field with a correlation formula

Apply a table calculation for correlation coefficient

Use the CORR() function

Q30. In Tableau, what is the purpose of the “Data Interpreter“?

Select 1 option(s):

Connect to external data sources

Identify and fix issues with the imported data

Aggregate data based on user-defined criteria

Perform complex data transformations

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

Aggregate data based on user-defined criteria

Highlight specific data points on a worksheet

Q32. What is the purpose of the “Highlight“ feature in Tableau dashboards?

Select 1 option(s):

Aggregate data based on highlighted criteria

Adjust the background color of dashboards

Emphasize specific data points in a visualization

Create dynamic filters for dashboards

Q33. In Tableau, what is the purpose of the “Actions“ feature in dashboards?

Select 1 option(s):

Enable or disable user interactions on dashboards

Dynamically control dashboard elements based on user interaction

Create calculated fields for custom actions

Apply conditional formatting to action elements

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

Select 1 option(s):

Apply a table calculation for median

Use the MEDIAN() function

Utilize the WINDOW_MEDIAN() function

Create a calculated field with a median formula

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

Select 1 option(s):

Aggregate data based on user-defined criteria

Apply conditional formatting to specific data points

Group similar data points based on clustering algorithms

Display hierarchical relationships in data

Q36. In Tableau, what is the purpose of the “Show Field Labels“ option in the “Analysis“ menu?

Select 1 option(s):

Aggregate data based on field label criteria

Apply conditional formatting to field labels

Customize the appearance of field labels

Display field labels on the worksheet

Q37. How can you create a calculated field to calculate the average profit margin for each product category in Tableau?

Select 1 option(s):

Use the AVG() function

Utilize the WINDOW_AVG() function

Create a calculated field with an average profit margin formula

Apply a table calculation for average profit margin

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

Select 1 option(s):

Compare data points across different categories

Display the distribution of data and identify outliers

Aggregate data based on trend analysis

Highlight specific data points on a scatter plot

Q39. How can you create a calculated field to calculate the running total of a measure in Tableau?

Select 1 option(s):

Utilize the RUNNING_SUM() function

Create a table calculation with a running total formula

Use the WINDOW_SUM() function

Apply a filter to show running totals

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

Select 1 option(s):

Implement a calculated field with a moving average formula

Utilize the MOVING_AVG() function

Apply the WINDOW_AVG() function

Create a table calculation with a running total

Q41. How can you create a calculated field to calculate the percentage of change from the first data point for each category in Tableau?

Select 1 option(s):

Use the FIRST() function

Utilize the DIFFERENCE() function

Create a calculated field with a percentage change formula

Apply a table calculation for percentage of change

Q42. In Tableau, what is the purpose of the “Data Interpreter“?

Select 1 option(s):

Aggregate data based on user-defined criteria

Identify and fix issues with the imported data

Connect to external data sources

Perform complex data transformations

Q44. What is the purpose of the “Data Connection“ tab in Tableau Desktop?

Select 1 option(s):

Manage data sources and connections

Design data visualizations

Create calculated fields

Customize dashboard formatting

Q44. In Tableau, what is the purpose of the “Show Empty Rows“ option in the Data pane?

Select 1 option(s):

Display rows with null or missing values

Include or exclude empty rows based on user-defined criteria

Adjust the sorting of empty rows

Hide rows with null or missing values

Q45. How can you create a calculated field to calculate the year-over-year growth rate in Tableau?

Select 1 option(s):

Create a calculated field with the percentage difference

Use the YEAR_OVER_YEAR() function

Apply a table calculation for year-over-year growth

Utilize the TOTAL() function

Q46. How can you create a calculated field that calculates the percentage of total sales for each region in Tableau?

Select 1 option(s):

Utilize the TOTAL() function

Apply a table calculation for percentage of total

Use the PERCENTAGE_OF_TOTAL() function

Create a calculated field with a percentage formula

Q47. How can you create a parameter that allows users to switch between different measures in a scatter plot?

Select 1 option(s):

Create a dual-axis scatter plot

Use a calculated field for each measure

Apply a filter for each measure

Implement a parameter and use it in the scatter plot formula

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

Create a calculated field with a percentage formula

Apply a table calculation for percentage of total

Utilize the TOTAL() function

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

Select 1 option(s):

Includes selected values in the filter

Resets the filter to its default state

Filters data based on a specified range

Excludes selected values from the filter

Q50. What is the purpose of the “Filter Actions“ feature in Tableau dashboards?

Select 1 option(s):

Dynamically control filter criteria based on user interaction

Apply filters to visualizations on a worksheet

Create calculated fields for custom filters

Enable or disable filter interactions on dashboards

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

Select 1 option(s):

Use a blend on common dimensions

Union multiple data sources

Combine two or more sets using Set Actions

Merge tables in the Data Source tab

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

Select 1 option(s):

Includes all values in the filter

Includes selected values in the filter

Resets the filter to its default state

Excludes all values from the filter

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

Select 1 option(s):

Create a calculated field for the second axis

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

Drag and drop two dimensions onto the Columns shelf

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

Q54. What is the purpose of the “Set Controls“ feature in Tableau?

Select 1 option(s):

Create calculated fields for custom sets

Dynamically control set membership based on user interaction

Filter data based on set criteria

Adjust the appearance of set elements on a worksheet

Q55. How can you create a calculated field that calculates the percentage of total profit for each sub-category in Tableau?

Select 1 option(s):

Use the PERCENTAGE_OF_TOTAL() function

Create a calculated field with a percentage formula

Apply a table calculation for percentage of total

Utilize the TOTAL() function

Q56. In Tableau, what is the purpose of the “Aggregated Measures“ option in the “Analysis“ menu?

Select 1 option(s):

Adjust the appearance of aggregated measures in visualizations

Aggregate measures based on user-defined criteria

Filter data based on aggregated measure values

Create calculated fields for aggregated measures

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

Select 1 option(s):

Add layers to map visualizations for enhanced detail

Customize background colors for map visualizations

Create calculated fields for map layers

Filter data based on map layers

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

Select 1 option(s):

Aggregate data in a table format

Merge tables in the Data Source tab

Perform calculations at the row or cell level

Create calculated fields based on user-defined criteria

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

Create a calculated field with a percentage change formula

Utilize the DIFFERENCE() function

Use the PERCENT_CHANGE() function

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

Select 1 option(s):

Utilize the WINDOW_SUM() function

Apply a table calculation for percentage of null values

Use the ISNULL() function

Create a calculated field with a null percentage formula