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

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

Organizing and Simplifying Data

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.

Checkout our detailed Tableau Certification Preparation Training Videos from Tableau Certified Professionals to explore further questions and tips for passing the exam in first attempt.

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

o n s q1 sol

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

o n s q1 sol 2

Put Order Date field on the Filters shelf

o n s q1 sol3

Select the year 2012

o n s q1 sol 4

Put this filter to context

o n s q1 sol 5

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

o n s q1 sol 6

Create calculated field ‘Profit Ratio’

o n s q1 sol 7

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

o n s q1 sol 8

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 %.

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.

Tableau Certification Practice Tests:

Tableau Desktop Specialist Certification Dumps     Tableau Desktop Certified Associate Exam     Tableau Server Certified Associate Practice Tests

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: