Which Sub-Category had the least Profit in the Office Supplies category?
Answer(s): A
To reach the correct answer, follow the steps below:1) Drag Category, and sub-category to the row shelf. Drag Profit to the Column shelf2) Click the Sort-ascending icon as shown above, to sort the profits from least to greatest as shown:Click the 'Show mark labels icon'As we can see, Fasteners has the least Profit in the Office Supplies Category, and hence is our correct answer!
Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?
Answer(s): C
As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,0001) Right click on customer name --> Create --> Set2) Let's Name the Set - Customer>30k ( you can name it anything you want :) ) Select USE ALL, and then move to the CONDITION TAB:3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000 , and click OK4) You should now have a new Set in the Data Pane as follows:5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.6) Click on the Show Mark Labels, and Sort ascending icons as shown:7) Voila! We have our answer:c
Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through 2014, respectively?
Answer(s): D
To reach the correct answer, follow these steps:1) Drag Order Date (Discrete Year) to the Column shelf, and Region to the Row Shelf as shown:2) Drag Profit to Text in the Marks Shelf as shown:3) Click on Analysis as shown -> Totals -> SELECT ROW GRAND TOTALS The following will be the final view:You could also Filter by Region to only Focus on Canada, but that's your choice:THEREFORE,2012 = 4,8882011 -> 2014 = 17,817
Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?
Since we need to focus on 1 country -> Japan, let's filter on it first as follows:1) Drag Country to the filter shelf, and choose only Japan. Click OK.2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let's do that:Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.The following is our visualisation:Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME. Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward :)
Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?
VERY IMPORTANT QUESTION FOR THE EXAM, PAY ATTENTION1) To find the number of days between order date and shipping date, we will make use of a calculated field:In the data pane, click on the dropdown arrow, and choose create calculated field.Let's name this calculated field "ShippingDelay" (you can name it anything you want :) )2) Use the DATEDIFF() function, and pass it the arguments as follows:'day' depicts that we want to calculate the number of DAYS between the two dates. The first argument is 'start_date' which is the ORDER_DATE (day the order was placed), the second argument is 'end_date', which is the SHIP_DATE (date the order was shipped). So by subtracting as follows:SHIP_DATE - ORDER_DATE, we can find the delay in shipping.Click OK.3) You should now have a new measure as follows:4) Phew! The hard part is done! Now let's filter by Market to include only LATAM:5) Drag Country to the view, and the new calculated field 'ShippingDelay' to SIZE on the Marks Shelf as follows:*You can also click on Show Text Labels to be sure that you're choosing the Largest value*Clearly, Mexico has the highest Shipping Delay!
Share your comments for Tableau Desktop-Specialist exam with other users:
please upload it
does anybody know if are these real exam questions?
are these questions similar to actual questions in the exam? because they seem to be too easy
i have a lot of experience but what comes in the exam is totally different from the practical day to day tasks. so i thought i would rather rely on these brain dumps rather failing the exam.
good questions
valied exam dumps. they were very helpful and i got a pretty good score. i am very grateful for this service and exam questions
will it help?
very useful to verify knowledge before exam
good stuffs
question 17 : responses arent b and c ?
just passed the exam on my first try using these dumps.
very helpful
these questions look good.
this is very helpful content
please provide the dumps
it is amazing
quesion 178 about "a banking system that predicts whether a loan will be repaid is an example of the" the answer is classification. not regresion, you should fix it.
please upload apache spark dumps
q14 is b&c to reduce you will switch off mail for every single alert and you will switch on daily digest to get a mail once per day, you might even skip the empty digest mail but i see this as a part of the daily digest adjustment
i think it is good question
good for students who wish to give certification.
is there a google drive link to the images? the links in questions are not working.
very promising, looks great, so much wow!
i scored 87% on the az-204 exam. thanks! i always trust
good need more
sample questions seems good
huawei is ok
good one nice
please continue
this exam dumps just did the job. i donot want to ruffle your feathers but your exam dumps and mock test engine is amazing.
nice questions
the explanation are really helpful
just passed my exam yesterday on my first attempt. these dumps were extremely helpful in passing first time. the questions were very, very similar to these questions!
cosmos db is paas not saas