Tableau Certified Data Analyst - TDA-C01 FREE EXAM DUMPS QUESTIONS & ANSWERS
You have a data source that contains the following columns.
You want to filter regions based on the highest sales. Users must be able to specify the number of regions shown.
Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area.
Use Answer Area arrows to re-order the options.)
You want to filter regions based on the highest sales. Users must be able to specify the number of regions shown.
Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area.
Use Answer Area arrows to re-order the options.)
Correct Answer:
To filter regions based on the highest sales and allow users to specify the number of regions shown, you should perform these actions in order:
Answer area:
* Create an integer data type parameter named Param1.
* Drag Region to the Filters shelf.
* Configure a Top filter by field. Use Param1 and filter by the sum of Sales.
To create a dynamic filter that lets users choose the number of regions to display, you need to use a parameter and a top filter. A parameter is a user-defined variable that can be used in calculations, filters, and reference lines. A top filter is a type of filter that shows only the top or bottom N values based on a specified field or expression.
In this question, you want to filter regions based on the highest sales. You also want users to be able to specify the number of regions shown. To achieve this, you need to follow these steps:
* First, you need to create an integer data type parameter named Param1. This parameter will allow users to enter a number that will determine how many regions to show. You can create a parameter by right- clicking on the Data pane and selecting Create Parameter. Then, you need to specify the name, data type, current value, and allowable values for the parameter. In this case, you can choose Integer as the data type, 10 as the current value, and All as the allowable values. You also need to show the parameter control by right-clicking on the parameter and selecting Show Parameter Control. This will display a slider or a text box where users can enter or adjust the parameter value.
* Next, you need to drag Region to the Filters shelf. This will open the Filter dialog box, where you can choose how to filter the Region field. You can filter by general, wildcard, condition, or top. In this case, you want to filter by top, so you need to select the Top tab.
* Finally, you need to configure a top filter by field. Use Param1 and filter by the sum of Sales. This will filter the Region field by showing only the top N regions based on the sum of Sales, where N is the value of the parameter Param1. You can configure a top filter by field by selecting By field in the Top tab, then choosing the parameter Param1 from the drop-down list, and selecting the aggregation function Sum and the field Sales from the other drop-down lists. This will create a filter expression that looks like this: Top Param1 by SUM(Sales).
By following these steps, you will create a filter that shows only the regions with the highest sales, and allows users to change the number of regions shown by adjusting the parameter value.
References:
Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Filtering Data" Tableau Help: Parameters Tableau Help: Top Filters
Answer area:
* Create an integer data type parameter named Param1.
* Drag Region to the Filters shelf.
* Configure a Top filter by field. Use Param1 and filter by the sum of Sales.
To create a dynamic filter that lets users choose the number of regions to display, you need to use a parameter and a top filter. A parameter is a user-defined variable that can be used in calculations, filters, and reference lines. A top filter is a type of filter that shows only the top or bottom N values based on a specified field or expression.
In this question, you want to filter regions based on the highest sales. You also want users to be able to specify the number of regions shown. To achieve this, you need to follow these steps:
* First, you need to create an integer data type parameter named Param1. This parameter will allow users to enter a number that will determine how many regions to show. You can create a parameter by right- clicking on the Data pane and selecting Create Parameter. Then, you need to specify the name, data type, current value, and allowable values for the parameter. In this case, you can choose Integer as the data type, 10 as the current value, and All as the allowable values. You also need to show the parameter control by right-clicking on the parameter and selecting Show Parameter Control. This will display a slider or a text box where users can enter or adjust the parameter value.
* Next, you need to drag Region to the Filters shelf. This will open the Filter dialog box, where you can choose how to filter the Region field. You can filter by general, wildcard, condition, or top. In this case, you want to filter by top, so you need to select the Top tab.
* Finally, you need to configure a top filter by field. Use Param1 and filter by the sum of Sales. This will filter the Region field by showing only the top N regions based on the sum of Sales, where N is the value of the parameter Param1. You can configure a top filter by field by selecting By field in the Top tab, then choosing the parameter Param1 from the drop-down list, and selecting the aggregation function Sum and the field Sales from the other drop-down lists. This will create a filter expression that looks like this: Top Param1 by SUM(Sales).
By following these steps, you will create a filter that shows only the regions with the highest sales, and allows users to change the number of regions shown by adjusting the parameter value.
References:
Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Filtering Data" Tableau Help: Parameters Tableau Help: Top Filters
A Data Analyst has the following dataset:
The analyst wants to create a new calculated dimension field named Category that meets the following conditions:
When Subject is Computer Science or Science, the Category must be Sciences.
When Subject is English or Social Studies, the Category must be Humanities.
Which two logical functions achieve this goal? (Choose two.)
The analyst wants to create a new calculated dimension field named Category that meets the following conditions:
When Subject is Computer Science or Science, the Category must be Sciences.
When Subject is English or Social Studies, the Category must be Humanities.
Which two logical functions achieve this goal? (Choose two.)
Correct Answer: A,C
Vote an answer
A Data Analyst has the following view.
The analyst wants to filter the view to show only records that have a movie name starting with the word
"The". The analyst must achieve the goal without writing any formulas.
Which type of filter should the analyst use?
The analyst wants to filter the view to show only records that have a movie name starting with the word
"The". The analyst must achieve the goal without writing any formulas.
Which type of filter should the analyst use?
Correct Answer: C
Vote an answer
A Data Analyst has the following chart that shows the sum of sales made in different cities.
The analyst wants to show the average sale amount for a city when users hover their mouse over any of the bars.
What should the analyst do?
The analyst wants to show the average sale amount for a city when users hover their mouse over any of the bars.
What should the analyst do?
Correct Answer: D
Vote an answer
You have a data set that contains three columns named Sales, Profit, and Quantity.
You need to build the following scatter plot.
You need to build the following scatter plot.
Correct Answer:
Explanation:
To build the scatter plot shown in the image, you need to place the Profit measure on the Rows shelf and the Sales measure on the Columns shelf. This will create a Cartesian chart with Profit as the y-axis and Sales as the x-axis. Then, you need to change the mark type to Circle on the Marks card. This will display the data points as circles that vary in size according to the Quantity measure. You can also add color or shape encoding to the marks to show additional dimensions or measures in the view. References:
* Build a Scatter Plot
* Understanding and Using Scatter Plots
* Scatter plot in Tableau
You have a line chart on a worksheet.
You want to add a comment to March 2020 as shown in the following visualization.
What should you do?
You want to add a comment to March 2020 as shown in the following visualization.
What should you do?
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You have the following dataset.
Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?
Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?
Correct Answer: B
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
A Data Analyst has created a Tableau Prep flow that is ready to be used. The output will be used by a colleague to build a dashboard on Tableau Cloud or Tableau Server.
Where should the analyst output the data to?
Where should the analyst output the data to?
Correct Answer: D
Vote an answer
You receive a tab-delimited data file name sales.tsv.
You need to connect to the file.
Which option should you select in Tableau Desktop?
You need to connect to the file.
Which option should you select in Tableau Desktop?
Correct Answer:
To connect to a tab-delimited data file named sales.tsv, you should select the option To a File > Text file in Tableau Desktop. This option will allow you to browse and select the file from your local or network drive and connect to it as a data source. You can then specify the text file properties, such as the delimiter, the text qualifier, and whether the first row contains column names. You can also join, union, or blend the data with other data sources if needed. References:
* Text File - Tableau
* Tableau Certified Data Analyst Study Guide
* Text File - Tableau
* Tableau Certified Data Analyst Study Guide
A Data Analyst has the following dashboard.
Currently, the map is used as a filter that affects the data on the other sheets of the dashboard.
The analyst needs to configure the dashboard to ensure that selecting a data point on the map only filters the Detail table.
What should the analyst do?
Currently, the map is used as a filter that affects the data on the other sheets of the dashboard.
The analyst needs to configure the dashboard to ensure that selecting a data point on the map only filters the Detail table.
What should the analyst do?
Correct Answer: C
Vote an answer
You have the following dataset.
You need to create the following worksheet.
The table must show either profit or sales based on the selection from the Parameter 1 menu.
Which three actions should you perform in orders
(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)
You need to create the following worksheet.
The table must show either profit or sales based on the selection from the Parameter 1 menu.
Which three actions should you perform in orders
(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)
Correct Answer:
A screenshot of a computer Description automatically generated
You have a table that contains four columns named Order Date, Country, Sales, and Profit.
You need to add a column that shows the day of the week for each row. For example, orders placed on August
31, 2022, will show a day of
Wednesday.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
You need to add a column that shows the day of the week for each row. For example, orders placed on August
31, 2022, will show a day of
Wednesday.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Correct Answer:
Explanation:
To add a column that shows the day of the week for each row, you should complete the formula as follows:
DATENAME
(
'weekday'
, [Order Date])
The DATENAME function in Tableau returns the name of a specified part of a date or datetime value, such as the year, month, or day. It takes two arguments: the date part and the date. In this question, you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each order date. Therefore, you need to use 'weekday' as the date part and [Order Date] as the date. The formula will return a string value that represents the name of the weekday for each order date.
References:
Tableau Help: DATENAME Function
Tableau Help: Date Functions
To add a column that shows the day of the week for each row, you should complete the formula as follows:
DATENAME
(
'weekday'
, [Order Date])
The DATENAME function in Tableau returns the name of a specified part of a date or datetime value, such as the year, month, or day. It takes two arguments: the date part and the date. In this question, you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each order date. Therefore, you need to use 'weekday' as the date part and [Order Date] as the date. The formula will return a string value that represents the name of the weekday for each order date.
References:
Tableau Help: DATENAME Function
Tableau Help: Date Functions