Salesforce Certified Tableau Data Analyst Exam Study Guide

Salesforce-Certified-Tableau-Data-Analyst

Salesforce Certified Tableau Data Analyst Preparation Details

The Salesforce Certified Tableau Data Analyst exam tests your ability to connect, prepare, analyze, and visualize data across Tableau Desktop, Prep, and Server or Cloud. This guide links every exam objective to verified Tableau documentation for focused study. You can also explore more Salesforce certification study guides on the Salesforce Certification category to keep building your skills.

Salesforce Certified Tableau Data Analyst Materials

CourseraAce the Salesforce Certified Tableau Data Analyst Exam
UdemySalesforce Tableau Data Analyst Certification Prep
WhizlabsTableau Certified Data Analyst Certification

Connect To and Transform Data: 24%

1.1 Connect to data sources

1.1.1. Identify data source

Connect to Your Data

Plan the Data Source

Connect to Data by Using Tableau Server or Tableau Cloud

1.1.2. Determine live connection vs. extract

Extract Your Data

Refresh Data Sources

Best Practices for Published Data Sources

1.1.3. Connect to extracts

Extract Your Data

Refresh Extracts

Create Extracts on the Web

1.1.4. Connect to files

Connect to Your Data

Creators: Connect to Data on the Web

Clean Data from Excel, CSV, PDF, and Google Sheets with Data Interpreter

1.1.5. Connect to relational databases

Connect to Your Data

Plan the Data Source

1.1.6. Connect to published data sources from a Tableau Server or Tableau Cloud site

Connect to Data by Using Tableau Server or Tableau Cloud

Creators: Connect to Data on the Web

1.1.7. Replace the connected data source with another data source for an existing chart or sheet

Replace Data Sources

Edit Data Sources

1.2. Prepare data for analysis

1.2.1. Assess data quality (completeness, consistency, accuracy)

Set a Data Quality Warning

About Tableau Catalog

Explore and Inspect Data in a View

1.2.2. Perform cleaning operations

Clean Data from Excel, CSV, PDF, and Google Sheets with Data Interpreter

Clean and Shape Data in Tableau Prep

1.2.3. Organize data fields into folders

Organize and Customize Fields in the Data Pane

Work with Data Fields in the Data Pane

1.2.4. Use multiple data sources (establish relationships, create joins, union tables)

Relate Your Data

Join Your Data

Union Your Data

How Relationships Differ from Joins

1.2.5. Prepare data by using Data Interpreter, pivot, and split

Clean Data from Excel, CSV, PDF, and Google Sheets with Data Interpreter

Pivot Data from Columns to Rows

Split a Field into Multiple Fields

1.2.6. Create extract and data source filters

Filter Data from Your Data Source

Extract Your Data

1.3. Perform data transformation in Tableau Prep

1.3.1. Choose which data transformation to perform based on a business scenario

About Tableau Prep

Clean and Shape Data in Tableau Prep

1.3.2. Combine data by using unions

Aggregate, Join, or Union Data

Add More Data in the Input Step

1.3.3. Combine data by using joins

Aggregate, Join, or Union Data

Build and Organize your Flow

1.3.4. Shape data by using aggregations

Aggregate, Join, or Union Data

1.3.5. Perform filtering

Clean and Shape Data in Tableau Prep

Build and Organize your Flow

1.3.6. Shape data by using pivots

Pivot Your Data

1.3.7. Determine which output type to use

Save and Share Tableau Prep Work

Build and Organize your Flow

1.4. Customize fields

1.4.1. Change default field properties (types, sorting, etc.)

Edit Default Settings for Fields

1.4.2. Rename columns

Edit Default Settings for Fields

Work with Data Fields in the Data Pane

1.4.3. Choose when to convert between discrete and continuous

Dimensions and Measures, Blue and Green

1.4.4. Choose when to convert between dimension and measure

Dimensions and Measures, Blue and Green

1.4.5. Create aliases

Create Aliases to Rename Members in the View

Explore and Analyze Data: 41%

2.1. Create calculated fields

2.1.1. Write date calculations

Date Functions

2.1.2. Write string functions

String Functions

2.1.3. Write logical and Boolean expressions

Logical Functions

2.1.4. Write number functions

Number Functions

2.1.5. Write type conversion functions

Type Conversion

2.1.6. Write aggregate functions

Aggregate Functions in Tableau

2.1.7. Write basic spatial calculations

Spatial Functions

2.2. Create table calculations

2.2.1. Moving average and window average

Table Calculation Types

Quick Table Calculations

2.2.2. Percent of total

Table Calculation Types

2.2.3. Running total

Table Calculation Types

Transform Values with Table Calculations

2.2.4. Difference and percent of difference

Table Calculation Types

2.2.5. Percentile

Table Calculation Types

2.2.6. Index

Table Calculation Functions

2.2.7. Ranking

Table Calculation Functions

2.2.8. Apply quick table calculations

Quick Table Calculations

2.2.9. Customize table calculations

Customize Table Calculations

2.3. Create and use filters

2.3.1. Apply filters to dimensions and measures

Filter Data from Your Views

2.3.2. Configure filter settings including Top N, Bottom N, include, exclude, wildcard, and conditional

Filter Data from Your Views

2.3.3. Add filters to context

Use Context Filters

2.3.4. Apply filters to multiple sheets and data sources

Filter Data Across Multiple Data Sources

2.4. Create parameters to enable interactivity

2.4.1. In calculations

Create Parameters

2.4.2. With filters

Create Parameters

2.4.3. With reference lines

Create Parameters

Parameter Actions

2.4.4. Set parameters to dynamically refresh

Keep up with dynamic data changes using dynamic parameters

2.5. Structure the data

2.5.1. Sets

Create Sets

2.5.2. Bins

Create Bins from a Continuous Measure

2.5.3. Hierarchies

Create Hierarchies

2.5.4. Groups

Group Your Data

2.6. Map data geographically

2.6.1. Create symbol maps

Build a Simple Map

Mapping in Tableau

2.6.2. Create density maps

Build a Simple Map

2.6.3. Create choropleth maps (filled maps)

Create Maps that Show Ratio or Aggregated Data in Tableau

2.6.4. Create mark layers

Create Geographic Layers for Maps

2.7. Summarize, model, and customize data by using the Analytics pane

2.7.1. Totals and subtotals

Show Totals in a Visualization

2.7.2. Reference lines

Reference Lines, Bands, Distributions, and Boxes

2.7.3. Reference bands

Reference Lines, Bands, Distributions, and Boxes

2.7.4. Average lines

Analytics Pane

2.7.5. Trend lines

Add Trend Lines to a Visualization

2.7.6. Distribution bands

Reference Lines, Bands, Distributions, and Boxes

2.7.7. Forecast by using default settings

Forecasting

2.7.8. Customize a data forecasting model

Forecast Options Dialog Box

2.8. Create Level of Detail (LOD) calculations

2.8.1. Write FIXED LOD calculations

FIXED Level of Detail Expressions

2.8.2. Write INCLUDE LOD calculations

INCLUDE Level of Detail Expressions

2.8.3. Write EXCLUDE LOD calculations

EXCLUDE Level of Detail Expressions

2.8.4. Write nested LOD calculations

Level of Detail Expressions

Overview: Level of Detail Expressions

Create Content: 26%

3.1. Create charts

3.1.1. Create basic charts from scratch (bar, line, pie, highlight table, scatter plot, histogram, tree map, bubbles, data tables, Gantt, box plots, area, dual axis, combo)

Choose the Right Chart Type for Your Data

Build a Bar Chart

Build a Pie Chart

Build a Scatter Plot

Build a Histogram

Build a Treemap

Build a Gantt Chart

3.1.2. Sort data (including custom sort)

Sort Data in a Visualization

3.2. Create dashboards and stories

3.2.1. Combine sheets into a dashboard by using containers and layout options

Create a Dashboard

Size and Lay Out Your Dashboard

3.2.2. Add objects (containers, images, text)

Create a Dashboard

3.2.3. Create stories using story points

Creating a Story

Stories

3.3. Add interactivity to dashboards

3.3.1. Use filter in a dashboard

Actions and Dashboards

Filter Actions

3.3.2. Add filter, URL, and highlight actions

Filter Actions

URL Actions

Highlight Actions

3.3.3. Create interactivity using dynamic zone visibility

Use Dynamic Zone Visibility

3.3.4. Add navigation buttons

Create a Dashboard

3.3.5. Create interactivity using set and parameter actions

Set Actions

Parameter Actions

3.3.6 Create show/hide buttons for dashboard objects

Create a Dashboard

3.4. Format workbooks, worksheets, and dashboards

3.4.1. Apply color, font, shapes, styling

Format at the Worksheet Level

Control the Appearance of Marks in the View

3.4.2. Add custom shapes and color palettes

Create Custom Color Palettes

Control the Appearance of Marks in the View

3.4.3. Add annotations

Add Annotations

3.4.4. Customize tooltips

Create Views for Tooltips (Viz in Tooltip)

Format Individual Parts of the View

3.4.5. Apply padding

Format Dashboard Objects

3.4.6. Format gridlines, row-level and column-level bands, and shading

Format at the Worksheet Level

Format Your Work

3.4.7. Create a responsive design for specific device layouts

Create Dashboard Layouts for Different Device Types

Publish and Manage Content on Tableau Server and Tableau Cloud: 9%

4.1. Publish Content

4.1.1. Publish a workbook

Publish a Workbook

4.1.2. Publish a data source from Desktop or Prep

Publish a Data Source

Best Practices for Published Data Sources

4.1.3. Export content

Export Data from Tableau Desktop

Download Views and Workbooks

4.1.4. Publish a flow

Publish a Flow to Tableau Server or Tableau Cloud

4.2. Schedule data updates

4.2.1. Schedule data extract refreshes

Schedule Extract Refreshes as You Publish a Workbook

Quick Start: Refresh Extracts on a Schedule

4.3. Manage published workbooks

4.3.1. Create alerts

Send Data-Driven Alerts from Tableau Cloud or Tableau Server

4.3.2. Create subscriptions

Create a Subscription to a View or Workbook

4.3.3. Create and save custom views

Use Custom Views

4.3.4. Understand user roles and permissions

Set Users’ Site Roles

Permissions, Site Roles, and Licenses

4.3.5. Customize and distribute a published workbook

Edit Tableau Views on the Web

Getting Started with Web Authoring

Wrapping Up Salesforce Certified Tableau Data Analyst

This guide has walked through every domain of the Salesforce Certified Tableau Data Analyst exam guide, from connecting and preparing data through advanced calculations, mapping, dashboards, and publishing. Working through each linked resource in order will build the practical Tableau skills the exam expects, and give you the confidence to sit for the Data Analyst credential. You can also explore more Salesforce certification study guides on the Salesforce Certification category to keep building your skills. Have a question or tip? Leave a comment below.

Receive Updates on Salesforce Certified Tableau Data Analyst Exam


Want to be notified as soon as I post? Subscribe to the RSS feed / leave your email address in the subscribe section. Share the article to your social networks with the below links so it can benefit others.

Share the Salesforce Certified Tableau Data Analyst Study Guide in Your Network

You may also like

Leave a Reply

Your email address will not be published. Required fields are marked *