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.
Let’s dive into Tableau Certification Questions related to Tableau Chart types and field in Tableau.
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:
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.
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:
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.
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.
Default Aggregation level of Tableau Work Book is
Choose the correct option:
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:
It’s a tough reality: every year, over 14.1 million workers suffer from work-related injuries. For…
If you’ve ever wanted to learn how to cook, but didn’t know where to start,…
Choosing the right career path can be a daunting task, especially with the myriad of…
Believe it or not, the concept of human resources has existed for more than 100…
Web3 managed to change the gaming industry by leveraging blockchain technology. It offers a decentralized…
College is often fun and is filled with lots of activities, especially in the first…