Tableau Certified Data Analyst Practice Exam

The Tableau Certified Data Analyst certification validates your expertise in utilizing Tableau Desktop to explore, analyze, and visualize data to communicate insights effectively. 

Who should consider this Exam:

• Individuals with experience using Tableau Desktop: This certification validates your existing skills and knowledge.
• Data analysts, business analysts, and other professionals seeking to enhance their data visualization and communication skills.
• Individuals looking to transition into a data analysis or business intelligence role: This certification showcases your competency to potential employers.

Key Roles and Responsibilities:

• Connect to and explore data: Connect to various data sources, clean and prepare data for analysis.
• Create visualizations: Develop different chart types (e.g., bar charts, line charts, heatmaps) to effectively represent data insights.
• Apply data analysis techniques: Utilize calculations, filters, and aggregations to analyze and interpret data patterns.
• Build dashboards and stories: Create dashboards and stories that combine visualizations and text to communicate insights clearly and concisely.
• Share and collaborate on data insights: Share visualizations and dashboards with stakeholders and collaborate effectively to derive actionable business decisions.

Exam Details:

• Format: Hands-on simulation using Tableau Desktop (no memorization required)
• Time Limit: 120 mins
• Languages: English, Japanese
• Passing Score: 750 and above

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

• Learning to choose an appropriate data source
• Learning to choose between live connection or extract
• Learning to connect to extracts
• Learning to connect to spreadsheets
• Learning to connect to .hyper files (or .tde files)
• Learning to connect to relational databases
• Learning to pull data from relational databases by using custom SQL queries
• Learning to connect to a data source on Tableau Server
• Learning to replace the connected data source with another data source for an existing chart or sheet

1.2.     Describe preparing data for analysis

• Learning to assess data quality (completeness, consistency, accuracy)
• Learning to perform cleaning operations
• Learning to organize data into folders
• Learning to use multiple data sources (establish relationships, create joins, union tables, blend data)
• Learning to prepare data by using Data Interpreter, pivot, and split
• Learning to create extract filters

1.3.     Describe performing data transformation in Tableau Prep

• Learning to choose data transformation to perform based on a business scenario
• Learning to combine data by using unions
• Learning to combine data by using joins
• Learning to shape data by using aggregations
• Learning to perform filtering
• Learning to shape data by using pivots

1.4.    Describe customizing fields

• Learning to change default field properties 
• Learning to rename columns
• Learning to choose when to convert between discrete and continuous
• Learning to choose when to convert between dimension and measure
• Learning to create aliases

Module 2: Understanding to explore and analyze data

2.1. Describe creating calculated fields

• Learning to write date calculations (DATEPARSE, DATENAME…)
• Learning to write string functions
• Learning to write logical and Boolean expressions (If, case, nested, etc.)Learning to write number functions
• Learning to write type conversion functions
• Learning to write aggregate functions
• Learning to write FIXED LOD calculations

2.2. Describe creating quick table calculations

• Learning the concept of moving average
• Learning the concept of percent of total
• Learning the concept of running total
• Learning the concept of difference and percent of difference
• Learning the concept of percentile
• Learning the concept of compound growth rate

2.3 Describe creating custom table calculations

• Learning about Year to date
• Month to date
• Year over year
• Index
• Ranking
• First-last

2.4.   Describe creating and using filters

• Learning to apply filters to dimensions and measures
• Learning to configure filter settings including Top N, Bottom N, include, exclude, wildcard, and conditional
• Learning to add filters to context
• Learning to apply filters to multiple sheets and data sources

2.5.  Describe creating parameters to enable interactivity

• Learning to use in calculations
• Learning to use with filters
• Learning to use with reference lines

2.6 Describe structuring the data

• Learning about Sets
• Learning about Bins
• Learning about Hierarchies
• Learning about Groups

2.7.  Describe mapping data geographically

• Learning to create symbol maps
• Learning to create heat maps
• Learning to create density maps
• Learning to create choropleth maps (filled maps)

2.8.   Describe summarizing, model, and customizing data by using the Analytics feature

• Learning about totals and subtotals
• Learning about reference lines
• Learning about reference bands
• Learning about average lines
• Learning about trend lines
• Learning about distribution bands
• Learning about forecast by using default settings
• Learning about customize a data forecasting model
• Learning about create a predictive model

Domain 3: Understanding to create Content

3.1 Describe creating charts

• Learning creating basic charts from scratch
• Sort data (including custom sort)

3.2.  Describe creating dashboards and stories

• Learning to combine sheets into a dashboard by using containers and layout options
• Learning to add objects
• Learning to create stories

3.3 Describe adding interactivity to dashboards

• Learning applying a filter to a view
• Learning to add filter, URL, and highlight actions
• Learning to swap sheets by using parameters or sheet selector
• Learning to add navigation buttons
• Learning to implement user guiding sentences (click…, hover…, menu options)

3.4 Describe Formatting dashboards

• Learning to apply color, font, shapes, styling
• Learning to add custom shapes and color palettes
• Learning to add annotations
• Learning to add tooltips
• Learning to apply padding
• Learning to remove gridlines, row-level and column-level bands, and shading
• Learning 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

• Learning to publish a workbook
• Learning to publish a data source
• Learning to print content
• Learning to export content

4.2.  Describe scheduling data updates

• Learning to schedule data extract refreshes
• Learning to schedule a Tableau Prep workflow

4.3 Describe managing Published workbooks

• Learning to create alerts
• Learning to create subscriptions