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