Tableau TDA-C01 Tableau Certified Data Analyst Exam Exam Practice Test

In Tableau, to replace a sheet on a dashboard, you can simply drag the desired sheet (Sheet2 in this case) from the sheets list onto the dashboard area where the current sheet (Sheet3) resides. This action will replace the existing sheet with the new one. Right-clicking and adding to the dashboard adds an additional sheet rather than replacing, and the context menu options mentioned in the other choices are not the standard methods for replacing sheets within a dashboard.

In Tableau dashboards, floating elements are those that can be freely moved over the dashboard canvas without being snapped into the tiled layout. The floating elements are often indicated by their standalone frames and the ability to overlap with other dashboard items. From the provided image, the state filter and the Rate of Obesity chart can be identified as floating if they can be moved independently of the tiled grid layout that constrains other elements.

The box plot visualization displays the distribution of average profits by region. The distribution of profits is represented by the range of the box (interquartile range) and the whiskers (which often represent the total range excluding outliers). From the image provided, the South region has the smallest visible range within its box and the shortest whiskers, indicating the smallest distribution of average profits among the choices provided.

1) Open Tableau prep

2) Create a new column ...

3) Union the sales ...

4) Join the sales ...

References:

To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box. References:

To show additional information such as the corresponding region when hovering over a bar in Tableau, you can drag the 'Region' field to the 'Tooltip' shelf on the 'Marks' card. This will ensure that when a user hovers over a bar representing a city, the tooltip will dynamically display the region associated with that city.

The correct Level of Detail (LOD) expression to calculate the grand total of sales across all regions would be {SUM(Sales)}. The FIXED expression is not needed here because we are not computing the sum at the level of each region, but rather the total sum across all regions. The FIXED keyword is typically used to aggregate at a certain level regardless of the view.

To ensure that the data is updated every hour, you need to select Extract Refreshes from the data source menu on Tableau Server. This will allow you to add a new extract refresh schedule or edit an existing one. You can specify the frequency and time of the refresh, as well as any custom options or credentials. New will create a new data source, Connected Workbooks will show you which workbooks use this data source, and Connections will show you which tables or files are connected to this data source. References:

To ensure that the data is updated every hour on Tableau Server, you would need to go to the "Extract Refreshes" option. Here, you can schedule the data extracts to refresh at the desired frequency, which in this case would be every hour.

A screenshot of a computer Description automatically generated

To resume a suspended alert, you need to go to the My Content area of Tableau web pages, where you can see all the alerts that you own or subscribe to. You can click on the alert name and then select Resume from the menu. You can also edit or delete the alert from there. References:

In Tableau, the "My Content" area on the web interface is the place where a user can manage their content, including workbooks, data sources, and alerts. If an alert is suspended, the owner of the alert can go to the "My Content" area to resume it.

To combine two sets, they must have at least one dimension in common. In this case, Customers of 2020 and Top N Customers both have Customer Name as a dimension, so they can be combined using set operations such as union, intersection, or difference. Sellers of 2020 and Top N Products have different dimensions (Seller Name and Product Name), so they cannot be combined. References:

In Tableau, sets can be combined if they are created from the same dimension. From the options provided, "Customers of 2020" and "Top N Customers" are likely created from the same dimension (Customers). Therefore, these two sets can be combined to create a new set that includes or excludes members based on the combined criteria. Combining sets like "Top N Products" with "Customers of 2020" would not be feasible unless they are from the same dimension, which is typically not the case.

To add a comment to March 2020 on a line chart, you need to annotate that mark. You can right-click on the mark and select Annotate > Mark from the menu. This will open a dialog box where you can type your comment and format it as you like. You can also drag and drop the annotation to position it on the worksheet. Dragging the growth rate to Text on the Marks card will add a label to every mark on the line chart, enabling captions will show a description of the worksheet at the bottom, and adding a tooltip will show a text box when users hover over a mark. References:

To add a comment to a specific point on a line chart, such as March 2020 in the provided visualization, you would use the 'Annotate' feature. Right-clicking on the data point for March 2020 and selecting 'Annotate' allows you to add a text annotation directly to the chart, which can be used to highlight and comment on that particular data point.

To refresh an extract on Tableau Server, you need to select the workbook, select Refresh Extracts, and then add a new extract refresh. You can specify the frequency and time of the refresh, as well as any custom options. You can have multiple extract refreshes for the same workbook with different schedules. References:

On Tableau Server, you can manage the scheduling of extract refreshes by selecting the specific workbook and configuring additional refresh schedules as needed. This allows for multiple refresh triggers, such as the regular Monday at 10:00 AM schedule, as well as an additional trigger for the last day of the month at 18:00.

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. References:

• Export Views from Tableau Desktop to Another Application
• Copy and Paste Views from Tableau Desktop to Another Application

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. References:

When signed in to Tableau Server from Tableau Desktop, you'll only be able to see the data sources that have been published to the site and are within the folders that you have been granted access to. Tableau's permission and project structure mean that you won't see all data sources from the entire server unless you have permissions to do so.

To organize the tables in the Data pane based on the type of data contained within the tables, you should use folders. Folders are a way to manually group fields, parameters, sets, or tables in the Data pane according to your preference. You can create folders by right-clicking on the fields or tables you want to group and selecting Folders > Create Folder. You can also drag and drop fields or tables into existing folders. You can name the folders according to the type of data they contain, such as sales, customer, product, etc. Folders can help you find and access the fields or tables you need more easily and efficiently. References:

• Organize and Customize Fields in the Data Pane - Tableau
• Tableau Certified Data Analyst Study Guide

To calculate the month to date value of the prior year, you need to filter the order date to be between the first day of the same month of the previous year and the same day of the previous year. You can use the calculated fields [Calc1] and [Calc2] to get these dates. [Calc1] returns the date that is one year before today, and [Calc2] returns the date that is the first day of the month of [Calc1]. By using these fields in the filter condition, you can get the desired result.

References:

• Finding the Month-to-Date Values for the Prior Year
• [DATEADD Function]
• [DATETRUNC Function]

To determine the Rank Score value for Student ID 4220, we look at the visualization provided and apply the table calculation of RANK(AVG([Score])). This function will rank the average scores in ascending order by default, with the lowest score receiving the rank of 1.

Based on the provided visualization, the scores for the students are as follows (from lowest to highest average score):

• Student ID 4183: 39 (Rank 1)
• Student ID 4220: 71 (Rank 6)
• Student ID 4247: 71 (Rank 6, same score as ID 4220 so they share the same rank)
• Student ID 4124: 75.5
• Student ID 4050: 64
• Student ID 4205: 67
• Student ID 4056: 66

Since Student ID 4220 has an average score of 71, which is the third-highest score, it shares the rank with Student ID 4247. However, since Tableau ranks without gaps, the actual rank assigned is 6, considering that there are two students with a rank of 4 (due to the same average score being the second lowest), making the next rank number 6.

Note: The actual ranks for the highest scores are not provided, but they are not needed to determine the rank for Student ID 4220.

The REPLACE function is used to replace all occurrences of a substring within a string with another substring. In this case, it can be used to remove the semicolons from the Name field by replacing them with an empty string. For example, REPLACE (“John;Doe”, “;”, “”) = “JohnDoe”. References: The information is based on the following sources:

• String Functions - Tableau
• Remove special characters and add a semi colon in a word - Tableau

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. References:

To achieve the formatting as shown in the example, where sales figures are displayed with a "K" to represent thousands and rounded to the nearest thousand (e.g., $20K, $44K, etc.), you would need to adjust the default number format of the Sales field in Tableau. By changing the default number format, every instance where the Sales field is used would automatically reflect this new formatting. This is more efficient than creating a calculated field as it preserves the numeric nature of the field, allowing for further numerical operations and aggregations.

The object that you should add to the dashboard to allow users to switch to a different dashboard in the workbook is Navigation.

Navigation objects are used to create links between dashboards or sheets in a workbook. You can add a navigation object to a dashboard by dragging it from the list of objects and dropping it on the dashboard. You can then configure the navigation object to specify the destination dashboard or sheet that you want users to navigate to when they click on it.

You can learn more about navigation objects and how to use them in this article:

There are different ways to prepare the data in Tableau Prep, but one possible answer is:

Answer area:

• Join the tables.
• Aggregate the data by Sales Team.
• Add the following filter to the Employees table: Sale Team - Team Alpha.

 To analyze sales trends over time for every sales team, you need to combine the data from the Orders and Employees tables. You can do this by joining the tables on the Rep ID column, which is a common identifier for both tables. This will create a single table with all the columns from both tables. Next, you need to aggregate the data by Sales Team, which is the level of analysis you want. You can do this by grouping the data by the Sales Team column and applying an aggregation function (such as sum, average, count, etc.) to the other columns that you want to measure (such as Total Amount, Rep Tenure, etc.). This will create a summary table with one row for each sales team and the aggregated values for the other columns. Finally, you need to filter the data to focus on a specific sales team, such as Team Alpha. You can do this by adding a filter to the Employees table and selecting only the rows where Sales Team equals Team Alpha. This will remove the rows for other sales teams and keep only the data for Team Alpha.

References:

• [Tableau Certified Data Analyst Exam Prep Guide], page 9, section “Preparing Data”
• [Tableau Help: Join Your Data]
• [Tableau Help: Aggregate Your Data]
• [Tableau Help: Filter Your Data]

To create a map visualization that shows the concentration of data points in different locations, you need to change the mark type to Density. This will create a heatmap that uses color and size to indicate the density of the data points. You can also adjust the intensity and transparency of the density marks to suit your needs. References: The information is based on the following sources:

• Create Heatmaps that Show Trends or Density in Tableau
• Build a Simple Map - Tableau

To modify the bar chart to show the percentage of sales for each Subcategory within every Category, 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 CategoryPercentage worksheet.
• Click on the CategoryPercentage tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the total sales for each Subcategory across all Categories.
• Right-click on Sales on the Columns shelf and select Add Table Calculation from the menu. This will open a dialog box that allows you to apply a calculation to your measure.
• Select Percent of Total from the Calculation Type drop-down list. This will calculate the percentage of sales for each Subcategory out of the total sales for all Subcategories.
• Select Category from the Compute Using drop-down list. This will calculate the percentage of sales for each Subcategory within every Category, instead of across all Categories. The total percentage for every Category will be 100%.
• Click OK to apply the table calculation. You will see that the bar chart now shows the percentage of sales for each Subcategory within every Category.

References:

To add the Sales by State sheet in a Show/Hide button to the right side of the dashboard, 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 sales dashboard.
• Click on the sales dashboard tab at the bottom of the workbook to open the dashboard. You will see a dashboard that shows various charts and filters related to sales data.
• Drag Sales by State from the Sheets pane to the right side of the dashboard. This will add the sheet as a floating element on the dashboard. You can resize and position it as you like.
• Right-click on Sales by State and select Add Show/Hide Button from the menu. This will add a button that allows you to show or hide the sheet on the dashboard. You can customize the appearance and behavior of the button by clicking on it and using the options on the Marks card.
• Optionally, you can drag a vertical layout container from the Objects pane to the right side of the dashboard and place Sales by State and its button inside it. This will help you organize your dashboard elements and align them neatly.

References:

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.

References:

To modify the chart to show only min and max values of both measures in each region, 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 Line worksheet.
• Click on the Line tab at the bottom of the workbook to open the worksheet. You will see a line chart that shows the sales and profit for each month by region.
• Drag Month from the Columns shelf to Filters shelf. This will open a dialog box that allows you to filter by different criteria.
• Select Range of Dates from the dialog box. This will show you options to filter by a range of dates or values.
• Select Minimum and Maximum from the drop-down list next to Month. This will filter by the minimum and maximum values of Month for each region. You can also enter specific values or use the sliders to adjust the range.
• Click OK to apply the filter. You will see that the line chart now shows only min and max values of both measures in each region.

References:

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.

References:

To replace the existing data source with the Netflix_2019 data source, 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 Movie Durations worksheet.
• Click on the Movie Durations tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the number of movies by duration for the existing data source.
• Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the existing data source.
• Click on the drop-down arrow next to the data source name at the top of the page and select Replace Data Source from the menu. This will open a dialog box that allows you to replace your data source with another one.
• Select Netflix_2019 from the list of available data sources and click OK. This will replace your existing data source with the Netflix_2019 data source and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.

References:

To create a filled map to show the distribution of total Sales by State across the United States, you need to do the following steps:

• Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
• Click on the Map tab at the bottom of the workbook to open the Map worksheet. You will see a blank worksheet with no marks.
• Drag State from the Dimensions pane to Detail on the Marks card. This will create a map that shows each state as a mark. You may need to zoom in or out to see the whole map.
• Drag Sales from the Measures pane to Color on the Marks card. This will create a filled map that shows the distribution of total Sales by State across the United States. The color legend will show you the range of values and colors for Sales.
• Optionally, you can adjust the color scheme, transparency, size, and borders of the marks by clicking on the Color menu on the Marks card. You can also add labels, tooltips, or filters to enhance your map.

References:

To add a distribution band on Profit to show the standard deviation from -1 to 1, 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 SalesVSProfit worksheet.
• Click on the SalesVSProfit tab at the bottom of the workbook to open the worksheet. You will see a scatter plot that shows the relationship between Sales and Profit for each Sub-Category.
• Click on the Analytics tab on the left side of the workbook to open the Analytics pane. You will see a list of analytical objects that you can drag and drop onto your worksheet.
• Drag Distribution Band from the Analytics pane to Profit on the Rows shelf. This will add a distribution band on Profit that shows the average and confidence interval for each Sub-Category.
• Click on the Edit button on the distribution band to open the Edit Distribution Band dialog box. You will see options to customize your distribution band.
• Change the Band From value to -1 and the Band To value to 1. This will change the distribution band to show the standard deviation from -1 to 1, which means one standard deviation below and above the average.
• Click OK to apply the changes. You will see that the distribution band now shows a narrower range of values for Profit.

References:

To create a histogram on the Quantity field by using bin size of 3, you need to do the following steps:

• Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
• Click on the Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks.
• Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram.
• Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on.
• Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a # sign next to it.
• Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin.
• Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram.

References:

To split the Customer Name field into two fields named First Name and Last Name, you need to do the following steps:

• Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
• Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the Superstore data source.
• Right-click on Customer Name in the table and select Split from the menu. This will split the field into two fields based on a separator, which is a space by default. You will see two new fields named Customer Name - Split 1 and Customer Name - Split 2 in the table.
• Right-click on Customer Name - Split 1 and select Rename from the menu. Type First Name as the new name and press Enter. This will rename the field as First Name.
• Right-click on Customer Name - Split 2 and select Rename from the menu. Type Last Name as the new name and press Enter. This will rename the field as Last Name.

References: