Data Types in Tableau

Data Types in Tableau

3 mins read12.7K Views Comment
Vikram
Vikram Singh
Assistant Manager - Content
Updated on Mar 20, 2023 12:21 IST

Tableau supports 7 types of data types String values, Date values, Date & Time values, Numeric values, Boolean values, Geographical values, Cluster or mixed values.

2022_03_MicrosoftTeams-image-226.jpg

Introduction

Data types in Tableau gives information about the kind of data/information that can be stored in the data source.

There are seven different data types in tableau String values, Date values, Date & Time values, Numeric values, Boolean values, Geographical values, Cluster or mixed values.

Must Check: Tableau Tutorial

Let’s discuss them one by one briefly:

Table of Content

String Data Type

  • Text Data type
  • Characters are enclosed in single or double quotes
    • “Shiksha Online” or ‘Shiksha Online’
  • String values are of two types:- Char and Varchar

Must Read: Introduction to Tableau

Must Read: Products of Tableau

Char Data Type

  • The length of the string is pre-defined or fixed
    • i.e. if you enter the value greater than defined it will show error 
  • Stores alpha-numeric values

Must Read: Groups in Tableau

Must Read: LOD Expression in Tableau

Varchar Data type

  • Varchar stands for Variable character
  • The length of the string is variable
    •  i.e. you can enter as many values as you want
  • Stores alpha-numeric values

Must Read: Sort Data in Tableau

Must Read: Tableau Sets

Date and Date & Time Data Type

  • Tableau support all date formats like
    • dd-mm-yy, dd-mm-yyyy, mm-dd-yyyy etc.
  • Date and time data type is an extension of Date data type
  • Time data values can be
    • Seconds, minutes, hours, days, months, years, decades etc.
  • If you want to add date value in the form of a string, add # symbol before,
    • Example: # 11 March 2022

Must Read: Data Aggregation in Tableau

Must Read: Date Function in Tableau

Numeric Data Type

  • Numeric values can be either:- Integer or Floating
    • Integer: 10, -5, 0
    • Floating (decimal): 2.536, 0.6667, -3.14 
  • Integer are preferred over floating values as it’s difficult to accumulate decimal point after a certain limit.
  • Round( ) is used to round the float values.

Must Read: Filters in Tableau

Must Read: Tableau Show

Boolean Data Type

  • Boolean data types have two logical values:- True or False.
  • True and False are also represented by 1 and 0 respectively
    • Example: “ Is profit greater than zero?”- “Yes” or “No”
    • In the tableau, it becomes a boolean calculation:
      • SUM([Profit]) > 0

Must Read: Types of Charts in Tableau

Must Read: Joins in Tableau

Geographical Data Type

  • Data values are used in Maps
  • Associates each value in a field with latitude and longitude value
  • Includes values such as postal code, region, city, state, country etc.

Must Read: Tableau Forecasting

Must Read: Extract and Data Source Filter in Tableau

Cluster or Mixed Data Types

Tableau is capable of identifying the data type but sometimes the data field doesn’t match the data type.

Mix values create a problem while analyzing the data.

This problem can be resolved by creating a separate column that doesn’t contain the mixed values.

Must Read: Operators in Tableau

Must Read: How to Change Data Type in Tableau

Data Type icons in Tableau

Icon Data type
Text (string) values
Date values
Date & Time values
Numerical values
Boolean values
Geographic values
Cluster or Mixed values

Conclusion

In this article, we discussed different data types in tableau: string, numerical, date, date & time, Boolean, geographical, and mixed data type.

Hope this article will help you in your data analyst journey.

This article is a part of a complete tutorial of Tableau, focusing on Tableau certified data analysts and tableau desktop specialists. 

Through a series of articles, we will cover all the topics in-depth with examples.

FAQs

What are the different data types in Tableau?

Data types in Tableau gives information about the kind of data/information that can be stored in the data source. There are seven different data types in tableau String values, Date values, Date and Time values, Numeric values, Boolean values, Geographical values, Cluster or mixed values.

What is String Data Type?

String Data Types are Text Data types. In which characters are enclosed in single or double quotes. Example:- u201cNaukri Learningu201d or u2018Naukri Learningu2019 String values are of two types:- Char and Varchar

What is Boolean Data type?

Boolean data types have two logical values:- True or False. True and False are also represented by 1 and 0 respectively Example: u201c Is profit greater than zero?u201d- u201cYesu201d or u201cNou201d

About the Author
author-image
Vikram Singh
Assistant Manager - Content

Vikram has a Postgraduate degree in Applied Mathematics, with a keen interest in Data Science and Machine Learning. He has experience of 2+ years in content creation in Mathematics, Statistics, Data Science, and Mac... Read Full Bio