TDA-C01: Tableau Certified Data Analyst
Tableau
Exam Number: TDA-C01
Exam Name: Tableau Certified Data Analyst
Length of test: 120 mins
Exam Format: Multiple-choice questions.
Exam Language: English
Number of questions in the actual exam: 40-46 questions
Passing Score: 750 out of 1000
This study guide should help you understand what to expect on TDA-C01 exam and includes a summary of the topics the exam might cover and links to additional resources. The information and materials in this document should help you focus your studies as you prepare for the exam.
Related questions
You have the following dataset.
When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.
What should you do?
Explanation:
To make Sales appear automatically as shown in the second table, you should change the default number format of the Sales field. The default number format is how Tableau displays a field when you drag it to a worksheet. You can change the default number format by right-clicking on the field and selecting Default Properties > Number Format from the menu. This will open a dialog box where you can choose a category, such as Currency or Percentage, and customize the options, such as decimal places or prefixes.
In this case, you want to change the default number format of Sales to Currency with zero decimal places and a custom prefix of ''S''. This will make Sales appear as ''S'' followed by the rounded value in thousands.
The other options are not correct for this scenario. Changing the data type of Sales to String will not affect how it appears on a worksheet. Creating a calculated field that uses a formula will not change the default number format of Sales, but create a new field that you have to drag to a worksheet. Converting Sales to Attribute will return only one value for each partition of data, which will not show any variation over time.
Reference: https://help.tableau.com/current/pro/desktop/en-us/formatting.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_change_default.htm
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the Top 10 NOC based on the number of medals won.
Explanation:
To filter the table to show the Top 10 NOC based on the number of medals won, you need to do the following steps:
Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the Disciplines worksheet.
Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the NOC, discipline, and medals for each country.
Drag Medals from the Measures pane to the Filters shelf. This will open a dialog box that allows you to filter by different criteria.
Select Top from the dialog box. This will show you options to filter by the top or bottom values of a field.
Enter 10 in the text box next to By field. This will filter by the top 10 values of Medals.
Select NOC from the drop-down list next to By field. This will filter by the top 10 values of NOC based on Medals.
Click OK to apply the filter. You will see that the table now shows only 10 rows, one for each NOC with the highest number of medals.
You have the following dashboard that contains two sheets.
You want to minimize the whitespace between the sheets.
What should you configure?
Explanation:
To minimize the whitespace between the sheets, you should configure the padding of the sheets and the dashboard. Padding is the amount of space between the edge of a sheet or dashboard and its content. You can adjust the padding by using the Layout tab in the Format pane. You can reduce the padding for each sheet by selecting the sheet and changing the values for the inner and outer padding. You can also reduce the padding for the dashboard by selecting the dashboard and changing the values for the outer padding. Reducing the padding will make the sheets and the dashboard more compact and eliminate unnecessary whitespace.Reference:
Format Dashboards - Tableau
Tableau Certified Data Analyst Study Guide
You are creating an annual report in Microsoft Word.
In Tableau Desktop, you build a chart in a worksheet.
You want to create an image of the chart that you can add to the annual report.
What are two ways to create the image? Choose two.
Explanation:
To create an image of the chart that you can add to the annual report, you can use either the Export option or the Copy option from the Worksheet menu. The Export option will allow you to save the image as a file in a specified location, name, and format. The Copy option will allow you to copy the image to the clipboard and paste it into another application, such as Microsoft Word. Both options will let you choose which elements to include in the image, such as title, caption, legend, etc.Reference:
Export Views from Tableau Desktop to Another Application
Copy and Paste Views from Tableau Desktop to Another Application
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.
Explanation:
To filter the table to show the members of the Top10 set and the Bottom10 set, you need to do the following steps:
Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the Disciplines worksheet.
Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the disciplines, sales, and profit for each salesperson.
Click on the drop-down arrow next to Salesperson on the Filters shelf. This will open a menu that allows you to filter by different criteria.
Select Set from the menu. This will show you the sets that are available for the Salesperson field. You will see Top10 and Bottom10 as two sets that have been created based on the sales ranking.
Check the boxes next to Top10 and Bottom10. This will filter the table to show only the members of these two sets. You can also click on All to deselect all other values.
Click OK to apply the filter. You will see that the table now shows 20 rows, 10 for each set.
You have a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.
The following is a sample of the data.
You want to improve the performance of the views by including only animals of a particular type.
To which filter should you add the Type field on the worksheet?
You have the following dashboard.
From the context menu of Sales over time, select Ignore Actions.
Several Lays later, you decide that you want to filter both Sales over time and Detail table by selecting a data point on the map.
What should you do?
You want to create the following dashboard that will contain two sheets.
What should you do?
From Tableau Desktop you sign in lo a Tableau Server site.
What appears in the list of available data sources when you search for a published data source?
Explanation:
When you sign in to a Tableau Server site from Tableau Desktop and search for a published data source, you will see all the data sources published to the site within the folders to which you have access. You will not see data sources published to other sites or folders that you do not have permission to view. You can also filter your search by project, owner, or tag.
Reference: https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_tableauserver.htm
You plan to create a Tableau subscription for several users.
Which two formats can you use? Choose two.
Question