Ace the Tableau Desktop Specialist Exam: Prep Guide & Tests

Connect data from multiple sources, collate it, draw customizable charts with Tableau, and share a dynamic, interactive dashboard that tells a single story.

Celebrate reaching this milestone in the Ace the Tableau Desktop Specialist Exam: Prep Guide & Tests course. Access resources, Q&A, AI assistant, and your certificate to stay motivated.

Learn about Tableau licenses—creator, explorer, and viewer—and their pricing for online and server, plus free trials and student access with Tableau Public for practice.

Install Tableau Desktop from Tableau Comm and start a 14-day free trial, or sign up for Tableau Public to create visualizations.

Review the customer, product, and sales CSV data and learn how Tableau accepts a long table with one row per transaction and lookup tables to reduce redundancy.

Open Tableau, connect to a text file such as sales.csv, drag the data table onto the canvas to form a live data source, and manage metadata and field types.

Compare live connections and data extracts in Tableau to decide between real-time visualizations and improved performance, noting manual refresh for extracts and the default live setting.

Connect Tableau to an sql data source by entering host, port, database name, and credentials. Explore PostgreSQL and other sql dialects, and drag tables onto the canvas to build relationships.

Learn to connect Tableau to cloud storage services such as Google Drive, Dropbox, and OneDrive. Authenticate your account and fetch CSV data files from cloud sources.

Combine data from multiple tables in Tableau by joining on the customer ID to reveal region-wise sales, and explore joins, blending, relationships, and unions for same-structure tables.

Create relationships in Tableau to connect sales and customer tables by customer ID, using drag and drop to form the relationship line, and compare with joins for simpler data modeling.

Explain cardinality and referential integrity in Tableau by contrasting 1-to-many, many-to-one, and 1-to-1 relationships, and show how matching keys and table order affect performance.

Learn how to create traditional joins in Tableau, compare them with relationships, and understand join types and matching keys across physical and logical layers.

Learn the four types of joins in Tableau: inner, left, right, and full outer joins. See how using the customer ID as a key affects results and null values.

Learn how to union sales data from multiple csv files into a single table for complete visualizations. Explore three methods—specific files, wildcard patterns, and union in the physical layer.

Explain physical and logical layers in Tableau: use joins and unions in the physical layer to create a single table, and define relationships in the logical layer without merging.

Explore the Tableau sheet interface and the data source, menu bar, and toolbar as you learn how dimensions and measures drive visualizations with pills and the show me feature.

Explore the distinction between dimensions and measures in Tableau, explain aggregation by category, and show how numeric vs non-numeric columns become measures or dimensions, with practical examples.

Understand the difference between discrete and continuous variables in Tableau and how finite and infinite values shape axes. Learn to switch between discrete and continuous for dimensions and measures.

Discover how Tableau assigns data types, converts between dimensions and measures, and toggles discrete versus continuous values in the data pane or rows and columns to control default aggregation.

Create a bar chart to show category wise profit by placing categories on the x axis and profit on the y axis, with options to switch to horizontal bars.

Create a line chart to visualize the trend of sales over time by placing date on columns and sales on rows, with aggregations by year, quarter, or month.

Create a scatter plot to explore the relationship between two numerical variables, such as sales and profit, switching measures to dimensions and using the marks card to compare subcategories.

Explore how the marks card formats any Tableau chart by controlling color, size, labels, and tooltips, and switch between bars, lines, areas, and shapes.

Learn to create category-specific lines on a Tableau line chart by dropping dimensions into color, and build dual line charts with sales and profit using separate marks cards.

Drag and drop dimensions onto marks in a scatter plot to show profit and sales by subcategory; use color, shape, and size to encode segments and order count as bubbles.

Learn to visualize numerical data in Tableau with text tables, heat maps, and highlight tables, using cross tabulation and the sum of sales across categories and regions.

Learn to create pie charts in Tableau, size by sum of sales, show category contribution as percent of total, add labels, and compare regional results.

Learn to draw and interpret area charts in Tableau, including stacking categories, switching between continuous and discrete styles, and reading overall trends plus category contributions.

Learn how treemaps visualize hierarchical data by displaying data as rectangles whose area and color reflect sales, with category and subcategory levels preserved to show relative contributions.

Create dual combination charts in Tableau by plotting two measures with different marks on primary and secondary axes. Synchronize axes or keep them separate and label the secondary axis clearly.

Learn to bin continuous numeric data in Tableau by creating age group bins, adjusting bin size, and using the new age groups for analysis and visualization.

Create and visualize histograms in Tableau by binning a measure, adjusting bin width, and interpreting the distribution with counts per age group.

Group similar dimensions in Tableau to create custom categories, such as premium and non-premium shipping, rename groups, and visualize the sum of sales by the new type of shipping field.

Learn how to filter data in Tableau using keep only and exclude, the filter shelf, and dimension, measure, and date filters to show only relevant results.

Learn to configure a dimension filter in Tableau by selecting subcategories, using general options, and applying wildcard, conditions, and top settings to show subcategories by sum of sales.

Configure measure filters in Tableau by selecting a sales measure, choosing an aggregation, and applying range, at least, at most, or special options to charts.

Learn to use date-time filters in Tableau, including relative dates and range of dates on the order date, enabling dynamic charts and flexible major or dimension filtering.

Explore Tableau filter options, including date time formats, show filter visuals, and context filters, and learn how to apply to worksheets and the order of execution across related data sources.

Learn the five Tableau filter types—extract, data source, context, dimension, and measure—and how their order of operation affects results and performance, including promoting to context.

Explore customizing visual filters in Tableau, adjusting appearance, filter types, and options such as show filter, relevant values, all values in hierarchy, and include or exclude values to enhance dashboards.

Explore how to sort Tableau visualizations by axis, field, or manual methods, including ascending or descending orders, sum of sales, data source order, and nested sorts across panes.