Looking for exam strategy before you start practising? Read our Tableau Data Analyst exam tips and 4-week study plan.
Free practice • No sign-up required
Independent study resource
Exam objectives and policies can change. Confirm current details with the certification issuer.
Check current objectives
Use the official exam guide as the source for current objectives and section weights.
Practice for learning
Use sample questions to review concepts and identify topics for further study.
Works on Any Device
Full practice experience on phone, tablet, or desktop
Free, No Sign-Up
Start practicing immediately, no account or email required
Tableau Certified Data Analyst – Complete 2026 Guide
This exam tests practical analysis in Tableau: connecting and preparing data, writing calculations including level of detail expressions, choosing the right chart, and building dashboards that answer a business question. The exam is 60 scored questions in 105 minutes, with a 65% pass mark, weighted towards Explore and Analyze Data (41%) and Create Content (26%).
| Official exam name and code | Tableau Certified Data Analyst (Tableau Data Analyst) |
|---|---|
| Questions | 60 |
| Time allotted | 105 min |
| Passing score | 65% |
| Exam fee | $250 |
| Retake fee | $100 |
| Prerequisite certifications | No prerequisite listed in this guide |
| Study guide release | Summer '26 |
Tableau Certified Data Analyst Exam Weightage by Section
1. Connect To and Transform Data (24%)
24%2. Explore and Analyze Data (41%)
41%3. Create Content (26%)
26%4. Publish and Manage Content on Tableau Server and Tableau Cloud (9%)
9%Exam Topics
Last updated:
Who is the Tableau Data Analyst exam for?
- BI analysts: You build dashboards people rely on and want a credential that proves the skill.
- Data analysts: You answer business questions with data and use Tableau as your main tool.
- Self-service analytics users: You already build views for your own team and want to go deeper than the basics.
Exam Fees & Registration
Exam Fee
$200
One-time registration fee
Retake Fee
$100
If you need to retake the exam
Comparing certs? View all Salesforce exam fees in one place →
Certification Validity
Maintenance and renewal requirements vary. Check the issuer’s current credential page for requirements that apply to you.
How to Register
Check current Tableau Certified Data Analyst credential and registration details with the issuer.
View official credential detailsOfficial references: Use the issuer’s current materials to confirm exam objectives, format, and fees before booking.
Official sources: Exam guide·Salesforce exam pricing·Independent exam-prep resource; details may change.
Exam Tips
- 1Data Connection/Prep and Calculations are 50%. Know LOD and table calcs.
- 2Visualization and Dashboards are 35%. Build various chart types and dashboards.
- 3Understand dimensions vs measures and the shelf (Rows, Columns, Marks).
- 4Practice building a dashboard with filters and actions.
Prerequisites
- •Tableau Desktop experience
- •Data analysis basics
Focus Areas
- •Data Connection and Prep
- •Calculations and LOD
- •Visualization and Dashboards
- •Analysis and Insights
Study Strategy
Use Tableau Desktop with sample data.
Build 5+ chart types, use LOD expressions, and create a dashboard with interactivity.
Align with the exam outline.
Exam Format and First-Attempt Readiness
The Tableau Certified Data Analyst exam has 60 questions in 105 min, passing score 65%. Most Salesforce exams test scenario-based decisions. Focus on when to use each feature, not just terms.
- Study Explore and Analyze Data and Create Content first, together they carry 67% of the exam.
- Do timed question sets. Build pacing and confidence.
- Review why wrong answers are wrong. It improves scenario reasoning.
- Book the exam once your mock scores are steady at 75%+.
Is the Tableau Data Analyst Exam Hard?
Is the Tableau Data Analyst Exam Hard?
This is a step up from Desktop Foundations. It tests whether you can actually get an answer out of data: calculations that work at the right level of detail, filters applied in the right order, and charts that suit the question being asked.
- 60 questions in 105 minutes.
- 65% to pass, about 39 correct answers out of 60. Confirm it in the official exam guide before you book.
- Level of detail expressions are the hard part. FIXED, INCLUDE and EXCLUDE come up repeatedly.
- Hands-on matters. Reading about calculations is not enough. You need to have been surprised by one and worked out why.
Pass Rate Guidance
You are ready when you can explain why a FIXED calculation ignores a filter, and when a table calculation is the better choice. Aim for 75% or more on practice tests, and build the examples yourself rather than reading them.
Tableau Data Analyst Exam Format Explained
Tableau Data Analyst Exam Format Explained
You can take the exam online with a proctor or at a test centre. Here is what to expect:
Total Questions
60 scored questions
Time Limit
105 min
Passing Score
65%
Question Type
Multiple-choice & multiple-select
How Many Questions Are Scenario-Based?
Most questions pose a business question and ask which chart, calculation or filter answers it, or show a result that looks wrong and ask why.
Best Way to Pass on Your First Attempt
- Learn the order of operations: Knowing when each filter type is applied explains most surprising numbers in Tableau.
- Practise level of detail expressions: FIXED ignores the view's dimensions, INCLUDE adds one, EXCLUDE removes one.
- Know calculations from table calculations: One works on the source data, the other on what is already in the view.
- Use parameters: Let the viewer switch a measure, a threshold or a date range without editing the workbook.
Tableau Data Analyst: Key Concepts
Level of Detail Expressions
Normally a calculation works at whatever level the view shows. Level of detail (LOD) expressions let you break that rule. FIXED computes at the dimensions you name and ignores the ones in the view, so `{FIXED [Customer]: SUM([Sales])}` gives each customer's total even in a view broken down by month. INCLUDE adds a dimension that is not in the view, which is how you average a value computed at a finer grain. EXCLUDE removes a dimension that is in the view, which is how you compare a row against its category total. The common exam trap is that FIXED is computed before dimension filters, so a FIXED total can ignore a filter unless that filter is promoted to a context filter.
Order of Operations and Filter Types
Tableau applies filters in a fixed order, and knowing it explains most unexpected numbers. Extract filters come first, then data source filters, then context filters, then dimension filters, then measure filters, and table calculation filters last. FIXED expressions are computed after context filters but before dimension filters, which is why making a filter a context filter changes a FIXED result. A Top N filter is also affected: it is applied after context, so putting a dimension filter into context changes which members reach the Top N. When a question shows a number that looks wrong, the answer is usually somewhere in this order.
Calculations and Table Calculations
A regular calculated field works on the underlying rows before aggregation. A table calculation works on the data already in the view, which is why running totals, percent of total, rank, difference and moving average are table calculations. Table calculations depend on how they are addressed and partitioned: which direction they compute along and which group they restart in. Getting that wrong gives a running total that resets in the wrong place. Use a regular calculation when the logic belongs to the data, and a table calculation when it depends on what is displayed.
Parameters, Sets and Groups
A parameter is a value the viewer chooses, such as a sales threshold or which measure to show, and it can be used in calculations, filters and titles. Parameters do not filter on their own: you use them in a calculated field, then filter on that field. A set is a saved selection of members, which can be fixed or computed by a rule, and sets can be combined to compare groups. A group combines members into one, such as rolling small categories into Other. Bins turn a continuous measure into ranges for a histogram. Knowing which of these to reach for is a frequent exam question.
Connections, Performance and Dashboards
A live connection queries the source each time, while an extract copies data into Tableau's fast format and can be filtered or aggregated to keep it small. Extracts help with slow sources and allow offline work, at the cost of being as current as the last refresh. For performance, reduce the data before it reaches the view, avoid very wide crosstabs, and limit the number of filters shown on a dashboard. For dashboards, use actions so a selection in one sheet filters or highlights another, choose a layout that works at the size people will actually view it, and keep each dashboard focused on one question.
Every Tableau project follows the same five stages, this pipeline structure underlies most Data Analyst exam scenarios about calculated fields, joins, and dashboard actions.
How to Pass the Tableau Data Analyst Exam
Most questions give you a business question or a surprising number. Work out the level the calculation should run at, and where the filters sit in the order of operations.
Choosing a Chart
Comparison across categories: bar. Change over time: line. Relationship between two measures: scatter. Part of a whole, used sparingly: pie or treemap.
LOD Expressions
FIXED ignores the view's dimensions, INCLUDE adds one, EXCLUDE removes one. FIXED is computed before dimension filters.
Filter Order
Extract, data source, context, dimension, measure, then table calculation filters. Promote a filter to context when a FIXED value must respect it.
Dashboard Interactivity
Filter and highlight actions connect sheets. Parameters let viewers change a measure or threshold without editing anything.
Performance
Use an extract for slow sources, filter and aggregate it at creation, and keep views focused rather than enormous.
Is the Tableau Certified Data Analyst Exam Hard?
DifficultyModerate; plan about 4-8 weeks of focused prep.
Book When ReadyScore 75%+ on three timed mocks before scheduling.
Use Practice, Not DumpsOriginal practice questions build skill without risking your credential.
Exam format: 60 questions, 105 min, 65% passing score.
Tableau Certified Data Analyst Practice Questions (With Explanations)
Test your knowledge with these 15 sample questions.
Question 1: What is the primary focus of a Salesforce Certified Tableau Data Analyst?
Key takeaway: Tableau Data Analysts analyze data and build actionable insights using Tableau for visualization and exploration.
Show correct answer and explanation
Correct answer: D. Analyzing data and building actionable insights using Tableau
Tableau Data Analysts analyze data and build actionable insights using Tableau for visualization and exploration.
- 'Only creating charts' undersells the role, which spans full data analysis and insight-building, not just chart creation.
- Managing Salesforce CRM is unrelated to the Tableau Data Analyst's analytics-focused role.
- Marketing campaigns are unrelated to the Tableau Data Analyst's analytics-focused role.
Question 2: Which Tableau capability is central to the Data Analyst role?
Key takeaway: Data Analysts use data connection, preparation, calculations, and visualization to deliver analysis.
Show correct answer and explanation
Correct answer: C. Data connection, preparation, calculation, and visualization for analysis
Data Analysts use data connection, preparation, calculations, and visualization to deliver analysis.
- Server administration alone is a narrower technical skill, not the core Data Analyst focus.
- 'Only formatting' undersells the role, which spans the full data workflow from connection to visualization.
- License management is an administrative task, unrelated to the Data Analyst's analytical role.
Question 3: What does a FIXED LOD expression compute in Tableau?
Key takeaway: FIXED LOD expressions compute a value at the declared dimension granularity regardless of what dimensions are on the Rows/Columns shelves.
Show correct answer and explanation
Correct answer: B. An aggregate at a specified dimension level, independent of the dimensions placed in the view
FIXED LOD expressions compute a value at the declared dimension granularity regardless of what dimensions are on the Rows/Columns shelves.
- This describes a regular aggregate filtered by view dimensions, the opposite of FIXED, which ignores view dimensions.
- A cross-database join is a data-connection concept, unrelated to LOD expressions.
- A running total is a table calculation concept, not what FIXED LOD computes.
Question 4: When should you add a Context Filter in Tableau?
Key takeaway: Without a context filter, Tableau computes Top N across all data first, then applies other filters.
Show correct answer and explanation
Correct answer: A. When a Top N or condition filter needs to run on a pre-filtered data subset rather than the full dataset
Without a context filter, Tableau computes Top N across all data first, then applies other filters. Context filters reverse that order.
- Context filters don't affect chart color formatting, that's unrelated to their function.
- Context filters aren't about connecting to live data sources, that's a separate data connection setting.
- Context filters aren't specifically for creating dual-axis charts, that's an unrelated visualization feature.
Question 5: What is the main difference between a Live connection and an Extract in Tableau?
Key takeaway: Live connections deliver fresh data on every view load; Extracts trade real-time currency for faster query performance.
Show correct answer and explanation
Correct answer: B. Live connections query the data source in real time; Extracts are cached .hyper snapshots that are faster but need scheduled refresh
Live connections deliver fresh data on every view load; Extracts trade real-time currency for faster query performance.
- Accuracy isn't the differentiator, both connection types can be accurate; the difference is real-time versus cached/refreshed data.
- Live connections can absolutely be used on dashboards, this option denies a real capability.
- Extracts work with many data source types, not just Excel files.
Question 6: What is a Tableau Parameter?
Key takeaway: Parameters accept user input at runtime, combine them with calculated fields or filters to create interactive, dynamic views.
Show correct answer and explanation
Correct answer: B. A dynamic, user-controlled input value that can replace a constant in a calculation, filter, or reference line
Parameters accept user input at runtime, combine them with calculated fields or filters to create interactive, dynamic views.
- A Parameter doesn't automatically remove rows, that's a filter's function, not a parameter's.
- A Parameter isn't a data source connection setting, it's an input control used within calculations/filters.
- A Parameter isn't a dashboard layout option, that's an unrelated dashboard configuration concept.
Question 7: How is data blending different from a join in Tableau?
Key takeaway: Blending is useful when data lives in two different source systems and a database-level join is not possible: Tableau aggregates each source separately and combines results.
Show correct answer and explanation
Correct answer: A. Blending links two separate data sources at the view level on a common dimension; joining combines tables within the same data source at query time
Blending is useful when data lives in two different source systems and a database-level join is not possible: Tableau aggregates each source separately and combines results.
- Blending doesn't create a new permanent combined data source, it links at the view level, not permanently.
- There is a real, meaningful difference between blending and joining, this option denies it.
- Blending isn't always faster than joining, performance depends on the specific scenario, not a fixed rule.
Question 8: Which chart type best shows the distribution of a continuous measure across bins?
Key takeaway: A histogram groups continuous data into defined intervals (bins) and shows frequency, the standard chart for distribution analysis.
Show correct answer and explanation
Correct answer: C. Histogram
A histogram groups continuous data into defined intervals (bins) and shows frequency, the standard chart for distribution analysis.
- A pie chart shows part-to-whole composition, not distribution across bins.
- A Gantt chart shows timeline/duration data, not distribution of a continuous measure.
- A treemap shows hierarchical proportions, not the binned distribution a histogram specifically shows.
Question 9: What does an INCLUDE LOD expression do that FIXED does not?
Key takeaway: INCLUDE takes the view's dimensions and adds more, useful for computing per-member averages while the view aggregates at a higher level.
Show correct answer and explanation
Correct answer: C. INCLUDE adds specified dimensions to the view's level of detail before aggregating, computing at a finer granularity than the view alone
INCLUDE takes the view's dimensions and adds more, useful for computing per-member averages while the view aggregates at a higher level.
- INCLUDE isn't limited to date dimensions, it works with any dimension type.
- INCLUDE doesn't ignore filters, that's a mischaracterization of its actual behavior.
- INCLUDE doesn't create a table calculation, it's a distinct LOD expression type.
Question 10: What is a Filter Action in a Tableau dashboard?
Key takeaway: Filter actions allow users to click a mark and drill into filtered views, a core interactivity pattern in Tableau dashboards.
Show correct answer and explanation
Correct answer: A. An interactive action that passes selected marks as a filter to one or more target worksheets or dashboards
Filter actions allow users to click a mark and drill into filtered views, a core interactivity pattern in Tableau dashboards.
- A context filter applies within a single worksheet, it isn't the cross-worksheet interactive action being described.
- A server-side filter applied automatically to all worksheets describes a data source filter, not the interactive Filter Action being asked about.
- A data source filter excluding nulls is a different, static filtering mechanism, not an interactive dashboard action.
Question 11: How is a table calculation different from a regular aggregated measure in Tableau?
Key takeaway: Table calculations (RUNNING_SUM, WINDOW_AVG, RANK, etc.
Show correct answer and explanation
Correct answer: B. Table calculations run on the aggregated data already returned to the view, not on the underlying database rows
Table calculations (RUNNING_SUM, WINDOW_AVG, RANK, etc.) operate on the result set in the view, not on source rows.
- Table calculations absolutely can be used with date/time fields, this option denies a real capability.
- Table calculations don't run on the database, they run on data already returned to Tableau, the opposite of this claim.
- Table calculations aren't inherently faster than database aggregations, that's not the defining characteristic.
Question 12: A user needs to compare year-over-year sales in a single view. Which Tableau approach is most appropriate?
Key takeaway: Percent difference table calculations or FIXED LOD expressions with year dimensions are the standard Tableau patterns for period-over-period comparison.
Show correct answer and explanation
Correct answer: D. Use a table calculation with percent difference from LOOKUP, or a FIXED LOD expression with a year dimension
Percent difference table calculations or FIXED LOD expressions with year dimensions are the standard Tableau patterns for period-over-period comparison.
- Creating separate worksheets per year doesn't allow direct comparison within a single unified view.
- Manually exporting to Excel defeats the purpose of using Tableau's built-in calculation capabilities.
- A separate context filter per year doesn't enable the year-over-year comparison calculation itself.
Question 13: How do you create a dual-axis chart in Tableau?
Key takeaway: Dual Axis overlays two measures on independent axes in the same chart, right-click the second measure pill to enable it.
Show correct answer and explanation
Correct answer: A. Right-click the second measure pill on the Rows or Columns shelf and select Dual Axis, then synchronize axes if needed
Dual Axis overlays two measures on independent axes in the same chart, right-click the second measure pill to enable it.
- Blending a second data source and overlaying sheets isn't the standard dual-axis creation method.
- Dragging two dimensions onto Rows doesn't create a dual-axis chart, that's unrelated to the dual-axis mechanism.
- Manually overlaying chart types via the Marks card isn't how dual-axis charts are actually created in Tableau.
Question 14: Which role in a Tableau deployment is responsible for certifying published data sources?
Key takeaway: Certification is applied by Data Stewards or admins to published data sources, signalling to consumers that the data is authoritative and maintained.
Show correct answer and explanation
Correct answer: D. Data Steward or content-certifying admin
Certification is applied by Data Stewards or admins to published data sources, signalling to consumers that the data is authoritative and maintained.
- A Viewer license user has read-only access, they don't have the ability to certify data sources.
- Tableau Desktop Specialist is an entry-level certification, not a role responsible for certifying data sources.
- Server hardware administration is an infrastructure role, unrelated to data source certification, which is a governance/content role.
Question 15: What does a FIXED LOD expression compute?
Key takeaway: FIXED LOD computes at the dimension level you specify, ignoring filters and dimensions in the view (except context filters).
Show correct answer and explanation
Correct answer: C. An aggregate at a specified dimension level, independent of the view
FIXED LOD computes at the dimension level you specify, ignoring filters and dimensions in the view (except context filters).
- 'Only table calculations' misattributes FIXED LOD's function to a different Tableau feature.
- 'Only percentages' misattributes FIXED LOD's function to a specific calculation type it isn't limited to.
- 'Only running totals' misattributes FIXED LOD's function to a different calculation type.
Get the Full Question Bank
Most candidates book the exam after scoring 75%+ on full mocks.
If you’re planning to test this quarter, aim to complete full mocks at least 10–14 days before your exam date.
Contact us for more information on our full 60-question mock exams and a personalized study plan. Use the contact form.
Request Mock Exams & Study PlanTableau Certified Data Analyst Exam FAQs
- What is covered on the Tableau Certified Data Analyst exam?
- This page shows the section-wise exam weightage so you know exactly which topics carry the most weight. Use the exam topics and practice questions above to align your study with the official outline.
- What is Tableau Data Analyst?
- Tableau Data Analyst validates skills in analyzing data, creating calculations, building visualizations, and designing dashboards using Tableau Desktop.
- What's the difference between Tableau Desktop Foundations and Data Analyst?
- Desktop Foundations is entry-level covering basics. Data Analyst is intermediate-level covering advanced calculations, LOD expressions, and complex visualizations.
- What is the passing score and exam fee for the Salesforce Certified Tableau Data Analyst?
- The Tableau Data Analyst exam has 60 questions, 105 minutes, and a passing score of 65%. The exam fee is $200 USD (retake $100 USD). No formal prerequisite, though Salesforce recommends Tableau Desktop experience and real-world data analysis practice before attempting.
- What topics are covered in the Tableau Data Analyst exam?
- The exam covers: connecting to and preparing data (live vs extract, data types, joins, blending), data analysis (LOD expressions, table calculations, parameters, sets), visualisation design (chart selection, formatting, filters, context filters), dashboards and stories (actions, layout, performance), and sharing and collaboration (publishing, permissions, Tableau Server/Cloud). LOD expressions and table calculations are the highest-difficulty topics.
Next Tableau Certifications
Good next steps after Tableau Data Analyst:
Honest Cert Breakdown
Difficulty: Moderate
3/5Tableau Desktop, charts, calculations, LOD expressions, and dashboard design. Requires real Tableau hands-on time. The LOD expressions are the hardest part.
Salary Range
$88,000–$122,000 / year
US average for certified professionals • Updated Summer '26 • Source: Salesforce Talent Ecosystem
Is it worth it?
Good for analysts and BI professionals. Tableau remains widely used outside Salesforce too, the skill transfers broadly.
Exam Sections & Weightings
What Each Section Tests
Explore & Analyze Data
Calculated fields (string, date, number, logical), Level of Detail (LOD) expressions (FIXED, INCLUDE, EXCLUDE), table calculations (running total, percent of total, moving average), reference lines, trend lines, and statistical summaries.
Create Charts & Dashboards
Chart type selection for different data relationships (bar, line, scatter, map, heat map, treemap, bullet chart). Dashboard layouts, actions (filter, highlight, URL), device designer, and storytelling with Story Points.
Connect to & Transform Data
Connecting to data sources (Excel, CSV, databases, Salesforce, Google Sheets). Data interpreter, pivoting data, splitting fields, data types, joins vs unions vs relationships. Tableau Prep Builder basics for data cleaning.
Publish & Share Content
Publishing workbooks and data sources to Tableau Cloud/Server. Permissions management, subscriptions, data-driven alerts, embedding dashboards, and maintaining published content.
Analytics Framework
Analytics workflow: define business question → identify data → build views → validate insights → share findings. Data literacy concepts, analytics best practices, and visualisation design principles.
8-Week Study Plan
Scenario Strategy Tips
- 1.LOD selection framework: Need a calculation independent of view filters? Use FIXED. Need to include an additional dimension in the calculation? Use INCLUDE. Need to exclude a dimension from the calculation? Use EXCLUDE. Work through the business scenario step by step, what level should the calculation run at vs what the view shows.
- 2.Chart type for the data: Comparison → bar chart. Trend over time → line chart. Correlation between two measures → scatter plot. Part-to-whole → pie chart (small categories only) or treemap. Geographic distribution → map. Distribution → histogram or box plot. Know which chart type makes sense for each data relationship.
- 3.Joins vs Relationships: Relationships are the default and preferred, they maintain granularity and support multiple fact tables. Use joins only when you need explicit column combinations or are connecting to published data sources. Unions stack rows (same structure, additional records). Most exam scenarios should lead you to Relationships.
- 4.Dashboard action types: Filter action narrows other sheets based on selection. Highlight action keeps all marks but highlights selected. URL action opens a web page. Set action adds marks to a set. Know which action achieves which interaction when a user clicks on a chart.
Mock Exam Benchmark
Aim for 75%+ on practice exams given the 65% passing score. Explore & Analyze Data (28%) and Create Charts & Dashboards (25%) together account for 53% of the exam. Master LOD expressions before test day, they appear in multiple questions and cannot be guessed confidently without genuine understanding.
Top 10 Concepts to Review
- LOD expressions: FIXED, INCLUDE, EXCLUDE, when and why to use each
- Table calculations: running total, percent of total, difference from, moving average
- Calculated fields: aggregate vs row-level, null handling with ZN() and IFNULL()
- Chart type selection for each data relationship (comparison, trend, correlation, distribution)
- Joins vs unions vs relationships, data model design choices
- Dashboard actions: filter, highlight, URL, Set, Parameter actions
- Context filters, filter order of operations: extract → data source → context → dimension → measure
- Tableau Prep Builder, cleaning, shaping, and outputting data for analysis
- Publishing to Tableau Cloud: workbook vs data source publishing, permissions, subscriptions
- Sets: fixed sets vs computed sets, set actions for dynamic filtering
Frequently Asked Questions
- What is the Tableau Certified Data Analyst certification?
- The Tableau Certified Data Analyst certification validates skills in connecting to data, building interactive visualisations and dashboards, applying calculated fields and LOD expressions, and publishing content to Tableau Cloud/Server. The exam has 60 questions, 105 minutes, a 65% passing score (higher than most Salesforce exams), and a $250 fee. A Tableau Desktop Foundations or Desktop Specialist certification is a recommended (not required) prerequisite.
- What are LOD expressions in Tableau and why are they important?
- Level of Detail (LOD) expressions control the granularity at which calculations are computed, independent of the view level of detail. FIXED computes at a specified dimension regardless of what is in the view. INCLUDE adds dimensions to the view level. EXCLUDE removes dimensions from the view level. LOD expressions are one of the most commonly tested and most misunderstood areas in the exam, understanding when to use FIXED vs a regular aggregation is critical.
- What is the passing score for the Tableau Data Analyst exam?
- The Tableau Certified Data Analyst requires a 65% passing score, significantly higher than the 65% required for most Salesforce certifications. With 60 questions, this means you need to answer approximately 41+ questions correctly. Plan for a more demanding exam than typical Salesforce credentials and aim for 75%+ on practice exams before scheduling.
- What is the difference between joins, unions, and relationships in Tableau?
- Joins combine columns from two tables into a single, flat table (LEFT, RIGHT, INNER, FULL OUTER). Unions combine rows from two tables with the same structure (stacking records). Relationships are the default data modelling approach in Tableau, they create flexible, context-aware connections between tables without pre-joining, preserving granularity for each table. Relationships are preferred for most use cases; joins are used when you need explicit column-level combination.
- How long should I study for the Tableau Data Analyst exam?
- Plan for 8–10 weeks with 10–15 hours per week. Tableau Desktop hands-on practice is essential, the exam presents data scenarios and asks which visualisation or calculation approach to use. Download Tableau Public (free) or get a Tableau trial, and build 15–20 real dashboards across different chart types and data sources. LOD expressions require specific practice; they are logical but counterintuitive until you have worked through many examples.
What Comes After This Certification?
After this certification, consider: Tableau Consultant, Tableau Data Analyst, or Tableau Desktop Foundations.
Topic Difficulty Heatmap
Which topics are a gimme vs which ones trap confident candidates. Use this to prioritise your final-week revision. These are our own topic groupings for study planning, not the official exam sections, those and their weightings are in the credential's exam guide.
| Topic | Difficulty | Study Tip |
|---|---|---|
| Data Connection and Prep | Moderate | Data sources and preparation. Know the data model. |
| Calculations and LOD | Trap ⚠ | LOD expressions and calculation types, frequently tested. |
| Visualization and Dashboards | Moderate | Viz and dashboard design, standard topics. |
| Analysis and Insights | Easy | Analysis techniques, straightforward. |
Difficulty based on analysis of common candidate errors across each exam section.
Ready to Practice?
Test yourself with free Tableau Data Analyst practice questions covering all 5 exam sections.
Start Free Practice QuestionsQuick Answer: Best Way to Pass Tableau Data Analyst
- The exam has 60 questions in 105 minutes. Passing score is approximately 65%. Aim for 75%+ on full mocks before booking.
- LOD expressions (FIXED, INCLUDE, EXCLUDE) and table calculations appear frequently, understand the difference between them clearly.
- Build real dashboards in Tableau Desktop (free trial or Tableau Public). The exam rewards practical familiarity with the UI.
- Context filters and filter order are a common trap. Know when a Top N filter needs a context filter and why.
4-Week Tableau Data Analyst Study Plan
Week 1: Data Connection & Preparation, live vs extract connections, data source filters, joins vs blending, unions, pivoting, and data types. Know when to use extract (.hyper) for performance vs live for real-time data.
Week 2: Calculations & LOD Expressions, basic calculated fields, date functions, string functions, IF/IIF/CASE logic. Then LOD: FIXED (ignores view dimensions), INCLUDE (adds granularity), EXCLUDE (removes granularity). Table calculations (RUNNING_SUM, WINDOW_AVG, RANK, LAST) run on the result set, not the database.
Week 3: Visualization Design & Dashboards, chart selection (bar, line, scatter, histogram, treemap, Gantt), dual-axis charts, parameters and parameter actions, filter actions, highlight actions, URL actions, dashboard layout and device targeting.
Week 4: Context filters, advanced analysis (reference lines, trend lines, forecasting), stories, and full mock exams targeting 75%+. Revise LOD and context filter scenarios specifically before booking.
How to Handle Tableau Data Analyst Scenario Questions
The exam presents analysis scenarios and asks which Tableau feature, calculation type, or configuration is most appropriate. The most common traps are confusing LOD types and misunderstanding filter order.
- LOD questions: Use FIXED when you need an aggregate at a declared dimension regardless of the view (e.g., revenue per customer across any view). Use INCLUDE when you need finer granularity than the view (e.g., average order size per customer when the view shows totals). Use EXCLUDE when you need coarser granularity (e.g., national average on a regional view).
- Context filter questions: Without context, Top N runs across all data before other filters apply. Add a filter to context when you need Top N to run on an already-filtered subset. Filter order: extract → data source → context → dimension → measure.
- Table calc vs LOD questions: Table calculations operate on data already in the view, they cannot change which rows are returned. LOD expressions run at query time and affect which rows come back. Use table calcs for running totals, percent of total, and period-over-period comparisons within existing results.
- Parameter questions: Parameters are user-controlled variables (slider, dropdown, etc.); they do not filter data by themselves. Always pair a parameter with a calculated field or reference line to make it dynamic. Parameter Actions (Tableau 2019.2+) allow clicking a mark to set a parameter value.
- Live vs extract: Choose live when data must be current in real time. Choose extract when performance is priority and a scheduled refresh cadence is acceptable. Extracts can be filtered at creation time to reduce size.
Readiness Check Before You Book
Use this minimum benchmark before scheduling your Tableau Data Analyst exam:
75%+ on 3 timed full mocks (60 questions / 105 minutes each)
The official passing score is approximately 65%. Targeting 75%+ on mocks gives you a 10-point buffer that accounts for unfamiliar LOD or table calculation scenarios on exam day.
3 Concepts That Fail Most Tableau Data Analyst Candidates
These are not the hardest topics; they are the ones where candidates are most confidently wrong. Learn the distinction early.
1. Dimensions vs Measures: Blue vs Green Pills Affect How Data Is Aggregated
Dimensions are categorical fields (name, region, date, shown as blue pills) that slice data. Measures are numerical fields (sales, count, profit, shown as green pills) that are aggregated. Dragging a dimension to the Rows shelf creates headers. Dragging a measure creates an axis. Candidates put Measures on Rows without understanding that Tableau will aggregate them. Know that converting a measure to a Discrete dimension creates header rows, not an axis.
2. LOD Expressions: FIXED vs INCLUDE vs EXCLUDE
FIXED calculates a value at a specified dimension level regardless of what is in the view. INCLUDE adds dimensions to the calculation beyond what is in the view. EXCLUDE removes dimensions from the calculation. Candidates use FIXED for all LOD calculations, the exam tests which LOD expression to use: computing revenue per customer independent of view filters = FIXED; computing average per sub-category when only category is in the view = INCLUDE.
3. Filters Order of Operations: Data Source Filters Run First, Table Calculations Last
Tableau applies filters in this order: Extract → Data Source → Context → Sets → Dimension Filters → Measure Filters → Table Calculations. A Measure Filter applied before aggregation behaves differently than one applied after. Candidates apply Measure Filters expecting them to remove rows before aggregation: Measure Filters run after aggregation by default and filter out aggregated results, not individual rows.
Common Questions
- What is the Tableau Data Analyst exam format?
- The Salesforce Certified Tableau Data Analyst exam has 60 questions, a 75-minute time limit, a 65% passing score, and a $250 fee.
- What are the highest-weight Tableau Data Analyst exam topics?
- Explore and Analyze Data (41%) is by far the largest section, followed by Create Content (26%) and Connect To and Transform Data (24%). Publish and Manage Content is only 9%. Hands-on Tableau Desktop skills are tested throughout.
- How hard is the Tableau Data Analyst exam?
- Moderately difficult. The exam tests practical Tableau Desktop skills, not just theory. Candidates who build dashboards with real datasets consistently outperform those who study only documentation.
- What is the best way to prepare for the Tableau Data Analyst exam?
- Practice with real datasets, master LOD expressions and context filters, and take timed practice tests. The free Tableau Public app and Tableau's sample superstore dataset are useful for hands-on prep.
- What concepts do most Tableau Data Analyst candidates get wrong?
- The most commonly misunderstood topics for the Tableau Data Analyst exam are: (1) Dimensions vs Measures: Blue vs Green Pills Affect How Data Is Aggregated; (2) LOD Expressions: FIXED vs INCLUDE vs EXCLUDE; (3) Filters Order of Operations: Data Source Filters Run First, Table Calculations Last. Candidates are most confidently wrong on these. Learn the distinctions early to avoid losing marks on questions you expect to get right.
- Why do most Tableau Data Analyst candidates fail questions about Dimensions vs Measures?
- Dimensions are categorical fields (name, region, date, shown as blue pills) that slice data. Measures are numerical fields (sales, count, profit, shown as green pills) that are aggregated. Dragging a dimension to the Rows shelf creates headers. Dragging a measure creates an axis. Candidates put Measures on Rows without understanding that Tableau will aggregate them. Know that converting a me...
- Why do most Tableau Data Analyst candidates fail questions about LOD Expressions?
- FIXED calculates a value at a specified dimension level regardless of what is in the view. INCLUDE adds dimensions to the calculation beyond what is in the view. EXCLUDE removes dimensions from the calculation. Candidates use FIXED for all LOD calculations, the exam tests which LOD expression to use: computing revenue per customer independent of view filters = FIXED; computing average per sub-...
- Why do most Tableau Data Analyst candidates fail questions about Filters Order of Operations?
- Tableau applies filters in this order: Extract → Data Source → Context → Sets → Dimension Filters → Measure Filters → Table Calculations. A Measure Filter applied before aggregation behaves differently than one applied after. Candidates apply Measure Filters expecting them to remove rows before aggregation: Measure Filters run after aggregation by default and filter out aggregated results, not...
How It Compares
- → Tableau Data Analyst full study guide
Next Step
Apply these tips with real Tableau Data Analyst practice questions:
After this exam, consider Tableau Consultant or Tableau Data Analyst next.
Share or cite this study guide
Free to link from a forum post, study repo or article. Copy the Markdown and paste it anywhere.