How to Prepare for Tableau Desktop Certification?
Sample paper for Tableau Desktop, my experience with Tableau Desktop certification.
In this blog, you will seek “How I scored 85% in my Tableau Certification”. And sample questions, important links, material, guidelines, and other information. My aim is to share the right direction, and create a focus for you to pass the Tableau certification.
To pass the Tableau certification Exam, you must understand the Exam format:
Time Limit: 60 minutes
Question Format: Multiple choice, multiple responses
Number of Questions: 45 (40 scored, 5 unscored)
Passing Score: The passing scaled score for this exam is 750.
Language(s) Offered: English, Japanese, and Simplified Chinese.
The Tableau Certification exam is only available in the following languages, and therefore you can not take the exam if you do not know English, Japanese, or Chinese.
During the exam, there are dummy questions that even if you score correctly will not increase your score. They are identical to the real questions hence, make it impossible to distinguish between real and dummy questions.
As of 2022, all the Tableau Desktop Exam Questions are Multiple Choice Questions.
Tableau Desktop Exam, are online and requires a high-speed internet connection. They recommend using LAN however, the wifi connection is equally good. One must make sure the strength of Wifi connection is full strength. Otherwise, during the exam, the internet connection might break and make you lose your focus!
Don’t worry, and stay focused on the test. Because the invigilator from Pearson Vue will pause the test time, and send you a rejoin URL attached in the Email to your Email address in the case of an internet problem.
Before you Take the Tableau Certification you must prepare these:
The tasks you must do before taking the Tableau Ceritifications are firstly, use Tableau Desktop for atleast 25 hours more before till you are comfortable with all the features. Secondly, complete these topics:
Book Your Tableau Desktop Certification
https://www.tableau.com/learn/certification/desktop-specialist
Information on all Tableau Certification
https://www.tableau.com/learn/certification
Learn Data Analysis and Tableau in 1 Hour.
Domain 1: Connecting to & Preparing Data = 25%
1.1 Create live connections and extracts
1.1.1 Create a live connection to a data source
1.1.2 Explain the differences between using live connections versus extracts
1.1.3 Create an extract
1.1.4 Save metadata properties in a .TDS
1.1.5 Create a data source that uses multiple connections
1.2 Create and manage the data model
1.2.1 Add relationships to a data source
1.2.2 Add joins and unions
1.2.3 Explain when to use a join versus a relationship
1.3 Manage data properties
1.3.1 Rename a data field
1.3.2 Assign an alias to a data value
1.3.3 Assign a geographic role to a data field
1.3.4 Change data type for a data field (number, date, string, Boolean, etc.)
1.3.5 Change default properties for a data field (number format, aggregation, color, date
format, etc.)
Domain 2: Exploring & Analyzing Data = 35%
2.1 Create basic charts
2.1.1 Create a bar chart
2.1.2 Create a line chart
2.1.3 Create a scatterplot
2.1.4 Create a map using geographic data
2.1.5 Create a combined axis chart
2.1.6 Create a dual axis chart
2.1.7 Create a stacked bar
2.1.8 Create a density map
2.1.9 Create a chart to show specific values (crosstab, highlight table)
2.2 Organize data and apply filters
2.2.1 Create groups by using marks, headers, and the data pane
2.2.2 Create sets by using marks and the data pane
2.2.3 Organize dimensions into a hierarchy
2.2.4 Add a filter to a view
2.2.5 Add a date filter
2.3 Apply analytics to a worksheet
2.3.1 Add a manual or a computed sort
2.3.2 Add a reference line
2.3.3 Use a quick table calculation
2.3.4 Use bins and histograms
2.3.5 Create a calculated field (e.g. string, date, simple arithmetic)
2.3.6 Explain when to use a parameter
2.3.7 Display totals on a worksheet
Domain 3: Sharing Insights = 25%
3.1 Format view for presentation
3.1.1 Use color from the marks card
3.1.2 Configure fonts
3.1.3 Format marks as shapes
3.1.4 Configure viz animations
3.1.5 Change size of marks
3.1.6 Show and hide legends
3.2 Create and modify a dashboard
3.2.1 Add worksheets to a dashboard
3.2.2 Add interactive elements for consumers (e.g. show filters, data highlighter, tooltips)
3.2.3 Add dashboard actions (e.g. filter action, highlight action, parameter control, URL action)
3.2.4 Configure a dashboard layout and create device-specific dashboards
3.2.5 Create a story and a story point
3.3 View and share workbook data
3.3.1 Share a workbook (e.g. twbx as a PDF or an image, publish to Tableau Server)
3.3.2 View and export underlying data
3.3.3 Export to Microsoft PowerPoint
Domain 4: Understanding Tableau Concepts = 15%
4.1 Understand dimensions and measures
4.1.1 Explain what kind of information dimensions usually contain
4.1.2 Explain what kind of information measures usually contain
4.1.3 Explain the difference between dimensions and measures
4.2 Understand discrete and continuous fields
4.2.1 Explain how discrete fields are displayed
4.2.2 Explain how continuous fields are displayed
4.2.3 Explain the difference between discrete date parts and continuous date values
4.3 Understand aggregations
4.3.1 Explain the default aggregation for measures
4.3.2 Describe how an aggregated measure changes when dimensions are added to a view
Lastly, do atlest 3 sample papers to prepare well.
Good part about Tableau Desktop Certification is that it has no Expiration date.
Tableau Desktop Specialist Sample Questions:
- Which of the following is the best reason to use an extract instead of a live connection?
a) Your data source only supports a live connection via ODBC.
b) You need the freshest possible data at all times.
c) You need to apply an aggregation that takes too long when using a live connection.
d) You need to join tables that are in the data source. - What type of field would display the average value of homes in the United States for the calendar year 2020?
a) A discrete date part dimension
b) A continuous date value dimension
c) A geographical dimension
d) An aggregated measure - The following questions use the tables in the tds_sample_data_all.xlsx file, which can be downloaded here. If you are unable to download the file, try accessing it from another internet browser.
Using the Stocks 2010-2013 table, create a chart to see the monthly change in volumes of stocks, beginning of 2010 to the end of 2013.
Which two consecutive months saw the least fluctuation in increase or decrease?
a) December 2011 – January 2012
b) March 2012 – April 2012
c) November 2012 – December 2012
d) January 2012 – February 2012 - The following questions use the tables in the tds_sample_data_all.xlsx file, which can be downloaded here. If you are unable to download the file, try accessing it from another internet browser.
Using the Flights table, create a bar chart showing the average of Minutes of Delay per Flight broken down by Carrier Name, and filtered by State to only show Minnesota (MN).
What was the average minutes of delay per flight for United in Minnesota?
a) 2,582
b) 61.74
c) 62.98
d) 53.69 - Interactive elements that you can add to a dashboard for users include __.
(Select all that apply.)
a) URL actions
b) edit tooltip options
c) filter actions
d) hide and unhide all sheet options - The following questions use the tables in the tds_sample_data_all.xlsx file, which can be downloaded here. If you are unable to download the file, try accessing it from another internet browser.
Using the Stocks 2010-2013 table, create a chart that shows the percent difference in Volume for each company by year and quarter.
How many quarters did Biogen Idec show a positive percent difference in volume?
a) 1
b) 2
c) 5
d) 6 - The following questions use the tables in the tds_sample_data_all.xlsx file, which can be downloaded here. If you are unable to download the file, try accessing it from another internet browser.
Using the Stocks 2010-2013 table, create a crosstab showing the sum of Volume per Company per Year, then add grand totals to the view.
What was the total volume for Apple in 2013 and the total volume for Apple for 2010 through 2013, respectively?
a) 25,606,397,999 and 127,322,019,216
b) 25,606,397,999 and 26,695,067,569
c) 26,695,067,569 and 134,264,642,523
d) 365,212,953 and 134,264,642,523 - You created a group by selecting field labels in a view. How can you remove members from the group?
a) In the view, right-click the group members you want to remove and select Exclude.
b) In the Data pane, right-click the group and select Edit Group.
c) In the view, right-click the group members you want to remove and select Format.
d) On a color legend, right-click a member you want to remove and select Format legends. - The following questions use the tables in the tds_sample_data_all.xlsx file, which can be downloaded here. If you are unable to download the file, try accessing it from another internet browser.
Union the Stocks 2010-2013 and Stocks 2014 tables, and then create a chart showing the average Close price by year and quarter for each Company from 2010 to 2014.
How many quarters was Amazon’s average closing price over $300?
a) 0
b) 4
c) 5
d) 6 - Which of the following can you use to create a calculated field that returns data independent of the data granularity in a view?
a) An INCLUDE LOD calculation
b) A table calculation
c) A basic calculation
d) A FIXED LOD calculation
Answers to the above Sample question:
| Question: 1 | Answer: c | Question: 2 | Answer: d |
| Question: 3 | Answer: b | Question: 4 | Answer: c |
| Question: 5 | Answer: a, c | Question: 6 | Answer: d |
| Question: 7 | Answer: a | Question: 8 | Answer: b |
| Question: 9 | Answer: c | Question: 10 | Answer: d |
Learn more on Data Analysis, and how to data analysis projects to your Resume and Linkedin here.
Book 1:1 Consulting with Umang
https://topmate.io/umang_bhardwaj
Hi, I wish for to subscribe for this blog to obtain most up-to-date updates, so where can i do it please help out.
You can subscribe from Home Page
Thanks for your blog, nice to read. Do not stop.