Tableau Certification Questions – Organizing and Simplifying Data (Part 3)

In Series of Tableau Certification Questions for Tableau Desktop Certification exams, we will discuss about Organizing and Simplifying Data. The purpose of this Tableau Exam Questions part-3 is to explore Organizing and Simplifying Data targeting the Tableau Desktop Specialist or Certified/Qualified Associate exams. We have provided a complete step by step solution for each exam question at the end with the correct answer. Check out our guide to Tableau Desktop Certification.

We are providing the complete Tableau Certification Dumps and Practice Tests to validates Tableau Data Visualization skills.

Tableau Desktop
- Tableau Certification Questions – Dashboard (Part 1)
- Tableau Certification Questions – Data Connections (Part 2)
- Tableau Certification Questions – Organizing and Simplifying Data (Part 3)
- Tableau Certification Questions – Tableau Chart Types and Field (Part 4)
- Tableau Certification Questions – Calculation (Part 5)
- Tableau Certification Questions – Tableau Mapping (Part 6)
- Tableau Certification Questions – Analytics in Tableau (Part 7)
Tableau Server

Tableau Certification Practice Tests:

Tableau Certification Questions List:

Let’s dive into Tableau Certification Questions related to Organizing and Simplifying Data in Tableau.

Question 1:

Using the Orders sheet in Sample-Superstore Excel File, We are interested to find what is the aggregated profit ratio of the Top 10 Customers by profit in the year 2012?

Choose the correct option:

A) 40.64 %
B) 13.11 %
C) 2.6 %
D) 5.39 %

Correct Answer: A

Checkout Solution:

Select the Customer Name field and click on Set Option as shown below

Select the top option as shown below and click ok, it will create a set with the name ‘Top 10 Customers By Profit’

Put Order Date field on the Filters shelf

Select the year 2012

Put this filter to context

Put Set ‘Top 10 Customers By Profit’ on Rows shelf

Create calculated field ‘Profit Ratio’

Put the Profit Ratio field on Text in the Marks card. It shows that For Top 10 Customers Percentage value is 40.64 %.

Question 2:

Create a histogram showing the number of sales using sales Bins of $1,000. Which bin has a Profit Ratio (profit as a percentage of sales) of more than 45% for year 2013?

Use the Sample-Superstore excel sheet to solve this.

Sample Data: Super Store Data

Choose the correct option:

A) 10K
B) 11K
C) 12K
D) 13K

Correct Answer: B

Check out the Solution:

1. Put Sales on the Rows shelf.

2. Click on Show Me.

3. Click on Histogram.

4. It will create the default Sales Bin in the Data Pane.

5. Right Click on Sales Bin in data pane and edit the Bin Size to 1000.

6. Put Order Date on Filters and select the Year 2013.

7. Create calculated field Profit Ratio.

8. Put calculated field ‘Profit Ratio’ on Text on Marks Card and make its format to percentage.

9. Going through the values, it’s clear that Sales Bin 11K has value more than 45 %.

10. Tooltip show the Profit Ratio as 47.64 which is greater than 45 %.

Fundamentals of Visualization with Tableau

University of California via Coursera
11 hours of effort required
111,158+ already enrolled!
★★★★★ (4,671 Ratings)

Data Visualization and Communication with Tableau

Duke University via Coursera
25 hours of effort required
175,244+ already enrolled!
★★★★★ (2,852 Ratings)

Tableau A-Z: Hands on Tableau Training for Data Science

Kirill Eremenko via Udemy
9 hours on demand videos
230,147+ already enrolled!
★★★★★ (60,907 ratings)

Question 3:

In which year aggregate Sales of product ‘3M Organizer Strips’ from ‘Office Supplies’ crossed 440.

Sample Data: Super Store Data

Choose the correct option:

A) 2010
B) 2011
C) 2012
D) 2013

Correct Answer: C

Check out the solution:

1. Put a filter of Product ‘3M Organizer Strips’.

2. Put Order Date on Columns shelf, Product Name and Product Category on rows shelf.

3. Now put Sales on Text on Marks card.

4. Now Right Click on Sales in the Marks Card and select the Running Total Option to show the aggregate sales (running total) for every year.

5. It show the following result and its clear that aggregate sales crossed 440 in year 2012.

Get access to 19 Tableau Training Videos explaining 19 different questions including Organizing and Simplifying data in detail by Tableau Certified Professional.

Stay in touch for the next part in this series for Tableau Certification questions related to Field and Chart Types.

Related Articles: