How to Get Ready for the Tableau Data Analyst Certification

If you're newer to data and about to sit the Salesforce Certified Tableau Data Analyst exam, this guide is for you. The certification proves you can take raw data and turn it into insights a business can actually act on, working across the whole Tableau stack — Prep for cleaning data, Desktop for building analysis, and Server/Cloud for sharing it.

The good news: if you've been using Tableau, you already know most of what you need. The exam mostly rewards understanding why Tableau behaves the way it does, rather than memorising trivia. Below I'll walk through how the exam works, what each section covers and why its weighting matters, and the core topics worth understanding before you go in.

How the Exam Works

The exact numbers have shifted a little across recent updates, so always confirm against the official exam guide before you book. Recent sittings have looked like this (as of 31/7/2026):

• Questions: 65 multiple choice. A handful (usually 5) are unscored trial questions that don't count — you won't know which, so treat them all the same.
• Time: 105 minutes. This is comfortable; most people finish with time to spare and can review flagged answers (so did I - I had 40 minutes to revise 15 flagged questions).
• Passing score: 65%.
• Format: multiple choice, and some questions have more than one correct answer, so read carefully.

Two habits that help on the day: flag anything you're unsure of and come back to it — a later question often reminds you of a concept from an earlier one — and when you're stuck, eliminate the answers you know are wrong to improve your odds on what's left.

The Four Sections and What the Percentages Mean

The exam is split into four domains, each with a weighting. The weighting tells you two things: how many questions to expect from that area, and therefore where your study time is best spent. If a section is 41% of the exam, it deserves far more of your revision than one that's 9%.

Connect to and Transform Data — 24% This covers getting data into Tableau and shaping it before analysis: connecting to different data sources, and cleaning messy data in Tableau Prep. The big conceptual piece here is understanding how Tableau combines data — the difference between joins, relationships, and blends, and when each is appropriate. Roughly a quarter of your questions live here, so it's worth solid attention but isn't the main event.

Explore and Analyse Data — 41% This is the largest section by a wide margin, so it should get the largest share of your study. It's the analytical heart of Tableau: creating calculated fields, writing Level of Detail (LOD) expressions, using parameters, building table calculations, and spotting trends. Almost everything people find genuinely challenging on the exam lives in this section — LODs and order of operations especially. If you master this domain, you've done the heavy lifting.

Create Content — 26% This covers turning your analysis into something people can actually use: building dashboards, making them interactive with actions, adding reference lines and bands, and applying good design and layout practices. About a quarter of the exam, and much of it is practical knowledge you'll have picked up from building real dashboards.

Publish and Manage Content on Tableau Server and Tableau Cloud — 9% The smallest section, but don't skip it. It covers publishing workbooks, data sources, and flows; scheduling extract refreshes to keep data fresh; and managing published content through alerts, subscriptions, custom views, and permissions. It's only 9%, but it's the area analysts tend to know least well because they rarely touch the admin side day to day — which means it's the section where a little focused revision earns the easiest marks.

The Main Topics to Understand

Rather than memorising answers, aim to understand these topics well enough to reason through a question you haven't seen before. These are the areas that come up most and reward real understanding.

Order of Operations

This is the single most important concept to internalise, because it quietly explains the behaviour behind many other questions. Tableau doesn't apply your filters and calculations all at once — it applies them in a fixed sequence. In simplified order:

1. Extract filters
2. Data source filters
3. Context filters
4. FIXED LODs
5. Dimension filters
6. INCLUDE and EXCLUDE LODs
7. Measure filters
8. Table calculations

The reason this matters: where something sits in this order determines whether a filter affects it. The classic consequence is that a FIXED LOD is calculated before your dimension filters, so filtering a dimension won't change a FIXED result — unless you promote that filter to a context filter, which runs earlier. Once this sequence clicks, a whole family of "why is the number what it is?" questions becomes intuitive.

Data Source Filters and Extract Filters

These are two different ways of limiting data before it ever reaches your sheets, and they apply at different stages.

• Extract filters run first, at the moment the extract is built. They physically decide what data goes into the extract, so anything filtered out simply isn't there.
• Data source filters apply next, across the entire workbook, before any single sheet does its own filtering.

The concept worth understanding is scope: these filters affect everything downstream, whereas a filter you drop onto one worksheet only affects that sheet. That distinction — global versus sheet-level — is what these questions are really testing.

Level of Detail Expressions (LODs)

LODs are the topic most worth investing in, because they're heavily tested and often the least intuitive when you're new. An LOD lets you compute a value at a different level of granularity than the one shown in your view. There are three:

• FIXED computes a value using only the dimensions you name, ignoring whatever else is in the view. Because it sits above dimension filters in the order of operations, ordinary filters don't change it.
• INCLUDE adds dimensions to the calculation beyond what's in the view — useful when you want to compute at a finer level and then aggregate up.
• EXCLUDE removes dimensions from the calculation, so a value stays constant across the ones you've excluded.

Beyond the three types, get comfortable reading an LOD — including a nested one (an LOD inside another) or one wrapped in an IF or CASE statement — and recognising correct syntax. You don't need to write complex ones under pressure; you need to look at one and understand what level of detail it's computing at.

How Filters Influence LODs in a Workbook

This deserves its own mention because it ties the previous topics together, and it's where understanding beats memorisation. When you look at a workbook containing an LOD, the value it shows depends on two things working together: the grain the LOD is locked to, and where each filter sits in the order of operations.

The rule of thumb: a FIXED expression ignores dimension filters (because it's calculated before them), so its value holds steady even as you filter the view — unless a filter has been added to context. INCLUDE and EXCLUDE expressions, by contrast, do respond to dimension filters, because they're calculated after them. If you can look at a view and reason through which filters affect a given LOD and which don't, you're thinking exactly the way this section wants you to.

Functions: Numeric, String, and Date

Expect questions that check whether you know which function belongs to which data type — the point being that you can't, for example, apply a string operation to a number. You don't need to memorise every function, but you should recognise the main families and what they're for:

• Numeric functions operate on numbers — rounding, absolute values, and similar.
• String functions operate on text — extracting parts of a string, measuring length, checking whether text contains something, splitting or replacing.
• Date functions work with dates — extracting parts of a date, adding to or finding the difference between dates, truncating to a level like month or year, and building dates.

Also be comfortable with CASE and IF logic for building conditional calculations, and with basic date reasoning such as calculating a year-to-date figure.

Dashboard Actions

Actions are what make a dashboard interactive, and they're central to the Create Content section. The main types to understand conceptually:

• Filter actions — selecting a mark on one sheet filters what shows on another.
• Highlight actions — draw attention to related marks without filtering anything out.
• Navigation actions — go to another sheet or an external URL.
• Parameter and set actions — let a user's selection drive a parameter or set dynamically.

The useful thing to grasp is when each fits: filtering narrows data, highlighting emphasises without removing, and navigation moves the user around. Also know that an action can leave a filter applied to a sheet, and how to reset that.

Reference Lines and Bands

These live on the Analytics pane and are dragged onto a view. A reference line marks a single value (like an average or a target); a reference band shades the region between two values. The concept worth knowing is scope — whether the reference applies across the whole Table, within each Pane, or per Cell — because that determines what the line or band is actually measuring against.

Table Calculations

Table calculations compute across the values already in your view, and the key idea is partitioning versus addressing — which dimensions group the calculation, and which direction it runs across. Common ones to understand include running totals, percentage of total (adding across versus down), moving averages, rank, and index. It's also worth knowing the difference between SUM(), which adds within the current partition shown in the view, and TOTAL(), which aggregates across the whole table regardless of the row-level breakdown.

Server / Cloud Management

This is the Publish and Manage section, and even though it's only 9%, the concepts are learnable and the marks are gettable. Focus on:

• Alerts — data-driven alerts email specified people when a value crosses a threshold you set. Know that they're configured on the published view in Cloud/Server, and where to look when one stops working.
• Subscriptions — these email a snapshot (image or PDF) of a view or workbook on a schedule. The distinction to hold onto: an alert is triggered by data crossing a threshold, while a subscription is triggered by a schedule.
• Custom views — saving a version of a view with your own filters and selections applied.
• Extract refreshes — scheduling refreshes to keep published data current, and the difference between a full and an incremental refresh.
• Permissions and roles — a general sense of how site roles, permissions, and licenses combine to decide what a user can do.

Other Topics Worth Knowing

A few more that appear across the exam and are worth a pass:

• Joins, relationships, and blends — how each combines data, and that a data blend uses a left join by default.
• Web Data Connectors — what they are and when you'd reach for one.
• Tableau Prep basics — unioning inputs, pivoting, promoting rows to headers, and working from a flow's output.
• Layout and formatting — recognising floating versus tiled containers, matching container sizes, and controlling what appears when exporting a dashboard.
• Stories and annotations — what they are and how they're set up.

Resources for Preparation

Three resources will take you a long way — one official, one structured study guide, and one for realistic practice exams. Use all three together: learn the material, then test yourself under exam conditions + explore Tableau Dashboard/Prep/Server/Cloud yourself.

1. Trailhead Cert Prep — Review Key Topics (official) trailhead.salesforce.com/content/learn/modules/cert-prep-tableau-data-analyst/review-key-topics-in-the-publish-and-manage-content-section

This is Salesforce's own preparation module, organised section by section. Each unit lists the key topics and their exam weighting, gives you scenario-based practice questions and a "click to reveal" review of the key terms, and links straight to the relevant Tableau Help pages when you get something wrong. The unit linked above covers the Publish and Manage Content section (the Server/Cloud material) — and from there you can reach the units for the other three sections. Start here for the official view of what you need to know.

2. Learning Tableau — Data Analyst Study Guide learningtableau.com/data-analyst-study-guide

A free study guide laid out against the official exam blueprint, objective by objective, across all four domains. Almost every objective links to the relevant Tableau Help documentation and to a short quiz on that specific skill. It's the best resource for making sure you've covered every listed topic — treat it as a checklist and work through anything you're unsure about.

3. Certification Practice — Free Full-Length Practice Exams certificationpractice.com/practice-exams/salesforce-certified-tableau-data-analyst

Free, full-length practice exams that mirror the real format — 65 questions, 105 minutes, 65% pass mark — with several exams' worth of questions and detailed explanations for every answer. You can run them in timed mode to simulate exam day or study mode for instant feedback. This is where you build stamina and get comfortable with the way questions are worded. (It's an independent resource, not officially affiliated with Tableau.)

Final Word

Every topic above earns its place — the exam draws from all four sections, and the questions mix concepts together, so there's no single area you can safely skip. Work through the study guide objective by objective, fill the gaps as you find them, and don't let the small Server/Cloud section slide just because it's only 9%.

The best way to make it stick is to build alongside your reading. Open Tableau, create a few small workbooks, try out an LOD, toggle some filters, set up an action or a reference band, and see what happens. Then use the practice exams to test yourself under real conditions until the phrasing feels familiar and you know where your weak spots are. On the day, read each question slowly and carefully — the wording matters.

You already know more than you think. Trust your preparation, take your time, and you'll walk in ready. Good luck — you've got this.