Salesforce Certified Tableau Data Analysts enable stakeholders to make business decisions by understanding the business problem, identifying data to explore for analysis, and delivering actionable insights. They have proven skills in connecting to data, creating visualisations, building dashboards, and sharing insights using Tableau.
Salesforce-certified practitioner since 2015 ·
6 active certifications: Administrator, Platform App Builder, Platform Developer I, Sales Cloud Consultant, Service Cloud Consultant, AI Associate ·
Based in Hyderabad, India · All guides updated each Salesforce release cycle (Spring, Summer, Winter).
The Tableau Certified Data Analyst (formerly Tableau Desktop Certified Associate) validates intermediate-to-advanced Tableau skills.
Unlike the Foundations exam, Data Analyst tests applied, practical skills — candidates must work with actual Tableau
Desktop during a hands-on exam component. You build and analyse real workbooks, not just answer multiple-choice questions.
This is the certification Salesforce and most employers require before considering someone a credentialed Tableau professional.
Exam Domain Breakdown
Domain
Weight
Connecting to and Preparing Data
22%
Exploring and Analysing Data
42%
Sharing Insights
20%
Understanding Tableau Concepts
16%
Advanced Topics Tested (Beyond Foundations)
Level of Detail (LOD) Expressions
Deep mastery of FIXED, INCLUDE, and EXCLUDE LODs. Understand when to use each, how they interact with filters, and common use cases like cohort analysis and per-customer averages.
Table Calculations
Running total, percent of total, rank, moving average, year-over-year difference. Know how Addressing and Partitioning control the calculation direction.
Data Preparation in Tableau Prep
Cleaning steps, pivots, joins, unions, aggregations, and publishing flows to Tableau Server/Cloud. The Data Analyst exam increasingly tests Tableau Prep knowledge.
Advanced Chart Types
Box-and-whisker plots, Gantt charts, dual-axis charts, combined axis charts, and custom territory maps. Know when each communicates data most effectively.
Statistical Analysis
Reference lines, bands, and distributions. Trend lines (linear, exponential, logarithmic). Forecasting with confidence intervals. Understanding R-squared and p-value in context.
Security and Row-Level Data Access
User filters for row-level security, data source permissions, project and workbook permissions on Tableau Server/Cloud, and credential management for embedded data sources.
📚 Study Plan for Tableau Data Analyst (5–6 weeks)
Week 1–2: Master LOD expressions — build 20 different LOD-based calculations on the Superstore dataset. Understand filter order: Context → Data Source → Extract → Fixed LOD → Include/Exclude LOD → Dimension → Measure.
Week 3: Table calculations — build running totals, percent of total, and YoY difference. Practise changing Addressing/Partitioning to see how it affects results.
Week 4: Statistical analysis features — add trend lines, reference distributions, and build a forecast. Run through Tableau Prep basics: join two data sources, pivot columns to rows, publish a flow.
Week 5–6: Practise with hands-on performance questions. The exam includes a performance-based component where you build views in live Tableau Desktop — practise speed as well as accuracy.
Next Steps:Tableau Consultant →
Tableau Architect. Tableau Data Analyst holders typically work in Business Intelligence, Sales Operations, or Data Engineering roles at salaries of $95,000–$135,000 USD.
Practice Exam Questions — Salesforce Tableau Data Analyst
Scenario-based questions reflecting the style and difficulty of the actual Salesforce Tableau Data Analyst exam. Updated for Winter '26.
Q1. What is the Tableau Data Analyst certification primarily designed to validate?
A) Tableau Server administration skills
B) Ability to connect and prepare data, perform exploratory analysis, create effective visualisations, and communicate data-driven insights using Tableau Desktop and Tableau Prep Builder
C) Advanced DataWeave transformation skills
D) SQL database administration for Tableau data sources
► Show Answer
✓ Correct: B — Tableau Data Analyst validates end-to-end analytics skills: data connection and prep (Tableau Prep), building calculated fields, designing effective charts, applying filters and parameters, and assembling insightful dashboards in Tableau Desktop.
Q2. What is Tableau Prep Builder used for?
A) Building Tableau Server deployments
B) A visual ETL tool for cleaning, shaping, and combining data from multiple sources before analysis — applying steps like filter, clean, aggregate, join, and union to produce an output for Tableau Desktop analysis
C) A tool for building Tableau calculated fields
D) An API for automating Tableau Desktop actions
► Show Answer
✓ Correct: B — Tableau Prep Builder is the data preparation companion to Tableau Desktop. Analysts use it to clean messy data (standardise values, remove duplicates, fix nulls), reshape tables (pivot, unpivot), join/union sources, and output clean data for analysis.
Q3. What is a "Profiling" view in Tableau Prep Builder?
A) Viewing a saved Tableau profile configuration
B) A visual data quality summary for each field in a step — showing value distribution (histogram/bar chart), null count, unique value count, and sample values to help analysts identify data quality issues at a glance
C) A view of which users profiled the data source
D) A CPU/memory profiling view of Prep performance
► Show Answer
✓ Correct: B — The Profile Pane in Tableau Prep shows per-field data quality metrics: value distribution, % nulls, unique values, and sample data. Analysts use this to spot anomalies (outliers, unexpected categories, excessive nulls) before the data reaches analysis.
Q4. What is a "Wildcard Union" in Tableau Prep Builder?
A) A union that combines all tables in a database
B) A union that automatically includes all files matching a pattern (e.g., all .csv files matching "sales_2025_*.csv") — enabling automatic ingestion of new files added to a folder without reconfiguring the flow
C) A union that merges tables with mismatched schemas
D) A union of data from multiple different database connections
► Show Answer
✓ Correct: B — Wildcard Union in Tableau Prep automatically includes all files in a folder matching a pattern. When new monthly files are added, they are automatically included in the flow on the next run — ideal for regularly arriving incremental file drops.
Q5. What does the "Pivot" step in Tableau Prep Builder do?
A) Changes the sort order of rows in the output
B) Transforms columns into rows (or rows into columns) — converting a wide format (separate columns per month: Jan, Feb, Mar) into a tall/narrow format (Month, Value) that Tableau Desktop prefers for analysis
C) Creates a pivot table summary in the output
D) Rotates the data visualisation 90 degrees
► Show Answer
✓ Correct: B — Pivot in Tableau Prep reshapes data between wide and narrow formats. Wide-to-narrow (most common): separate columns like "Q1 Sales", "Q2 Sales" become two columns: "Quarter" and "Sales Amount" — making time series analysis much easier in Tableau Desktop.
Q6. What is an "Aggregation" step in Tableau Prep Builder?
A) Combining two data flows into one output
B) A step that groups data by one or more dimensions and computes aggregate measures (SUM, AVG, COUNT, MIN, MAX) — reducing row count and creating pre-aggregated output datasets
C) Adding calculated fields using Tableau's formula language
D) Merging (joining) two data sources into one table
► Show Answer
✓ Correct: B — Aggregation steps in Tableau Prep group rows by selected dimensions and aggregate measures. Useful for: pre-computing customer totals before joining to another table, creating summary datasets for specific analyses, or reducing large datasets before loading into Desktop.
Q7. Universal Containers has data spread across 12 monthly Excel files with identical structure. How should Tableau Prep handle this?
A) Import each file separately and join them all
B) Use a Union with Wildcard matching on the file pattern — Tableau Prep automatically reads all matching files and stacks them as rows in a single unified dataset
C) Manually copy all data into one Excel file first
D) Use a Tableau parameter to switch between files at runtime
► Show Answer
✓ Correct: B — Tableau Prep's Wildcard Union auto-reads all files matching a pattern from a folder. 12 monthly files with identical columns are unioned into one continuous dataset without manual merging — and new files added to the folder are automatically included.
Q8. What is a "Join" step in Tableau Prep Builder and when is it preferable to a Union?
A) Joins and Unions do the same thing in Tableau Prep
B) Join combines two tables horizontally — adding columns from one table to rows in another based on a matching key (e.g., linking Customer ID to Orders). Union stacks rows vertically when tables have the same columns.
C) Joins combine multiple Prep flows; Unions combine columns from the same flow
D) Joins are only for database connections; Unions are only for file-based data
► Show Answer
✓ Correct: B — Join: two tables with different columns, related by a key (Orders JOIN Customers ON CustomerID) — adds customer attributes to each order row. Union: multiple tables with the same structure (January + February + March sales files) — stacks all rows together.
Q9. What is the "Output" step in Tableau Prep Builder?
A) A step that displays the data preview
B) The final step that writes the cleaned, prepared data to a destination: Tableau Data Extract (.hyper), published data source on Tableau Server/Cloud, database table, or CSV file — making it available for Tableau Desktop or other consumers
C) An output log showing flow execution results
D) A step that emails the prepared data to stakeholders
► Show Answer
✓ Correct: B — The Output step defines the destination for Tableau Prep's prepared data. Publishing to Tableau Server/Cloud as a Published Data Source enables multiple Desktop users to connect to the same clean dataset — the recommended enterprise pattern.
Q10. What is the Tableau "Data Guide" feature used for in Tableau Desktop analysis?
A) A printed guide to Tableau's data connection types
B) An AI-powered panel (Tableau Pulse / Ask Data) that automatically surfaces key insights, statistical summaries, outliers, and trends in the current view — helping analysts understand the data more quickly
C) A tutorial guide for new Tableau Desktop users
D) A guide to setting up Tableau Server data sources
► Show Answer
✓ Correct: B — The Data Guide (and related Tableau AI features like Tableau Pulse) automatically surfaces insights about the currently viewed data: statistical summaries, notable outliers, trends, and correlations — augmenting analyst discovery with automated analysis.
Frequently Asked Questions
How hard is the Salesforce Tableau Data Analyst exam?
The Salesforce Tableau Data Analyst exam is considered intermediate to advanced difficulty. Candidates with hands-on Salesforce
project experience typically pass within their first or second attempt. Thorough study of the official exam guide
domains and Trailhead content is strongly recommended before sitting the exam.
What is the passing score for the Salesforce Tableau Data Analyst exam?
The passing score for Salesforce Tableau Data Analyst is 65% (unless otherwise specified on the official Salesforce Trailhead exam page).
Salesforce does not publish which specific questions you passed or failed — only your overall percentage.
How long should I study for the Salesforce Tableau Data Analyst exam?
Most candidates spend 4–8 weeks preparing. Study time depends on your existing Salesforce experience.
Focus on the exam domain weights, complete the relevant Trailhead Trailmix, and practise in a Developer Edition org.
What is the retake policy for Salesforce certification exams?
If you fail a Salesforce exam, you must wait 24 hours before your first retake. After a second failure,
you must wait 14 days for each subsequent attempt. Each retake costs $200 USD (or $100 with a retake voucher).