Home Others Tableau Certification Questions – Data Connections (Part 2)

Tableau Certification Questions – Data Connections (Part 2)

786
3
Data Connections

Data Connections Part-2 in Series of Tableau Certification Questions for Tableau Desktop Certification exams. The purpose of this Data Connections  part-2 is to explore Tableau Data Connections sample questions targeting the Tableau Desktop Specialist or Certified Associate exam. We have provided a complete step by step solution for each 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 Practice Tests:

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

Tableau Certification Questions List:

Let’s move further to Tableau Certification Questions related to Tableau Data Connections.


Question 1:

Using Products 2016 and Sales 2016 files provided as data-sources, Identify the product Name whose sale is between 3000 to 4000 in October 2012.

Sample Data: Products 2016 | Sales 2016

Choose the correct option:

  • A) Sauder Classic Bookcase, Metal
  • B) Dania Library with Doors, Metal
  • C) Sauder Library with Doors, Metal
  • D) Sauder College with Doors, Metal

Correct Answer: A

Checkout Solution:

1. Create data-source for Sales 2016 excel file.

2. Click on Add Link to make cross join with Products File.

3. Select the More Option.

4. Select the Products 2016. csv file. It will create the connection of Both Products and Sales files as follows:

5. On the New sheet, Put Sum of Sales on Columns and Product Name on Rows shelf.

Put Sales Measure on Filters and give a range from 3000 to 4000 and Put Order Date on Filters and select the Month October 2012.

6. This shows the Product Name ‘Sauder Classic Bookcase, Metal’ from the given option.


Data Visualization with TableauFundamentals 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 TableauData Visualization and Communication with Tableau

  • Duke University via Coursera
  • 25 hours of effort required
  • 175,244+ already enrolled!
  • ★★★★★ (2,852 Ratings)
Tableau 2020 A-ZTableau 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 2:

Using Products 2016 and Sales 2016 files provided as data-sources, Identify which product category shows the maximum growth in Sales in the year 2015.

Choose the correct option:

  • A) Technology
  • B) Furniture
  • C) Office Supplies
  • D) Phones

Correct Answer: C

Check out the Solution:

1. Create a Cross Join for both data files.

2. Put Order Date on Columns and Category on Rows Shelf.

3. Now Put Sales on Text on Marks Card.

4. Select the Sales in Marks Card and right-click to select the Percentage difference table calculation.

5. It will show year wise percentage difference for every category. Clearly shown that in the year 2015, Office Supplies had the highest percentage increase.

 

Question 3:

Answer this question using Sample-SuperStore Excel Sheet. Identify the region and the product which has the highest value of returns.

Sample Data: Super Store Data

Choose the correct option:

  • A) East, Office Supplies
  • B) South, Office Supplies
  • C) West, Office Supplies
  • D) South, Furniture

Correct Answer: D

Check out the solution:

1. Create Inner Join of Orders and Returns Sheet.

2. Put Product Category on Columns and Region on Rows.

3. Now Put Sales on Columns along with the Product Category as shown below. From this view, It is clear that the South Region has maximum Returns for the Furniture category.

 


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 in detail by Tableau Certified Professional.

Stay in touch for the next part in this series for Tableau Certification questions related to Simplifying and Organizing Data.

Related Articles:

3 COMMENTS

  1. Thank you, I have checked, I could be wrong but there is no one matrix/field is taken from return table.

    Why I am saying it is wrong is that. my take on this question is – if I drop region and countd (order ID(returns)) to row will return me order, then I will put sum of sales to the Text field. Then subtotal, it shows that, Central have 98,201.

Comments are closed.