Using the atheletes table:i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1) ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark. (Sheet 2)Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?(Ignore any nulls / unknowns)
Answer(s): A
Pretty common question on the Tableau Desktop Specialist exam.1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:2) Now, for sheet 2 - Drag nationality to the view, and gold to the size mark in the Marks shelf.Note: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:3) Now, let's create a dashboard, and use both these sheets in it:4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:
Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?
Answer(s): C
If you answered this question quickly and correctly, you're well prepared for the exam! Most students stumble while creating a Dual axis chart, so go ahead and give yourself a pat on the back! To create a dual axis chart for the problem mentioned:1) Drag Product Type to the column shelf, and Sales and Profit to the Row shelf:2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.Now the chart looks like this:Now we change the Profit chart type to line:5) Finally, we synchronise the axis as follows: Right click on the axis, and choose 'Synchronise axis'And, our final view and answer is:
Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add ColumnGrand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?
We need to use the concept of Groups for this question. Follow along:1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:We can see the answer already : 23.386% in the view above (even before grouping!)4) Finally, we get the following view and our answer:
Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?
Follow along to reach the correct answer:1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:Click on Date in the Column shelf and convert it to continuous month :2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:3) Finally, click on the Show mark Labels icon:4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference:
Question 30: SkippedUsing the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State. Add a Linear trend line to the view. What is its R-squared value?
Trend lines have become popular questions in recent Tableau examinations. Follow along:1) First drag Sales to the Rows shelf and Profit to the Columns shelf:cYou will only see a single mark since the view is aggregated.2) Now, break down this view by state. Drag State into Detail on the Marks shelf ( or directly to the view):3) Finally, move to the Analytics pane, and drag Trend line to the view. When you drag it, select the Linear option!:4) The following is our view. Hover over the trend line to see the R-squared value:
Post your Comments and Discuss Tableau TDS-C01 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the TDS-C01 content, but please register or login to continue.