Tableau TDA-C01 Exam Dumps

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.

The formula in option B calculates the percent difference in sales relative to the same quarter the previous year. It subtracts the sales of the same quarter from the previous year from the current year's sales, and then divides this by the previous year's sales. This gives a percentage change, which aligns with what is shown in the Calculation field of your dataset. The LOOKUP function returns the value of a specified offset from the current row in the partition. In this case, the offset is -4, which means the value of the same measure four rows above the current row. This corresponds to the same quarter of the previous year, assuming the data is sorted by quarter.Reference:

LOOKUP Function - Tableau

Table Calculations - Tableau

Tableau Certified Data Analyst Study Guide

To combine the two tables that contain data about books in a library and ensure that all the data is retained, you should use a full outer join. A full outer join is a type of join that returns all rows from both tables, regardless of whether there is a match or not. If there is no match, null values are filled in for the missing fields.

To perform a full outer join, you need to do the following steps:

Connect to both tables as your data sources in Tableau. You can use either live or extract connections.

Drag one table to the canvas and drop it on top of another table. This will create a join between them based on a common field.

Click on the join icon between the tables and select Full Outer Join from the drop-down list. This will change the join type to full outer join and show all rows from both tables.

Optionally, you can add or remove join clauses by clicking on Add or Remove buttons next to each clause. You can also change or rename fields by clicking on them.

The other types of joins are not correct for this scenario. An inner join returns only the rows that have a match in both tables, which will exclude any books that are missing from either table. A left join returns all rows from the left table and only the matching rows from the right table, which will exclude any books that are only in the right table. A right join returns all rows from the right table and only the matching rows from the left table, which will exclude any books that are only in the left table. Reference: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm https://help.tableau.com/current/pro/desktop/en-us/join_types.htm

To find the month that had the biggest increase in average sales compared to the previous month in 2019, you need to compare the slopes of the line segments between each pair of months. The steeper the slope, the greater the increase. Based on the line chart, October had the steepest slope, meaning it had the biggest increase in average sales compared to September in 2019. Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_line.htm https://www.mathsisfun.com/algebra/line-equation-slope.html