I believe this is because you are using Tableau version 2020.2, while the exam is currently on version 2020.1. Version 2020.2 replaced Number of Records with TableName(Count)
Thank you for this exam, exam1, it is helpful and very well put together.
Just a few minor bits of feedback if you are interested.
In the pdf, question 19 doesn’t indicate that its a true false question. Just lists the premise.
And question 8, refers to ship mode in the question (both online and pdf) but the answer values seem to be the order priority field?
Maybe I missed something.
If there is a better way to give such feedback, let me know.
Thank you for publishing this test. It is super helpful.
One thing I would like to add is that for Q9, there was no link for the probation dataset in my case. I was hoping that you could take a look at it.
I provided the password and click on enter.
I see the datasets to download but no link for exam.
I see instructions to click Next to see the exam, but I don’t find Next button.
For question 16, I found two players (with different player ID) who have the same name. So I believe that player ID should have been used to create the bar chart and calculate the sample standard deviation for runs.
To solve the question you must find the proportion of returned orders out of total orders. So the count of returned orders for each priority should be divided by the total order count and the resulting values compared after that to find the correct answer.
Hey! Im just starting to practice for my certified associate test, I was wondering if you could explain to me question #3. I dont really understand what it’s asking for.
The question requires us to find the total sales of the customers who ordered office furniture.
To solve the question you must first find the customers who ordered Office Furnishings (and somehow label them) and after that, you can sum the total sales on all categories of those customers.
I got the correct answer but I used the same fixed calculation as you but used Customer ID and then multiplied by SALES. I then pulled in Cust ID and Sum(Sales) to used Grand Total to find the answer.
Does this method work? If not, why not?
Q9 is worded oddly. I assumed you meant to connect the two sentences together rather than force me to assume you wanted greatest increases in New England states. =)
That was harder than I expected. I don’t feel prepared. Maybe once I go through the solutions.
You can find all the datasets needed in the test in the screen before starting the exam. The probation data can be downloaded using this link – https://learningtableau.com/download/346/
Hello, I have an observation which I discovered on question 9, its related to sorting, after creating the view when I sorted by year in ascending order, in the year 2002 the grand total is 91,361 but when I sorted in descending order in the same year 2002 the grand total is -36,776. Please why is this discrepancy?
Thanks
Loui
This is because you are using a Table calculation that is dependent on the way you are viewing the data. The calculation is being calculated across the Table down, this means that when you have the years sorted in ascending order it the result is relative to the previous row – this means that for 2002 the result will be relative to 2001. When you are sorting it descending the result is still relative to the previous row – here it means that for 2002 the result will be relative to 2003.
Hello, I am new to tableau.
In question 21 after applying set on batting average to get top 3 teams using the average aggregation, why is Nights for example which happens to have the highest batting average score of 27.5, not on the top 3(In) list rather it’s found in out list?
The Knigths team have the highest sum of batting average scores. If you would change the measure type for the Average Batting Score to average you would see that it’s not in top 3. This is a little confusing because the field already has “average” in the name. That field represents the average batting score at a player level, but to calculate it at a team level we need to apply the Average aggregation again.
Thanks for making the practice test available. A couple of comments…
1. Question 3 says “Find the total sales value for all product categories for customers who ordered office furniture.” using the Superstore dataset provided. I looked under Product Category and there are three values, 1) Furniture, 2) Office Supplies, 3) Technology. Then I looked under Product Sub-Category thinking that may be the correct dimension to use and there is no Office Furniture. It turns out from the solution, it should be “Office Furnishings”. I would suggest changing the wording of the question to say “Find the total sales value for all product sub categories for customers who ordered office furnishings.” Or at least some wording that indicates the correct name of the dimension. We’re being tested on how to apply a Fixed LOD, not how to interpret the Superstore dataset.
2. Question 29 (TRUE or FALSE) says “Bins act as containers that summarize data for a specific range of values. Without using a calculated field, Tableau’s bin feature allows you to create variable sized bins.” When I set bin size, I do have the option to create a parameter for the bin size. Isn’t this a way to create a bin size without using a calculated field?
Office furnishings is a subcategory that contains furniture for offices, this is why the questions are mentioning office furniture. The questions can be misleading in the real exam as well.
Regarding question 29 – By default, Tableau creates even-sized bins based on a size you specify. For example, if you create a bin for a field like the age, Tableau will bin the measure to define age groups: 0–5, 6–10, 11–15, and so on. In this example, each bin represents five years. However, say you want to create bins of variable size, for example: under 21, 21–32, over 65, and so on. To do this, you have to create a calculated field.
So the answer is False.
I have a question from no 21. I am new to tableau, when you created a set for the top3 batting average and used average aggregation, I noticed that Knights for example which is 27.5 is not on the top3 (In), please why is this so? and I can understand the question says “average batting average” just trying to figure out the rationale behind this result.
Thanks
On question, Using the Tableau Job Market dashboard, determine which group of three states have the most job:
Hope we won’t have too many US centric questions, I spend 4 minutes searching the State Code – State name and ultimately did a typo mistake !
You can group the states directly on the map where you have their full names. You don’t need to create a group based on a field like state code or search the states in the list.
I have a question about q8. why we have to use left join instead of the inner join, cuz the question is only ask for the returns order not asking for the non-returned orders?
I use the inner join and the answer is same as using left join as the solution suggested.
could you please help to answer?
My guess is that you are not using joins in Tableau, but Relationships. If not, I am not sure how did you get the same answer using an inner join between the Orders table and the Returns table. An inner join would have removed all the orders from the Orders table that are were’nt returned, so your result would always be 100% since the number of returned orders would be equal to the number of orders left in our Orders table.
I did this practice exam and it’s beyound doubt that I am not ready yet. Question 9 in particular bugs me. When i opened the dataset on my Tableau (version 2021.2.0), the field headers were labelled ” F1, F2,F3……” with majority of them being measures. Please is this how that dataset is supposed to look like?
Thank you for creating these exams. They are super helpful! When using a Mac the “next” and “submit” buttons are very far down the page and results in significant scrolling before being able to proceed after each question. I don’t have this issue using a PC. Just an FYI Thanks again!
Ques 3= is asking about Total Sales for “Office Furniture” in all Product Categories –> Ans for this que. is 2,258,326 . In solution is looking for Product sub-categories with “Office Furnishing” and based on that ans. 3,864,069.
Either question need to correct OR solution need to correct.
The question is about finding the total sales from all the customers that have at least one order that contained a product from Office Furnishing sub-category. So, first we must find what customers have ordered at least one Office Furnishings product and after that sum the total values of all orders made by those customers.
I’ve checked the solution and is correct.
for question 10 all i have is measure values I do not have anything regarding number of records
I believe this is because you are using Tableau version 2020.2, while the exam is currently on version 2020.1. Version 2020.2 replaced Number of Records with TableName(Count)
Hi Lukas
Thank you for this exam, exam1, it is helpful and very well put together.
Just a few minor bits of feedback if you are interested.
In the pdf, question 19 doesn’t indicate that its a true false question. Just lists the premise.
And question 8, refers to ship mode in the question (both online and pdf) but the answer values seem to be the order priority field?
Maybe I missed something.
If there is a better way to give such feedback, let me know.
Thanks!
Dave
Thank you for the feedback Dave. I’ve made corrections based on your comment.
Hello Lukas,
Thank you for publishing this test. It is super helpful.
One thing I would like to add is that for Q9, there was no link for the probation dataset in my case. I was hoping that you could take a look at it.
Thanks..
Hi
You can find the dataset on the first page of the exam. https://learningtableau.com/quiz/tableau-10-practice-exam/
The dataset is called probation.
Thanks,
Iris
Hi Lukas,
I just realized I got confused between the dataset names. I am no longer confused about Q9.
What is the Probation Data in question 9?
Hi
You can find the dataset on the first page of the exam. https://learningtableau.com/quiz/tableau-10-practice-exam/
The dataset is called probation.
Thanks,
Iris
I don’t see the Link for exam.
I provided the password and click on enter.
I see the datasets to download but no link for exam.
I see instructions to click Next to see the exam, but I don’t find Next button.
Can you please help me to get to the exam link.
Hi
After downloading the dataset, scroll down to see the next button.
Thanks,
Iris
Hi
After downloading the dataset, please scroll further down and you will see the NEXT button on your right side.
Thanks,
Iris
Hi,
For question 16, I found two players (with different player ID) who have the same name. So I believe that player ID should have been used to create the bar chart and calculate the sample standard deviation for runs.
Hello Lyndon,
The questions explicitly mention creating a bar chart by player name, so using the player ID in finding the answer is not correct.
Thank you,
Narcis
Issue with Probation data, seems to have several Dimensions and Measures as Fxx which does not seem to associate with any of the related questions.
Hi Benjamin,
Try using the Data Interpreter to bring the data in a more usable format.
Thank you,
Narcis
Hi,
In question 8,
Most of the returned order has “null” values with a count of 1573.
And “not specified” count 5.
And so I’m little confused should I go for ‘Unspecified’ or “High” as ‘high’ is the second in ranking with a count of 8
Hi Keshav,
To solve the question you must find the proportion of returned orders out of total orders. So the count of returned orders for each priority should be divided by the total order count and the resulting values compared after that to find the correct answer.
Hope this helps,
Narcis
Hey! Im just starting to practice for my certified associate test, I was wondering if you could explain to me question #3. I dont really understand what it’s asking for.
Thanks
Hi Diana,
The question requires us to find the total sales of the customers who ordered office furniture.
To solve the question you must first find the customers who ordered Office Furnishings (and somehow label them) and after that, you can sum the total sales on all categories of those customers.
Hope this helps,
Narcis
Hi,
I got the correct answer but I used the same fixed calculation as you but used Customer ID and then multiplied by SALES. I then pulled in Cust ID and Sum(Sales) to used Grand Total to find the answer.
Does this method work? If not, why not?
Thanks,
Fiona
Hi Fiona,
Using Customer ID works very well (actually it is better to use the ID than the Name since you are sure that the customer ID is unique).
Thanks,
Narcis
Q9 is worded oddly. I assumed you meant to connect the two sentences together rather than force me to assume you wanted greatest increases in New England states. =)
That was harder than I expected. I don’t feel prepared. Maybe once I go through the solutions.
what is probation data in q9?
Hi Antonella,
You can find all the datasets needed in the test in the screen before starting the exam. The probation data can be downloaded using this link – https://learningtableau.com/download/346/
Hope this helps,
Narcis
Hello, I’ve submitted the answers but there’s no marks or solutions link provided.
This is what I see when I submit. Can you share a screenshot of what the result page looks like for you?
Hello, it works now. Thanks!
Hello there,
Does anybody know how to access practice exam 2 and 3? I have done exam 1, but can’t find the rest of them. Thank you very much!
Maggie
check your email.
Hello, I have an observation which I discovered on question 9, its related to sorting, after creating the view when I sorted by year in ascending order, in the year 2002 the grand total is 91,361 but when I sorted in descending order in the same year 2002 the grand total is -36,776. Please why is this discrepancy?
Thanks
Loui
Hello,
This is because you are using a Table calculation that is dependent on the way you are viewing the data. The calculation is being calculated across the Table down, this means that when you have the years sorted in ascending order it the result is relative to the previous row – this means that for 2002 the result will be relative to 2001. When you are sorting it descending the result is still relative to the previous row – here it means that for 2002 the result will be relative to 2003.
Hope this makes it clear.
Narcis
Yes, it’s clear now.
Thanks
Yes, it’s clear now I figured it out.
Thanks
Hello, I am new to tableau.
In question 21 after applying set on batting average to get top 3 teams using the average aggregation, why is Nights for example which happens to have the highest batting average score of 27.5, not on the top 3(In) list rather it’s found in out list?
Hi Loui,
The Knigths team have the highest sum of batting average scores. If you would change the measure type for the Average Batting Score to average you would see that it’s not in top 3. This is a little confusing because the field already has “average” in the name. That field represents the average batting score at a player level, but to calculate it at a team level we need to apply the Average aggregation again.
I hope this makes it clear.
Thanks,
Narcis
Got it! Narcis
Thanks
Loui
Thanks for making the practice test available. A couple of comments…
1. Question 3 says “Find the total sales value for all product categories for customers who ordered office furniture.” using the Superstore dataset provided. I looked under Product Category and there are three values, 1) Furniture, 2) Office Supplies, 3) Technology. Then I looked under Product Sub-Category thinking that may be the correct dimension to use and there is no Office Furniture. It turns out from the solution, it should be “Office Furnishings”. I would suggest changing the wording of the question to say “Find the total sales value for all product sub categories for customers who ordered office furnishings.” Or at least some wording that indicates the correct name of the dimension. We’re being tested on how to apply a Fixed LOD, not how to interpret the Superstore dataset.
2. Question 29 (TRUE or FALSE) says “Bins act as containers that summarize data for a specific range of values. Without using a calculated field, Tableau’s bin feature allows you to create variable sized bins.” When I set bin size, I do have the option to create a parameter for the bin size. Isn’t this a way to create a bin size without using a calculated field?
Hi Stuart,
Office furnishings is a subcategory that contains furniture for offices, this is why the questions are mentioning office furniture. The questions can be misleading in the real exam as well.
Regarding question 29 – By default, Tableau creates even-sized bins based on a size you specify. For example, if you create a bin for a field like the age, Tableau will bin the measure to define age groups: 0–5, 6–10, 11–15, and so on. In this example, each bin represents five years. However, say you want to create bins of variable size, for example: under 21, 21–32, over 65, and so on. To do this, you have to create a calculated field.
So the answer is False.
Hope this makes it clear,
Narcis
I have a question from no 21. I am new to tableau, when you created a set for the top3 batting average and used average aggregation, I noticed that Knights for example which is 27.5 is not on the top3 (In), please why is this so? and I can understand the question says “average batting average” just trying to figure out the rationale behind this result.
Thanks
On question, Using the Tableau Job Market dashboard, determine which group of three states have the most job:
Hope we won’t have too many US centric questions, I spend 4 minutes searching the State Code – State name and ultimately did a typo mistake !
Hi Philippe,
You can group the states directly on the map where you have their full names. You don’t need to create a group based on a field like state code or search the states in the list.
Thanks,
Narcis
Hi Hi Lukas,
I have a question about q8. why we have to use left join instead of the inner join, cuz the question is only ask for the returns order not asking for the non-returned orders?
I use the inner join and the answer is same as using left join as the solution suggested.
could you please help to answer?
Thanks,
Chenji
Hi Chenji,
My guess is that you are not using joins in Tableau, but Relationships. If not, I am not sure how did you get the same answer using an inner join between the Orders table and the Returns table. An inner join would have removed all the orders from the Orders table that are were’nt returned, so your result would always be 100% since the number of returned orders would be equal to the number of orders left in our Orders table.
Thanks,
Narcis
Good day,
I did this practice exam and it’s beyound doubt that I am not ready yet. Question 9 in particular bugs me. When i opened the dataset on my Tableau (version 2021.2.0), the field headers were labelled ” F1, F2,F3……” with majority of them being measures. Please is this how that dataset is supposed to look like?
Hi Jimi,
You should click the Data Interpreter option, Tableau will clean the dataset for you.
Hope this helps,
Narcis
Thank you for creating these exams. They are super helpful! When using a Mac the “next” and “submit” buttons are very far down the page and results in significant scrolling before being able to proceed after each question. I don’t have this issue using a PC. Just an FYI Thanks again!
Ques 3= is asking about Total Sales for “Office Furniture” in all Product Categories –> Ans for this que. is 2,258,326 . In solution is looking for Product sub-categories with “Office Furnishing” and based on that ans. 3,864,069.
Either question need to correct OR solution need to correct.
Thank you
Hello,
The question is about finding the total sales from all the customers that have at least one order that contained a product from Office Furnishing sub-category. So, first we must find what customers have ordered at least one Office Furnishings product and after that sum the total values of all orders made by those customers.
I’ve checked the solution and is correct.
Hope this makes it clear.
Thanks,
Narcis
The URL for Probation dataset does not invoke any download for me.
Instead “No file paths defined” appears.
The URL is: https://learningtableau.com/download/346/
Please fix
Hi Martin,
I’ve tried the URL and it works just fine for me. What browser are you using? Did you checked the downloads folder?
Narcis