Study guide
2.3 Data Types, Geographic Roles, Aliases & Default Properties
Tableau Desktop Specialist Exam
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Introduction & Exam Overview
1.1 Exam Logistics, Format & Preparation Strategy 1.2 Tableau Workspace & Interface Mechanics
2 Chapter 2: Connecting to & Preparing Data
2.1 Data Connections & File Formats 2.2 Data Relationships, Joins, Unions & Data Interpreter 2.3 Data Types, Geographic Roles, Aliases & Default Properties
3 Chapter 3: Exploring & Analyzing Data
3.1 Dimensions, Measures, Discrete vs Continuous & Aggregations 3.2 Building Visualization Types & Show Me 3.3 Calculated Fields, Logical Functions & Parameters 3.4 Quick Table Calculations & Analytics Tools 3.5 Filters, Order of Operations, Groups, Bins & Sets
4 Chapter 4: Sharing Insights & Dashboard Design
4.1 Dashboard Layout Containers, Tiled vs Floating Objects 4.2 Dashboard Actions & Interactivity 4.3 Formatting, Tooltips & Visual Best Practices 4.4 Stories, Exporting & Publishing
5 Chapter 5: Core Tableau Concepts & Advanced Mechanics
5.1 Deep Dive: Tableau Order of Operations 5.2 View Granularity, Aggregations & Measure Names/Values 5.3 Tableau File Types, Extracts & Data Refresh Workflows
2.3 Data Types, Geographic Roles, Aliases & Default Properties
Key Takeaways Explain This Topic AI
Tableau automatically assigns data types upon import (Text, Date, Numeric, Geographic, Boolean), which can be overridden in the Data Source tab or Data Pane.
Geographic Roles map dimensions to spatial coordinates, generating implicit Latitude (Generated) and Longitude (Generated) fields for mapping views.
Aliases rename dimension member display labels without altering raw underlying data source values, but CANNOT be applied to measures, continuous fields, dates, or booleans.
Default Properties allow analysts to set global rules for fields—such as default aggregations, number formatting, color palettes, and sort order—ensuring consistent formatting across all worksheets.
Blue fields represent Discrete data (headers/categories), while Green fields represent Continuous data (axes/ranges); this distinction is independent of whether a field is a Dimension or a Measure.
Last updated: July 2026
2.3 Data Types, Geographic Roles, Aliases & Default Properties
Once data is connected and modeled, analysts must configure field metadata within Tableau Desktop. Setting accurate Data Types , assigning Geographic Roles , defining Field Aliases , and establishing Default Properties (such as number formatting and default aggregations) ensures that visualizations render correctly and behave predictably across worksheets.
Tableau Data Types & Auto-Detection
When Tableau connects to a data source, it automatically inspects the first few hundred rows of each column and assigns a specific Data Type . Data type icons are displayed next to field names in the Data Source page and the Data Pane.
- Data Type Icon Example Values Notes
- Text (String) #Abc "North" , "Category A" Alphanumeric text strings
- Date Calendar Icon 2026-05-01 Triggers date hierarchies (Year, Quarter, Month)
- Date & Time Calendar + Clock 2026-05-01 14:30:00 Full timestamp data
- Numerical (Decimal) #.# 105.75 , 0.045 Floating point numbers
- Numerical (Whole) # 42 , 1000 Integer values
- Boolean T|F True , False Logical binary flags
- Geographic Role Globe Icon "California" , "90210" Enables spatial map rendering
- Changing Data Types
If Tableau misinterprets a column (for example, reading a numerical Zip_Code column as a Whole Number # instead of a Geographic String #Abc ), you can change it by:
Clicking the Data Type Icon directly above the column in the Data Source tab or next to the field in the Data Pane.
Selecting the correct data type from the context menu.
EXAM CAUTION : Treating zip codes or phone numbers as measures (numbers) causes Tableau to attempt to sum ( SUM(Zip_Code) ), producing meaningless numbers. Always convert identification numbers and postal codes to discrete dimensions or geographic roles.
Dimensions vs. Measures & Discrete vs. Continuous
Tableau categorizes every field along two independent axes:
Dimensions vs. Measures :
Dimensions contain qualitative, categorical data (e.g., Customer Name, Region, Product Category). Dimensions slice and dice data, creating headers in views.
Measures contain quantitative, numerical values that can be aggregated mathematically (e.g., Sales, Profit, Quantity). Measures create axes in views.
Discrete (Blue) vs. Continuous (Green) :
Discrete (Blue) fields create distinct headers and column labels.
Continuous (Green) fields create unbroken axes and continuous color gradients.
Geographic Roles & Spatial Mapping
Assigning a Geographic Role tells Tableau that a dimension's values correspond to real-world spatial locations.
Native Geographic Roles
Tableau natively recognizes standard geographic fields including:
- Country / Region
- State / Province
- County
- City
- Zip Code / Postal Code
- CBSA / MSA (Core Based Statistical Area)
- Airport (3-letter IATA codes)
- NUTS (Nomenclature of Territorial Units for Statistics in Europe)
- Generated Latitude and Longitude
When a field with a Geographic Role is added to a view (or double-clicked), Tableau automatically generates two fields in the Data Pane:
- Latitude (Generated)
- Longitude (Generated)
Tableau matches dimension string values (e.g., "Chicago" ) against its built-in spatial geocoding database to populate lat/long coordinates onto map views.
Custom Geographic Roles
If your data contains custom geographic groupings (such as Sales Territory containing groups of states), you can assign a Custom Geographic Role by right-clicking Sales Territory -> Geographic Role -> Create from... -> select State/Province .
Field Aliases
An Alias is a custom display label assigned to individual dimension members (the distinct values within a field).
How to Create an Alias
Right-click a dimension in the Data Pane -> select Aliases... -> enter new display names for target values (e.g., changing "US" to "United States" or "N" to "No" ).
Critical Rules for Aliases
Does NOT Change Underlying Data : Aliases affect only how values are displayed in tooltips, headers, and legends within Tableau. The underlying database data remains untouched.
RESTRICTIONS : Aliases CANNOT be created for:
Measures (numerical aggregated fields).
Continuous fields .
Dates .
Boolean fields .
Aliases can be cleared at any time by clicking Reset Aliases in the Aliases dialog window.
Setting Default Properties
To avoid repeatedly formatting the same field across dozens of worksheets, analysts can set Default Properties in the Data Pane. Right-click any field -> select Default Properties :
Default Number Format : Set a measure's default formatting (e.g., Currency with 0 decimal places, Percentage, or Custom Scientific). Every time this field is dragged onto a view, it automatically adopts this formatting.
Default Aggregation : Change the default aggregation assigned when a measure is brought into a view. While SUM is the default for most measures, fields like Discount Rate or Temperature should be set to AVG or MEDIAN .
Default Color : Assign specific color palettes or encoding rules to a dimension's members (e.g., mapping "Pass" to green and "Fail" to red).
Default Sort : Define a custom sort order for dimension members (e.g., sorting Priority as Low , Medium , High , Critical rather than alphabetically).
Comment : Enter a textual description that appears in a tooltip when users hover over the field in the Data Pane.