Cert++
  1. Home
  3. Tableau Desktop Foundations

Tableau Desktop Foundations

Checklist progressProgress

0/258Learned

Tableau Desktop Foundations Study Checklist
  • Platform Administrator
  • Platform App Builder
  • Platform Foundations
  • Platform Developer
  • Platform Administrator II
  • Agentforce Sales Consultant
  • Agentforce Service Consultant
  • Platform Data Architect
  • Platform Development Lifecycle and Deployment Architect
  • Platform Identity and Access Management Architect
  • Platform Integration Architect
  • Platform Sharing and Visibility Architect
  • Heroku Architect
  • B2C Solution Architect
  • Experience Cloud Consultant
  • Agentforce Field Service and Operations Consultant
  • Agentforce Nonprofit Consultant
  • Data 360 Consultant
  • Omnistudio Consultant
  • CRM Analytics and Einstein Discovery Consultant
  • Platform User Experience Designer
  • Platform Strategy Designer
  • B2C Commerce Developer
  • JavaScript Developer
  • Omnistudio Developer
  • Platform Developer II
  • Marketing Cloud Engagement Administrator
  • Marketing Cloud Engagement Specialist
  • Marketing Cloud Engagement Consultant
  • Marketing Cloud Account Engagement Specialist
  • Marketing Cloud Next Consultant
  • Agentforce Sales Foundations
  • Business Analyst
  • Marketing Cloud Engagement Developer
  • Marketing Cloud Engagement Foundations
  • Agentforce Specialist
  • Agentforce Life Sciences Consultant
  • B2B Commerce Administrator AP
  • B2B Commerce Developer AP
  • Agentforce Communications AP
  • Agentforce Consumer Goods AP
  • Agentforce Financial Services AP
  • Agentforce Health AP
  • Agentforce Manufacturing AP
  • Public Sector Solutions AP
  • Revenue Cloud Consultant
  • MuleSoft Integration Foundations
  • MuleSoft Developer
  • MuleSoft Developer II
  • MuleSoft Platform Integration Architect
  • MuleSoft Platform Architect
  • Tableau Desktop Foundations
  • Tableau Data Analyst
  • Tableau Consultant
  • Tableau Server Administrator
  • Tableau Next Consultant
  • Tableau Architect
  • Slack Administrator
  • Slack Consultant
  • Slack Developer

Checklist progressProgress

0/258Learned

  • Kinds of data and connectors available in Tableau Desktop
  • Connect pane options on the Tableau Desktop Start page
  • Connecting Tableau Desktop to an Excel or text file
  • Connecting to a database server with To a Server
  • Data Source page layout after connecting to data
  • Live connection setting on the Data Source page
  • Refreshing a live connection after the underlying data changes
  • Live connection versus extract: data access and freshness
  • Benefits an extract adds over a live connection
  • When to use a live connection versus an extract
  • Creating an extract from the Data Source page
  • Extract filters and row limits in the Extract Data dialog
  • Aggregating extract data and rolling up dates
  • Hidden fields and extract size
  • Full versus incremental extract refresh
  • Contents of a Tableau data source (.tds) file
  • Data source (.tds) versus packaged data source (.tdsx)
  • Saving a data source with Add to Saved Data Sources
  • Reconnecting to a saved data source and its default location
  • Adding connections to a data source for cross-database joins
  • Relating tables from different connections in the logical layer
  • Creating a relationship between tables on the Data Source page
  • Relationship field pairs and compound relationships
  • Root table role and removing tables from a relationship model
  • Requirements and unsupported cases for relationships
  • Creating a join on the physical-layer join canvas
  • Join types and the rows each one returns
  • Join clauses: matching fields, operators and multiple conditions
  • Join field data types and common join issues
  • Union versus join for combining tables
  • Creating a union: manual union versus wildcard union
  • Logical layer versus physical layer of the Tableau data model
  • Relationships versus joins: defining characteristics
  • How Tableau queries related tables during analysis
  • Combining tables at different levels of detail: relationship versus join
  • When to choose a join instead of a relationship
  • Ways to rename a field in Tableau Desktop
  • Scope and persistence of a renamed field
  • Restoring a field's original data source name
  • Creating and clearing aliases for dimension members
  • Field types eligible for aliases and when the Aliases option is unavailable
  • Built-in geographic role types and the location data each fits
  • Assigning a geographic role to a field in Tableau Desktop
  • Geocoding, generated Latitude and Longitude fields and the map view
  • Unrecognized or ambiguous locations and custom geocoding
  • Data type icons in the Data pane
  • Where to change a field's data type in Tableau Desktop
  • Correcting a data type that Tableau misinterprets
  • Numeric IDs and postal codes: changing data type versus converting to a dimension
  • Default Properties menu location and options by field type
  • Setting the default aggregation for a measure
  • Default number format versus formatting a single pill
  • Default date format and data source date properties
  • Default color and shape encodings for dimension values
  • Default sort order for a categorical field
  • Default comments on data fields
  • Dimension and measure shelf placement for vertical versus horizontal bars
  • Automatic Bar mark type and the Marks card mark type drop-down
  • Starting a view with Show Me and other build methods
  • When to use a bar chart and bar chart design practices
  • When a line chart fits the analysis question
  • Building a line chart from a date field and a measure
  • Starting a line chart with Show Me
  • When a scatterplot fits the analysis question
  • Measure placement on Rows and Columns for a scatterplot
  • Adding dimensions to the Marks card in a scatterplot
  • Disaggregating measures to plot individual rows in a scatterplot
  • Trend lines on a scatterplot
  • Building a map view from a geographic field
  • Encoding measures with size and color on a map
  • Creating a filled (choropleth) map with the Map mark type
  • Choosing between a proportional symbol map and a filled map
  • Building a combined axis by dropping a measure onto an existing axis
  • Measure Names and Measure Values in a combined axis view
  • Separate axes versus a shared axis for multiple measures
  • Combined axis versus dual axis for comparing two measures
  • Methods for creating a dual axis chart in Tableau Desktop
  • Per-measure Marks cards and mixed mark types in a dual axis view
  • Synchronizing the axes of a dual axis chart
  • Field arrangement for a stacked bar versus side-by-side bars
  • Stack Marks setting for bars versus lines
  • When to use a density map and what density marks show
  • Building a density map from latitude and longitude data
  • Density map color, intensity and size settings on the Marks card
  • Building a crosstab (text table) in Tableau Desktop
  • Duplicating a worksheet as a crosstab
  • Building a highlight table with the Square mark and Color
  • Highlight table color options and turning it into a heat map
  • Creating a group by selecting marks in the view
  • Creating a group by selecting headers in the view
  • Creating a group from a field in the Data pane
  • Editing members and names in an existing group field
  • Include 'Other' option for non-grouped members
  • When to use a group versus a set
  • Creating a fixed set from selected marks or headers
  • Creating a dynamic set from a dimension in the Data pane
  • Fixed sets versus dynamic sets
  • Showing a set as In/Out versus listing its members
  • Adding or removing marks from an existing set
  • Combining two sets into a combined set
  • Creating and editing a custom hierarchy in the Data pane
  • Drilling down and up through hierarchy levels in a view
  • Automatic date hierarchies and drilling through date levels
  • Hierarchies versus groups, folders and combined fields for related dimensions
  • Keep Only and Exclude filtering from selected marks or headers
  • Filter dialog tabs for dimension filters
  • Filtering a measure from the Filters shelf
  • Showing a filter card and choosing its mode
  • Top and bottom N filters on a dimension
  • Combined effect of settings across Filter dialog tabs
  • Date Filter Field dialog versus dimension and measure filter dialogs
  • Discrete date part filters versus individual date filters
  • Range of dates, starting date and ending date filters
  • Relative date filters for always-current views
  • Computed sort versus manual sort
  • Sort icons on axes, headers, and field labels
  • Toolbar ascending and descending sort buttons
  • Ways to create a manual sort in a view
  • Sort dialog options and sorting by a field not in the view
  • Nested versus non-nested sorts across panes
  • Clearing sorts and hiding sort controls
  • Adding a reference line from the Analytics pane
  • Reference line scope: table, pane, and cell
  • Choosing the value and aggregation for a reference line
  • Reference line labels, tooltips, and line formatting
  • Reference lines versus bands, distributions, and box plots
  • Applying a quick table calculation from a measure pill
  • Quick table calculation types available in Tableau Desktop
  • Choosing a quick table calculation for an analysis question
  • Quick table calculation defaults, Edit Table Calculation and Compute Using
  • Creating a binned dimension from a numeric measure
  • Setting and editing bin size in the Create Bins dialog
  • Binned field behavior and bin labels in the view
  • Building a histogram with Show Me
  • Building a histogram manually from a binned dimension
  • Histograms versus bar charts for showing distributions
  • Reasons to create a calculated field
  • Creating a calculated field and Calculation Editor basics
  • Calculated field indicators and dimension or measure placement in the Data pane
  • Simple arithmetic calculated fields from existing measures
  • String calculated fields and common string functions
  • Date calculated fields and common date functions
  • Row-level versus aggregate calculations
  • Editing a calculated field and its effect on existing views
  • Parameters as workbook variables in Tableau Desktop
  • Parameter data types and allowable values
  • Parameter controls and other ways to change a parameter value
  • Parameters in calculated fields for what-if thresholds
  • Parameters in Top N filters
  • Parameter-driven reference lines and bands
  • When a parameter fits better than a filter or set
  • Adding row and column grand totals from the Analytics pane
  • View requirements for displaying grand totals
  • Subtotals versus grand totals in a view with nested dimensions
  • Repositioning totals to the left or top of the view
  • Automatic totals versus Total All Using aggregation
  • Single mark color and color effects from the Color button
  • Discrete versus continuous fields on Color
  • Edit Colors for categorical and quantitative palettes
  • Workbook-level versus worksheet-level font formatting
  • Worksheet-level font formatting with the Format Font pane
  • Fonts for a single field, field label or control card
  • Fonts in worksheet titles, captions, and tooltips
  • Mark label font settings on the Marks card
  • Shape mark type on the Marks card
  • Encoding a dimension on Shape and editing shape assignments
  • Workbook default versus selected sheet animation settings
  • Simultaneous versus sequential animation styles
  • View changes that trigger viz animations
  • Replaying an animation from the toolbar
  • Resetting animation settings versus disabling animations entirely
  • Marks card Size slider and its effect on different mark types
  • Discrete versus continuous fields on the Size property
  • Edit Sizes dialog for adjusting size distribution
  • Legends generated by Color, Shape, and Size encoding
  • Hiding and restoring legend cards on worksheets and dashboards
  • Worksheets versus dashboards versus stories in a workbook
  • Creating a dashboard and adding worksheets from the Sheets list
  • Replacing a dashboard sheet with Swap Sheets
  • Showing a filter card to consumers on a worksheet or dashboard
  • Applying one filter card to several worksheets on a dashboard
  • Use as Filter option on a dashboard sheet
  • Turning on the data highlighter for a field
  • Data highlighter behaviour across dashboard worksheets
  • Editing tooltip content with static and dynamic text
  • Tooltip command buttons and selection by category
  • Viz in Tooltip
  • Navigation and Download objects on a dashboard
  • Dashboard action types and what each does
  • Creating a filter action with source and target sheets
  • Run action on trigger options for dashboard actions
  • Filter action behavior when the selection is cleared
  • Filter actions versus highlight actions in a dashboard
  • Inserting field values into a URL action
  • Displaying a parameter control on a dashboard
  • Parameter controls versus change parameter actions
  • Fixed size versus Range versus Automatic dashboard sizing
  • Tiled versus floating dashboard items
  • Horizontal and vertical layout containers
  • Positioning, sizing, and ordering items with the Layout pane
  • Text, Image, Web Page and Blank dashboard objects
  • Default dashboard versus device layouts
  • Device Preview and adding device layouts
  • Size settings for a custom device layout
  • Auto-generated versus manually edited phone layouts
  • Publishing device-specific dashboards and which layout a viewer sees
  • Dashboard layout and design best practices
  • Stories and story points in Tableau Desktop
  • Creating a new story and adding a sheet to a story point
  • Blank versus Duplicate versus Save as New for the next story point
  • Story toolbar actions for updating, reverting and deleting a story point
  • Connection between a story point and its original sheet
  • Story size and fitting a dashboard to a story
  • Story navigator layout and Format Story options
  • Best practices for building an effective Tableau story
  • Tableau file types used for sharing work
  • Creating a packaged workbook for recipients without data access
  • Copying versus exporting a view as an image
  • Printing sheets or a workbook to PDF
  • Publishing a workbook to Tableau Server from Tableau Desktop
  • Publish Workbook dialog options for sheets and data
  • Choosing a sharing method for a given audience
  • Opening View Data from marks, the Analysis menu, the Data pane, and the Data Source page
  • Summary data versus underlying row-level data in the View Data window
  • Exporting underlying data to CSV from View Data and the Data Source page
  • Exporting view data from the Worksheet menu and which shelf fields it includes
  • Exporting or copying a view as a crosstab for Excel
  • Export as PowerPoint workflow in Tableau Desktop
  • Contents and interactivity of an exported PowerPoint presentation
  • Exporting a story and its story points to PowerPoint
  • Dashboard sizing and Page Setup options for PowerPoint output

4.1.1 Explain what kind of information dimensions usually contain

0/2

  • Kind of information dimensions typically contain
  • Default dimension and measure assignment in the Data pane

4.1.2 Explain what kind of information measures usually contain

0/2

  • Quantitative information that measures typically contain
  • Numeric fields that hold categorical rather than quantitative information

4.1.3 Explain the difference between dimensions and measures

0/4

  • Dimensions versus measures in how they shape a view
  • Recognizing a measure pill versus a dimension pill
  • Dimension and measure roles versus discrete and continuous field types
  • Converting a measure to a dimension in the view versus the Data pane

4.2.1 Explain how discrete fields are displayed

0/2

  • Headers, labels, panes and blue pills of discrete fields
  • Converting between discrete and continuous on a shelf versus in the Data pane

4.2.2 Explain how continuous fields are displayed

0/4

  • Axes created by continuous fields on Rows and Columns
  • Data types and roles that can be continuous
  • Discrete versus continuous fields on Color and other Marks card properties
  • View changes when a pill is switched between discrete and continuous

4.2.3 Explain the difference between discrete date parts and continuous date values

0/5

  • Discrete date parts versus continuous date values
  • View structure from a discrete versus a continuous date pill
  • Default discrete date and default date level in the view
  • Choosing a date level from a date pill's context menu
  • Drilling into a discrete date field from year to quarter

4.3.1 Explain the default aggregation for measures

0/5

Automatic aggregation of a measure added to the view

Learn this concept
Unseen

Predefined aggregations and the results they return

Learn this concept
Unseen

Setting a default aggregation versus changing it on a pill

Learn this concept
Unseen

Choosing a fitting aggregation when the default sum is misleading

Learn this concept
Unseen

Aggregated versus disaggregated views with the Aggregate Measures setting

Learn this concept
Unseen

4.3.2 Describe how an aggregated measure changes when dimensions are added to a view

0/3

  • Aggregated measure values after adding a dimension to the view
  • Shelves and Marks card properties that set a view's level of detail
  • Counting the marks in a view as dimensions are added

Prepare for the Exam

Play Today's Certle

Study Community

Ask questions and get the latest info from other Tableau Desktop Foundations studiers. 670 members and growing.

Go to Discord
  1. Tableau Desktop Foundations Checklist
  3. Understanding Tableau Concepts

Automatic aggregation of a measure added to the view

Explainer

Learn More

Practice Question

Studying for this exam?

This is one of 258 concepts on the Salesforce Tableau Desktop Foundations exam.

Looking for practice exams? Click below to try one!

Keep going

Next conceptPredefined aggregations and the results they return

Checklist progress

0/258 (0%)

0 of 258 concepts learned

Tip: You can filter concepts by status.

Prepare for the Exam

Play Today's Certle

Study Community

Ask questions and get the latest info from other Tableau Desktop Foundations studiers. 670 members and growing.

Go to Discord
Close
  1. Tableau Desktop Foundations Checklist
  3. Understanding Tableau Concepts
Automatic aggregation of a measure added to the view

Explainer

Learn More

Practice Question

Studying for this exam?

This is one of 258 concepts on the Salesforce Tableau Desktop Foundations exam.

Looking for practice exams? Click below to try one!

Keep going

Next conceptPredefined aggregations and the results they return

Explainer

A measure is a field that usually holds numbers you can measure, such as Sales or Profit. When you add a measure to the view in Tableau Desktop, Tableau automatically aggregates it, which means it combines many row values into one value per mark, such as SUM(Sales). This gives you a summary instead of raw rows, but you still need to check that the aggregation Tableau picked fits your data.
Core information
  • Tableau gives each field a role. Dimensions group or segment the data, and measures are aggregated. When you drag a measure into the view, Tableau applies an aggregation to it by default.
More details and nuances
  • The automatic aggregation is not always meaningful, so always check it and change it if needed. For example, SUM of Age added survey participants' ages up to 420,085 years, which isn't meaningful, while Average or Median gives realistic ages. The type of aggregation applied can also vary with the context of the view.

Explainer

A measure is a field that usually holds numbers you can measure, such as Sales or Profit. When you add a measure to the view in Tableau Desktop, Tableau automatically aggregates it, which means it combines many row values into one value per mark, such as SUM(Sales). This gives you a summary instead of raw rows, but you still need to check that the aggregation Tableau picked fits your data.
Core information
  • Tableau gives each field a role. Dimensions group or segment the data, and measures are aggregated. When you drag a measure into the view, Tableau applies an aggregation to it by default.
More details and nuances
  • The automatic aggregation is not always meaningful, so always check it and change it if needed. For example, SUM of Age added survey participants' ages up to 420,085 years, which isn't meaningful, while Average or Median gives realistic ages. The type of aggregation applied can also vary with the context of the view.