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. 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 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 Questions – Server Installation and Configuration (Part 8)
- Tableau Certification Questions – Server Preparation (Part 9)
- Tableau Certification Questions – Server Administration (Part 10)
- Tableau Certification Questions – Server Troubleshooting (Part 11)
- Tableau Certification Questions – Migration and Tableau Upgrade (Part 12)
Tableau Certification 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.
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 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:
Stay in touch for the next part in this series for Tableau Certification questions related to Simplifying and Organizing Data.
Related Articles:
Correct Answer for Last question is A – West, Office Supplies with 27 returns.
Dear Gourav, Please review the detailed step by step solution for this Tableau Certification Question.
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.