In this series of Tableau Certification Questions for Tableau Desktop Certification exams, we will discuss Field and Tableau Chart Types. The purpose of this Tableau Exam Questions part-4 is to explore Tableau Chart Types and Field 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. 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 dive into Tableau Certification Questions related to Tableau Chart types and field in Tableau.
Question 1:
Use the Tableau ‘Sample? Superstore’ excel sheet to solve this.
Create a scatter plot with Sales and Profit for the year 2013. Identify which category and region is facing losses. Select the correct option.
Choose the correct option:
- A) South , Office Supplies
- B) West , Furniture
- C) Central, Furniture
- D) West, Office Supplies
Correct Answer: B
Checkout Solution:
1. Put Order Date on Filter and select 2013.
2. Put Product Category and Region on Details in Marks Card.
3. Following view will be shown:
It’s clear from the graph that Product Category ‘Furniture’ in Region ‘West’ is facing losses.
Question 2:
Use the Tableau ‘Sample? Superstore’ excel sheet to solve this.
Create a Target Profit Margin field which should be 30 percent of sales and create a Bullet chart of Profit and newly created field ‘Target Profit Margin’ and Identify for which of the Product subcategories Profit have crossed the Target Profit Margin for East Region?
Select 2 Product Sub Categories.
Sample Data: Super Store Data
Choose the correct option:
- A) Envelops
- B) Tables
- C) Binders and Binder Accessories
- D) Computer Peripherals
Correct Answer: C
Check out the Solution:
1. Put Product Sub Category on Rows and sum of Profit on Columns.
2. Create calculated field with following formula to get 30 percent of sales.
3. Put Region of Filters and select East.
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)
4. Put newly created calculated field ‘Target Profit Margin’ field on Detail in the Marks card.
5. The view looks like this now.
6. Put right click on axis and select the Add reference line option.
7. Select the following option.
8. From the view it is clear that ‘Binders and Binder Accessories’ and ‘Envelopes’ have crossed the target profit margin.
Question 3:
Default Aggregation level of Tableau Work Book is
Choose the correct option:
- A) Average
- B) Default for Sheets is sum whereas for workbook it is average
- C) Multiplication
- D) Sum
Correct Answer: D
Default aggregation for tableau worksheet and workbook is sum.
Stay in touch for the next part in this series for Tableau Certification questions related to Calculations.
Related Articles:
