Tableau Certified Data Analyst Practice Exam
Tableau Certified Data Analyst Practice Exam
About Tableau Certified Data Analyst Practice Exam
The Tableau Certified Data Analyst certification exam has been designed for candidates who perform a vital role in facilitating business decision-making processes. They excel at understanding business problems, identifying relevant data for analysis, and presenting actionable insights to stakeholders.
Skills Validated
This Tableau Certified Data Analyst certification exam assesses both fundamental Tableau knowledge and practical development skills of employees, partners, customers, and freelancers working with various Tableau products, including Tableau Desktop, Tableau Prep, and either Tableau Server or Tableau Online.
Exam Prerequisites
There are no prerequisites for taking the Tableau Certified Data Analyst exam, and successful candidates are awarded the title of Tableau Certified Data Analyst, which remains valid for two years.
Who should take the exam?
The Tableau Certified Data Analyst exam is intended for individuals with expertise in Tableau Desktop, Tableau Prep, and either Tableau Server or Tableau Online. Candidates should possess the skills of -
- Connecting to data sources
- Performing data transformations
- Exploring and analyze data
- Creating meaningful visualizations to address key business questions
- Sharing and maintaining content by publishing, scheduling, and managing it on the web
Recommended Experience
A Data Analyst is suggested to have a minimum of 6 months of experience working with Tableau and its products, including Tableau Prep, Tableau Desktop, and either Tableau Server or Tableau Online.
Exam Details
- Total Questions: 40-45 knowledge-based items, including multiple-choice, multiple-select, and active screen items. Additionally, there are 8-10 performance-based hands-on lab items.
- Exam Version: The exam is currently testing on version 2021.1 of Tableau.
- Exam Duration: 120 minutes (including 3 minutes for reviewing the Non-Disclosure Agreement (NDA) and 5 minutes for the tutorial)
- Exam Language: English and Japanese.
- Passing Score: A score of 750 or above is required to pass the exam.
- Results: Exam results are communicated via email within 48 hours of completing the exam.
- Prerequisite: No prerequisites are required to register for the exam.
Course Outline
The Tableau Certified Data Analyst Exam covers the following topics
Module 1: Understanding to connect to and Transform Data
1.1 Describe connecting to Data Sources
- Learn to choose an appropriate data source
- Learn to choose between live connection or extract
- Learn to connect to extracts
- Learn to connect to spreadsheets
- Learn to connect to .hyper files (or .tde files)
- Learn to connect to relational databases
- Learn to pull data from relational databases by using custom SQL queries
- Learn to connect to a data source on Tableau Server
- Learn to replace the connected data source with another data source for an existing chart or sheet
1.2. Describe preparing data for analysis
- Learn to assess data quality (completeness, consistency, accuracy)
- Learn to perform cleaning operations
- Learn to organize data into folders
- Learn to use multiple data sources (establish relationships, create joins, union tables, blend data)
- Learn to prepare data by using Data Interpreter, pivot, and split
- Learn to create extract filters
1.3. Describe performing data transformation in Tableau Prep
- Learn to choose data transformation to perform based on a business scenario
- Learn to combine data by using unions
- Learn to combine data by using joins
- Learn to shape data by using aggregations
- Learn to perform filtering
- Learn to shape data by using pivots
1.4. Describe customizing fields
- Learn to change default field properties
- Learn to rename columns
- Learn to choose when to convert between discrete and continuous
- Learn to choose when to convert between dimension and measure
- Learn to create aliases
Module 2: Understanding to explore and analyze data
2.1. Describe creating calculated fields
- Learn to write date calculations (DATEPARSE, DATENAME…)
- Learn to write string functions
- Learn to write logical and Boolean expressions (If, case, nested, etc.)Learn to write number functions
- Learn to write type conversion functions
- Learn to write aggregate functions
- Learn to write FIXED LOD calculations
2.2. Describe creating quick table calculations
- Learn the concept of moving average
- Learn the concept of percent of total
- Learn the concept of running total
- Learn the concept of difference and percent of difference
- Learn the concept of percentile
- Learn the concept of compound growth rate
2.3 Describe creating custom table calculations
- Learn about Year to date
- Month to date
- Year over year
- Index
- Ranking
- First-last
2.4. Describe creating and using filters
- Learn to apply filters to dimensions and measures
- Learn to configure filter settings including Top N, Bottom N, include, exclude, wildcard, and conditional
- Learn to add filters to context
- Learn to apply filters to multiple sheets and data sources
2.5. Describe creating parameters to enable interactivity
- Learn to use in calculations
- Learn to use with filters
- Learn to use with reference lines
2.6 Describe structuring the data
- Learn about Sets
- Learn about Bins
- Learn about Hierarchies
- Learn about Groups
2.7. Describe mapping data geographically
- Learn to create symbol maps
- Learn to create heat maps
- Learn to create density maps
- Learn to create choropleth maps (filled maps)
2.8. Describe summarizing, model, and customizing data by using the Analytics feature
- Learn about totals and subtotals
- Learn about reference lines
- Learn about reference bands
- Learn about average lines
- Learn about trend lines
- Learn about distribution bands
- Learn about forecast by using default settings
- Learn about customize a data forecasting model
- Learn about create a predictive model
Domain 3: Understanding to create Content
3.1 Describe creating charts
- Learn creating basic charts from scratch
- Sort data (including custom sort)
3.2. Describe creating dashboards and stories
- Learn to combine sheets into a dashboard by using containers and layout options
- Learn to add objects
- Learn to create stories
3.3 Describe adding interactivity to dashboards
- Learn applying a filter to a view
- Learn to add filter, URL, and highlight actions
- Learn to swap sheets by using parameters or sheet selector
- Learn to add navigation buttons
- Learn to implement user guiding sentences (click…, hover…, menu options)
3.4 Describe Formatting dashboards
- Learn to apply color, font, shapes, styling
- Learn to add custom shapes and color palettes
- Learn to add annotations
- Learn to add tooltips
- Learn to apply padding
- Learn to remove gridlines, row-level and column-level bands, and shading
- Learn to apply responsive design for specific device layouts
Domain 4: Understanding Publish and Manage Content on Tableau Server and Tableau Cloud
4.1 Describe Publish Content
- Learn to publish a workbook
- Learn to publish a data source
- Learn to print content
- Learn to export content
4.2. Describe scheduling data updates
- Learn to schedule data extract refreshes
- Learn to schedule a Tableau Prep workflow
4.3 Describe managing Published workbooks
- Learn to create alerts
- Learn to create subscriptions
What do we offer?
- Full-Length Mock Test with unique questions in each test set
- Practice objective questions with section-wise scores
- In-depth and exhaustive explanation for every question
- Reliable exam reports evaluating strengths and weaknesses
- Latest Questions with an updated version
- Tips & Tricks to crack the test
- Unlimited access
What are our Practice Exams?
- Practice exams have been designed by professionals and domain experts that simulate real-time exam scenario.
- Practice exam questions have been created on the basis of content outlined in the official documentation.
- Each set in the practice exam contains unique questions built with the intent to provide real-time experience to the candidates as well as gain more confidence during exam preparation.
- Practice exams help to self-evaluate against the exam content and work towards building strength to clear the exam.
- You can also create your own practice exam based on your choice and preference
