Tableau Exam Prep: Desktop Foundations + Data Analyst

Install Tableau Public for free by signing up at Tableau Public. Tableau Public connects only to flat files and saves workbooks to the public server.

Visit public tableau.com, enter your email to download Tableau Public for Mac, then double-click the DMG to install with default settings. Explore the Windows installation guide in the next section.

Install Tableau Public on Windows by downloading from Tableau Public, running the executable, and accepting default settings. Use the desktop workspace and public online space to save and share workbooks.

Learn how to download and install Tableau Desktop, start a 14-day free trial via Tableau Creator, then switch to a paid subscription, or use Tableau Public for free functionality.

Explore the three levels of Tableau desktop certification. Foundations and data analyst are most common; foundations cost $75 and require less upkeep, with yearly maintenance on Salesforce Trailhead.

Compare exam structures across desktop foundations, data analyst, and consultant levels on the Salesforce Trailhead platform. Note time limits, question formats, and scoring, plus unscored items and maintenance costs.

Outline the skills measured for Tableau desktop foundations and data analyst exams, detailing categories such as connecting to data, exploring data, creating content, and publishing on server.

Follow proctor-enforced Tableau exam rules, including photo ID, pre- and during-exam checks, closing programs and Chrome, clearing your desk, covering external monitors, and staying alone with no talking.

Review your Tableau exam results, including date, time, id, pass or fail, and overall score against the benchmark, with category breakdowns; credentials transfer to Trailhead if on Pearson Vue.

Develop exam success through hands-on practice in Tableau Desktop and daily study. Follow exam rules, use Tableau Help, skip hard questions, and build rhythm before connecting to data section.

Discover how to connect to data in Tableau using data source interfaces, connection types, transforms, modeling, extracts, joins, unions, and data blending.

Explore Tableau Desktop data connection types, linking to local files like Excel and CSV or servers such as Oracle and Redshift, with ODBC fallback.

Use the data interpreter to clean poorly formatted Excel and CSV files with a single click. Results show what’s kept or removed, and you can undo changes in Tableau Desktop.

Learn to transform data in Tableau with field and value operations: rename, hide, group, alias, and calculated fields. Pivot and split reshape data while managing field types and geographic roles.

Compare live connections and extracts in Tableau Desktop and Tableau Server, balancing performance, data freshness, and offline access. Learn how extracts boost speed, enable offline work, and support large data sets.

Explore Tableau Desktop extract options, including logical vs physical tables, filters, aggregation, and row options like all rows and incremental, and learn to apply extract changes for exam readiness.

Learn how Tableau Desktop combines data with relationships, joins, unions, and blending to optimize performance and reduce mis aggregation, duplication, and incorrect values.

Explore Tableau's data model with the logical and physical layers, and how relationships, joins, and unions shape data modeling.

Explore the logical and physical layers in Tableau Desktop, where logical tables stay independent until activated and physical tables merge into a single flat table with joins and keys.

Explore unions and joins in Tableau Desktop, implemented in the physical layer to combine data. Learn how unions stack tables and joins add columns, with wildcard unions and performance considerations.

Blend data from multiple sources in Tableau at the sheet level by defining primary and secondary sources, mapping fields, and creating blended calculations like actual versus goal.

Explore the difference between dimensions and measures in Tableau, including qualitative vs quantitative fields, drag-and-drop conversions, default aggregations, and how fields are organized by tables in the data pane.

Explore discrete and continuous fields in Tableau Desktop, seeing how discrete dimensions appear blue and continuous measures appear green, with dates offering flexible analysis.

Explore Tableau generated fields, including measure values and measure names, and apply count of table and latitude/longitude generated fields to build geospatial and text table views.

Line charts reveal trends using time-based variables and measures. In Tableau Desktop, build a line chart by selecting transaction date, spend, and category, using a continuous line and date grain.

Learn how scatter plots visualize relationships between variables using at least two measures and optional dimensions, with Tableau Desktop to create easy-to-interpret views and highlight data points.

Explore cross tabs, or text tables, in Tableau Desktop to display numerical values using measures and dimensions; learn benefits, limitations, and tips for clearer, performant visualizations.

Highlight tables use color overlays to call out key data points and compare categorical data; they require at least one measure and one or more dimensions, demonstrated in Tableau Desktop.

Create a dual axis visualization in Tableau Desktop to compare transaction counts this year and last year, aligning axes for readability and actionable insights.

Explore histograms in Tableau Desktop to visualize the distribution of a single measure using automatically created bins, with adjustable bin size and equal distribution, and note limitations across dimensions.

Create heatmaps in Tableau Desktop to compare categorical data using color, size, marks, and shapes with 1–2 measures; apply tips and build a heatmap from bank maven data.

Visualize hierarchical data or parts of a whole with treemaps in Tableau Desktop by selecting measures and dimensions, exploring benefits and limitations, and applying a simple diverging color palette.

Discover how bullet graphs compare actual values to targets in a compact visualization, and learn to create one in Tableau Desktop using multiple measures and dimensions.

Discover how Tableau auto-selects chart types based on field placement on rows and columns, with innermost positions driving bars or lines, and learn to manipulate marks on a new sheet.

Explore marks card properties in Tableau to control color, size, labels, detail, tooltip, shape, and line; apply palettes, opacity, borders, and custom colors in a hands-on scatter plot.

Explore marks card properties to control level of detail, tooltips, and shapes, and learn how dimensions determine granularity and how tooltips and shapes enhance visual analysis.

Learn to add descriptive titles and captions in Tableau desktop, customize text, color, and font, and ensure consistency across sheets to create dynamic, interpretable visualizations.

Explore mapping and analytics in Tableau, including geospatial data, map layers, custom maps, and the analytics pane, while applying regression forecasting and cluster analysis for predictive insights.

Discover geospatial data in Tableau by using geographic fields and spatial files, assign geographic roles, auto generate lat/long, and build maps from shapefiles and geometry fields.

Explore how to customize map layers in Tableau Desktop, adjusting background styles from Mapbox and OpenStreetMap and toggling data layers such as coastline and census data.

Create custom territories by grouping geographic fields with Tableau's traditional grouping to dynamically select or consolidate areas, producing polygons that can be layered with city or state data.

Learn to fix unknown locations by editing locations or entering latitude and longitude, and ensure zip codes are stored as strings to prevent ambiguities and avoid null island.

Explore the analytics pane in Tableau Desktop by dragging reference lines, totals, forecast clusters, and box plots. Apply average lines at table, pane, or cell level.

Explore regression models in Tableau with trend lines that relate a dependent variable to one or more independent variables, including linear, logarithmic, exponential, polynomial, and power types.

Apply trend lines in Tableau to reveal the prevailing direction of your data, using R-squared and P-value to assess model accuracy.

Learn to create and customize control charts in Tableau using reference bands set to three standard deviations, flagging special cause variation and outliers for fraud detection in spending patterns.

Explore calculated fields to create new data source fields for segmentation, conversion, aggregation, filtering, and metric calculations. Learn basic, level of detail, and table calculations with syntax.

Explore Tableau calculation syntax and how calculations are structured, revealing six parts—comments, parameters, operators, literals, fields, and functions—and how to create calculated fields.

Create calculated fields in Tableau from the data pane or the view. Drag temporary calculations into the dimensions and measures pane to materialize them as permanent fields.

Identify the three aggregation types in Tableau Desktop - row level, dynamic, and level of detail calculations - and learn how they behave with the view.

Explore common calculation functions in Tableau, including aggregate, string, logical, date, and type conversion, to create fields and control data granularity with detail expressions like include, exclude, and fixed.

Explore aggregate functions in Tableau Desktop (sum, average, max, min, count, count distinct) and create calculated fields such as average charge amount and median credit limit, displayed in a table.

Explore string functions in Tableau Desktop, including contains, length, replace, split, trim, and upper and lower, to transform text in calculated fields while preserving original data.

Explore Tableau date functions to create, modify, and calculate date time fields, including date diff, date add, date name, and date trunk, with an example of time to clear.

Learn addressing and partitioning for Tableau Desktop table calculations by controlling direction and level. Apply to fields like spend subcategory and transaction date to rank data accordingly.

Explore level of detail expressions in Tableau to control calculation granularity, position in Tableau order of operations, and supersede filters, shaping grain, isolation, and use cases like cohort analysis.

Learn to use level of detail expressions in Tableau to control granularity with exclude, include, and fixed lods, and apply table-scoped and percent-of-total calculations.

Create and use parameters in Tableau Desktop to drive dynamic metrics. Build a metric swap parameter, a calculated field using a case statement, and swap values to update visuals.

Practice examining and filtering techniques—sorting, grouping, hierarchies, and highlighting—to uncover patterns, trends, and outliers using static or dynamic sets and drilldown capabilities.

Create and use sets in Tableau to segment data with constant and computed sets, set actions, and practical examples like top five by spend and outliers.

Explore the filter shelf to manage sheet, workbook, or data source filters using right-click to show filters, drag fields, or keep only and exclude options.

Learn how context filters elevate dimensional filters to control order of operations, enabling top end filters by region or city while improving performance with apply buttons and relevant values.

Explore continuous and discrete date filters in Tableau desktop, including relative dates last 3 years and range filters with start and end sliders; apply to multiple sheets and handle nulls.

Set default field properties in Tableau to save time by applying standard aggregation and number formats across workbooks, via right-click access and sheet-specific overrides for credit limit and attrition rate.

Apply data highlighter in Tableau to call attention to points affecting your view; right-click a field to show the highlighter, hover to inspect, and keep highlights in a scatter plot.

Enable viz animations in Tableau to add transitions to dashboards and visualizations, adjustable at dashboard or sheet level with options for fast to slow duration and simultaneous or sequential styles.

Explore dashboards and stories, mastering layouts, objects, formatting, and actions using device designer tools, and learn how to design device-specific dashboards and embed dynamic actions for interactivity.

Explore Tableau dashboard sizing options, including fixed size with device designer, automatic sizing, and range, to optimize caching, consistency, and dynamic display across devices.

Learn how to position dashboard sheets using tiled and floating layouts in Tableau, and blend them with containers for precise, responsive dashboards across mobile and desktop.

Master Tableau dashboard objects: containers, text boxes, images, web pages, extensions, and navigation and download buttons, organized with grid layouts, even spacing, and floating elements.

Learn to create filter actions that let end users filter dashboards by selecting visuals, using the 'use as filter' option or the actions menu, with source sheets and target filters.

Create narratives in Tableau Desktop by sequencing story points with captions and annotations to freeze moments, add context, and share presentations.

Share dashboards securely across Tableau Server, Tableau Public, local workbooks, and exports. Explore Twb and Twb file types, permissions, and export options to PDF, PowerPoint, image, Excel, and CSV.

Examine Tableau's platform by mapping user roles and products, noting access to desktop, prep, and server, with server included in all roles and prep for creators.

Explore how Tableau Server and Tableau Online connect to data, create visualizations, and share insights, with differences in hosting, data source integration via Tableau Bridge, and workbook publishing.

Publish a workbook to Tableau Server or Tableau Online from Tableau Desktop, configure project, name, description, tags, permissions, and authentication, and enable automated data refresh.

Learn to schedule data extract refreshes on Tableau Server, choosing between full and incremental refreshes, and set a daily schedule (for example, 9:30 a.m. on Monday, Wednesday, Friday).

Create and configure email subscriptions in Tableau Server, selecting recipients, format (image or PDF), and schedules that deliver dashboards on a defined cadence.