Tableau Data Analyst Study Guide
The Certifyforce Tableau Data Analyst study guide covers the official Salesforce Tableau Data Analyst exam outline in 30 units across all 4 exam sections, one unit per exam-guide topic. The exam itself has 60 scored questions plus 5 unscored, a 105-minute limit and a 65% passing score, and its largest section is Explore and Analyze Data at 41%. Every unit is verified against official Salesforce documentation, cites its sources, and links to the practice questions that test it. Last updated October 29, 2026.
Focused on analyzing data with Tableau: connecting to and transforming data, calculated fields, table calculations and LOD expressions, filters, parameters, sets, groups, hierarchies and maps, the Analytics pane, building dashboards and stories, and publishing and managing content on Tableau Server and Tableau Cloud.
30 lessons · 4 exam sections · about 4 h of reading ·
Exam sections
Unlock the full guide
Every lesson's summary, exam expectations, key facts and self-check questions are free to read. The Tableau Data Analyst pack unlocks the self-check answers, core concepts, exam traps and worked scenarios, reading progress and personalized “read next”. Add practice exams for the question bank and unlimited timed practice, or choose the bundle.
Connect To and Transform Data
24% of the exam- Connectors for files and relational databases~7 minPick the connector a source needs (Text File, Excel, PDF File, a native database connector or the ODBC fallback), fix delimited files with Text file properties, scan the right PDF pages, and choose Initial SQL or Custom SQL on a relational connection, including parameters and duplicate-column errors.
- Cleaning data with Data Interpreter, pivot and split~8 minName the data quality problem (completeness, consistency, accuracy), then fix it in Tableau Desktop: Data Interpreter and found tables for messy files, Pivot for crosstabs (or custom SQL elsewhere), automatic versus custom split, and Data pane folders.
- Tableau Prep unions, joins and aggregations~7 minPick the Tableau Prep step a business need calls for, then configure it: Union steps and Input-step unions with mismatched fields and type conflicts, Join steps with seven join types and join-clause cleaning, Aggregate steps with grouped versus aggregated fields, and FIXED LOD calculations that keep row detail.
- Field properties, roles, data types and aliases~8 minSet Default Properties once (sort, color, comment, aggregation, format), fix data types and the mixed-value columns Tableau maps from the first rows of a file, rename and reset fields (in bulk in Tableau Prep), choose between discrete and continuous and between dimension and measure in the view or the Data pane, and alias members, including the published data source limits.
- Live connections, extracts and published data sources~7 minDecide between a live connection and an extract (including Tableau Bridge and virtual connections on Tableau Cloud), configure and reopen .hyper extracts safely, connect to published data sources with the right permission, and replace a data source without losing your work.
- Relationships, joins, unions and data source filters~7 minCombine tables in the right layer (relationships and multi-fact models in the logical layer, joins and unions in the physical layer), validate a relationship model for missing or repeated values, and choose between data source filters and extract filters.
- Tableau Prep filters, pivots and output types~7 minPick the Tableau Prep filter that fits the field and the data sample, pivot columns to rows (including wildcard pivots) or rows to columns, and choose the Output step type and write option, including what Prep on the web cannot output.
Explore and Analyze Data
41% of the exam- Date, string and type conversion functions~7 minPick the right date function (DATEDIFF, DATEADD, DATEPART, DATETRUNC) and start_of_week, turn strings into dates with DATE or DATEPARSE, extract tokens with SPLIT and its per-source limits, test substrings with CONTAINS or FIND, and cast with STR, INT and FLOAT.
- Running totals, differences and moving window calculations~7 minApply quick table calculations to measures, then customize running totals (with secondary calculations), Difference and Percent Difference From (Relative to Previous, Next, First, Last), percent of total, moving calculations and WINDOW_ functions, and keep results intact by hiding rather than filtering.
- Dimension, measure and Top N filter settings~8 minConfigure the dimension Filter dialog (General include/exclude, Wildcard, Condition, Top and Bottom N, and how the tabs combine), choose Range of Values, At Least, At Most or Special for measure filters, and set filter card modes, Only Relevant Values, Apply and Include/Exclude options.
- Parameters in calculations, filters and reference lines~8 minCreate a parameter (data type, All, List or Range), tie it to a calculated field, a Top N filter or a reference line or band, expose it with a parameter control or a parameter action, and make its list and current value refresh when the workbook opens.
- Sets, groups, bins and hierarchies~7 minChoose between fixed, dynamic and combined sets and use In/Out mode, edit set membership from the view, size and read bins (and replace them with a FLOOR calculation), build and reorder hierarchies, and group members for corrections and what-if comparisons.
- Symbol, density and filled maps with layers~7 minPick a proportional symbol, density or filled map from the data and the question, tune size, color, opacity, intensity and aggregation so the map does not mislead, and add marks layers with the right order, selection and zoom extent.
- Totals, reference lines, bands and distributions~7 minTurn on grand totals and subtotals and choose between Automatic and two-pass totals, then add reference lines, bands, average lines and distribution bands from the Analytics pane with the right scope, computation and drop target.
- FIXED, INCLUDE, EXCLUDE and nested LOD expressions~7 minWrite FIXED, INCLUDE, EXCLUDE and nested level of detail expressions, predict whether their values are aggregated or replicated in a view, whether they land as dimensions or measures, and which filters they respect.
- Logical, number, aggregate and spatial calculations~8 minWrite IF, CASE and IIF tests that handle nulls the way a requirement asks, pick ROUND, CEILING, FLOOR, DIV or INT (and formatting) for numbers, keep aggregate and row-level values apart, and build points, lines, radius zones and distances with MAKEPOINT, MAKELINE, BUFFER and DISTANCE.
- Rank, index, percentile and table calculation addressing~7 minPick the ranking function or Rank type from how ties and direction must behave, read INDEX, FIRST, LAST and SIZE for any row, and customize a table calculation with Compute Using, Specific Dimensions and Restarting every so it addresses and partitions the view the way the requirement needs.
- Context filters, order of operations and filter scope~8 minTrace Tableau's order of operations from extract filters to table calculation filters, use context filters to make Top N and FIXED results respect another filter, and choose the Apply to Worksheets scope or a cross-data-source relationship that makes one filter reach the right sheets.
- Trend lines and forecasting models~8 minAdd and edit trend lines (model types, factors, per-color lines, stacked-bar limits) and judge them with R-squared and p-values, then add a forecast with default settings, clear the view's forecasting constraints and customize length, source data, model and prediction intervals in Forecast Options.
Create Content
26% of the exam- Building chart types on the Marks card~7 minBuild Gantt charts, box plots, histograms, treemaps, packed bubbles, pie and area charts from scratch by knowing which shelf and Marks card property defines each one, and fix the views that go wrong when a measure lands on the wrong property or stays aggregated.
- Dashboard size, layout containers and floating items~7 minCombine sheets into a dashboard that resizes predictably: pick the size setting for tiled or floating designs, group items in horizontal and vertical layout containers, place and layer floating items with the Layout pane, make sheets transparent, and swap or copy dashboard items without losing work.
- Filter, highlight and URL dashboard actions~7 minDiagnose and configure dashboard filter, highlight and URL actions: keep controlling views unfiltered with Ignore Actions, restrict runs with Single-select only, map differently named fields across data sources, match highlights on dates or chosen fields, and get field values and web pages into URL actions.
- Color, shapes, annotations and tooltips~7 minStyle views precisely: center a diverging palette and pick color effects (borders, halos, markers, opacity), copy worksheet formatting, set default and custom shapes, add Preferences.tps palettes, choose mark, point or area annotations, and fix tooltip asterisks, Include in Tooltip and Viz in Tooltip limits.
- Dual axis, combination charts and sorting~7 minDiagnose dual axis and combo charts (which pill is primary, what Synchronize Axis aligns, which Marks card an encoding lands on) and pick the sort that produces the order a stakeholder asks for: nested or non-nested, toolbar, Manual, Field or case-insensitive.
- Dashboard objects and story points~8 minPick the dashboard object a requirement needs and diagnose blank Image and Web Page objects (HTTPS, scripted SVGs, web view security), then size, format, update and present stories built from story points.
- Set actions, parameter actions, dynamic zones and buttons~7 minBuild Dynamic Zone Visibility on a valid Boolean field or parameter, configure Show/Hide and Navigation buttons, and choose the run and clearing options of set actions and parameter actions, including what breaks them.
- Padding, banding and device-specific layouts~8 minChoose inner or outer padding per side, band and shade rows or columns at the right header level, format grid and zero lines in Desktop or on the web, and keep Desktop, Tablet and Phone layouts in step with the Default dashboard.
Publish and Manage Content on Tableau Server and Tableau Cloud
9% of the exam- Publishing and exporting workbooks, data sources and flows~8 minHow the Publish Workbook and Publish Data Source dialogs handle sheets, tabs, external files and credentials, how Prep Builder flows and their outputs publish to Tableau Server or Tableau Cloud, and which Download format gives a viewer an image, a crosstab or an older-version workbook.
- Scheduling full and incremental extract refreshes~8 minFull versus incremental extract refresh and why incremental must be set up in Desktop before publishing, how refresh schedules are created on Tableau Server and Tableau Cloud, the 7,200-second Cloud timeout, refreshing from Desktop, and who can be given the Refresh Extracts capability.
- Alerts, subscriptions, custom views and permissions~7 minData-driven alerts on continuous axes, subscriptions and their When Data Refreshes rule, saving and sharing custom views, and how site roles cap capabilities while user and group permission rules decide effective access, including web editing and overwriting a workbook.
Common questions about the Tableau Data Analyst study guide
Is the Tableau Data Analyst study guide free?
Partly. Every unit's summary and its "What the exam expects", "Key facts" and "Check yourself" sections are free to read without an account. The "Core concepts", "Exam traps" and "Worked scenario" sections, reading progress and unlimited timed mock exams come with the Tableau Data Analyst pack (USD $19).
How current is the Tableau Data Analyst study guide?
It is written to the current official Salesforce Tableau Data Analyst exam outline, and each unit is checked against Salesforce documentation before it is published. The most recent update was October 29, 2026, and every unit shows its own last-updated date.
How does the study guide map to the official Tableau Data Analyst exam guide?
There is one unit per topic in the official exam guide, grouped under its 4 weighted sections: Connect To and Transform Data (24%), Explore and Analyze Data (41%), Create Content (26%), Publish and Manage Content on Tableau Server and Tableau Cloud (9%). Each unit quotes the exam objective it covers word for word.
How do the practice questions link to the study guide?
Each unit lists the reviewed practice questions that test it (300 questions are linked across the guide), so you can read a topic and practice it in one click. After a practice exam, every missed question links back to the unit that teaches it.