Tableau Desktop Specialist Exam (New Pattern 2021)
- November 09, 2021
I recently completed the Tableau Desktop Specialist Certification (New Pattern). I’d like to take a moment to discuss how I prepared, the study materials I used and the types of questions you can expect.
If you’re planning on taking the exam, I hope I’ll be able to help you by the end of this article!
Before talking about the desktop certification exam, let me give an overview of Tableau.
What is Tableau?
Data visualization uses maps, graphs, charts and other visual elements to depict a dataset or information. Data visualization aids in the comprehension of a dataset’s trends, insights, patterns and other relationships.
Tableau is a data visualization tool that allows users to quickly create interactive data visualizations with a user-friendly drag-and-drop interface. Tableau enables easy movement between overall data sets and in-depth analytical data sets to draw smart conclusions.
Tableau also allows users to add colors, widths, depths, pictures, animations and more to their tables. As a result, once complex data sets can now be easily understood and presented to external stakeholders.
The software is primarily used to extract business intelligence from massive amounts of data, including social media interaction, sales figures or other metrics that could help an organization make decisions.
Types of Tableau certifications
Tableau provides three separate Tableau Desktop Exams, each with a different difficulty level.
- Tableau Desktop Specialist (recommended experience: 3+ months)
- Tableau Desktop Certified Associate (recommended experience: 5+ months)
- Tableau Desktop Certified Professional (recommended experience: 12+ months)
Why Tableau Desktop Certification?
Tableau can help the transformation of data into usable business intelligence in jobs across all business functions. The popularity of Tableau and Tableau certification-related search patterns may be due to this, as well as the growing popularity of “business analyst” and “data analyst” type employment. If you’re looking to stand out in a sea of well-qualified data candidates, mastering Tableau can be one approach.
Tableau recommends ~3 months of product exposure for the Tableau Desktop Specialist Exam, presenting this certification as the best option for beginners. According to Tableau, the test is “designed to assess basic functions and product comprehension.” Another important feature that persuaded me is that the Tableau Desktop Specialist certification doesn’t have an expiration date. If you pass the exam once, you receive a lifelong certification.
Exam format
Image from: Microsoft Word – TableauDesktopSpecialist_Exam Guide.docx
The new Desktop Specialist Exam is given without using the Tableau Platform, the internet or any other third-party program.
There are two types of questions in the new Tableau Desktop Specialists format.
- Multiple-choice questions with only one correct answer.
- Multiple-choice questions with two or three correct answers.
There are no hands-on questions in the new format.
If a question has one, two or three right answers, it will be mentioned in the question itself, and if you select more than those options, it will simply not allow you to select.
There are 45 questions, with five questions unscored. Because the unscored questions are not explicitly mentioned, you must approach each question as if it contains a score.
The Desktop Specialist exam has a passing score of 750 out of 1000. This is the Pearson Vue scoring method.
Tableau Desktop Specialist Certification preparation
As mentioned earlier, Tableau recommends at least three months of hands-on experience to take this exam. However, with the correct study materials, a can-do attitude and the determination to learn independently, you could try the exam sooner.
Tableau’s syllabus or study guide is right on point. I’ve used it as a guide to write down the type of questions I experienced and questions you can expect from this exam.
1.Connecting to and preparing data 25%
●Joins, unions and relationships: definition, differences, how to create one, advantages, on which layer it is created (logical vs. physical layer).
●Live and extract: differences, advantages of live and extract connections, options that you get while creating an extract, how to create one, default connection, when to use them.
●Default properties/aggregations for dimension as well as measures.
●Different ways to change the datatype of a field (from data pane, from data source page).
●Types of data types (default hierarchies on which data types)
●Different types of geographical roles. How to assign a geographical role, can geographical roles be assigned to numeric or string fields.
2.Exploring and analyzing data 35%
●Dual axis chart vs combined axis chart: difference, how to create them, minimum requirements to create them (minimum dimension, measure), When to use a dual axis chart or a combined axis chart.
●Reference lines: ways to plot a reference line, types of fields on which reference line can be applied to, what does a reference line indicate.
●Scatter plot: Minimum requirements to create a scatter plot, Lines that can be added to a scatter plot.
●Everything in the analytics pane.
●Filters: different types of filters, order of operations of filters, filter legends for discrete and continuous fields, types of filter options present for discrete and continuous (range of values, special).
●Context filter: When to use a context filter and advantages of a context filter.
●Parameters: definition, when is it useful to use a parameter, difference between a parameter and a filter.
●Sorting: different types of sorting, different methods to sort the viz.
●Table calculations: different types of table calculations, difference between addressing and partitioning.
●Aggregations: Default aggregations, aggregations for dimension and measure.
●Totals: Different ways to show totals on the sheet.
●Calculated fields: Options present while writing a calculation, what all can be added to a calculation (parameter, sets).
●Groups and sets: Different ways to create them, different types, differences between them.
●Stacked bar chart: How to create it.
●Histogram: what does BIN show in case of a histogram, minimum requirements to create a histogram.
3.Sharing Insights 25%
●Different steps to bold and iItalicize the axis, headers, tooltips.
●Marks Card: Dragging a dimension or a continuous field to the marks card, read about all the options present in the marks card.
●Which charts are unaffected by size marks.
●Shapes: How to add non-default shapes in the viz, which charts are unaffected by Shape marks.
●Legends : Options present in legends in case of dimension and filters, how to change the position of a legend in a dashboard, show and hide legends.
●Dashboards: Dashboard actions (different ways to perform these actions), dashboard layouts, dashboard objects.
●Story/Story point: What all can be added to a story/story point, what is a story point.
●Exporting View: Different ways to share a workbook (such as twbx as a PDF or an image, publish to Tableau Server), view and export underlying data, what all is saved in case of a .twbx format, why do we need a .twbx file in a PDF format.
●Show me Option: What all parameters (number of dimensions, measures, date fields, geographical fields) can be seen in the show me option, charts present in this option.
4.Understanding Tableau Concepts 15%
●Dimension vs. measures: Information that these two contain, differences between them should be well-understood.
●Discrete vs. continuous: Difference between them is important, difference between discrete date parts and discrete date values, representation of discrete and continuous fields, explain how a view’s aggregated measure changes when dimensions are introduced.
●Pills: Different types of pills (blue, green, red), what do these fields represent?
Below are a few resources provided by Tableau to help in your preparation:
●Official Syllabus: Microsoft Word TableauDesktopSpecialist_Exam Guide.docx
●Free Training Videos 2021.1 (tableau.com): This is Tableau’s free instructional video series, which is constantly updated with new releases. You’ll find it organized into several categories and videos based on it.
●Tableau eLearning: For Tableau Desktop Specialist certification, you can follow their Tableau Fundamentals learning course.
Additional Resources/Questions Dumps:
●Tableau Desktop Specialist Certification Practice Tests 2021 | Udemy
●Tableau Desktop Specialist Certification Exam | CodeUsingJava
●Tableau Associate Exam Questions Flashcards | Quizlet
●Free Tableau Certification Dumps (simplilearn.com)
●Tableau Desktop Specialist Exam Practice Questions – Part 1 – YouTube
Conclusion
Even though Tableau requires 3+ months of experience, one can still clear the exam with less than three months of practice on Tableau, provided a candidate’s dedicated determination and continuous hands-on practice. It took me about two months to prepare and pass the exam.
There have been a few significant changes in the new exam format compared to the previous renditions, including new topics such as Relationships and an increase in the number of theoretical components replacing hands-on questions. The level or type of theoretical questions remains the same.
The test will be straightforward if you practice regularly on Tableau, go through all the resources and practice tests provided by Tableau and can recall numerous methods/steps to perform a specific task.
References
What is Tableau: Uses and Applications (intellipaat.com)
— By Ankit Chauhan