Tableau Software

Tableau Software (/t?b?lo?/ tab-LOH) is an American interactive data visualization software company focused on business intelligence. It was founded in 2003 in Mountain View, California, and is currently headquartered in Seattle, Washington. In 2019 the company was acquired by Salesforce for $15.7 billion. At the time, this was the largest acquisition by Salesforce (a leader in the CRM field) since its foundation. It was later surpassed by Salesforce's acquisition of Slack.

The company's founders, Christian Chabot, Pat Hanrahan and Chris Stolte, were researchers at the Department of Computer Science at Stanford University.They specialized in visualization techniques for exploring and analyzing relational databases and data cubes,and started the company as a commercial outlet for research at Stanford from 1999 to 2002.

Tableau products query relational databases, online analytical processing cubes, cloud databases, and spreadsheets to generate graph-type data visualizations. The software can also extract, store, and retrieve data from an in-memory data engine.

Map functionalities

The software is able to plot latitude and longitude coordinates and connect to spatial files like Esri Shapefiles, KML, and GeoJSON to display custom geography. The built-in geo-coding allows for administrative places (country, state/province, county/district), postal codes, US Congressional Districts, US CBSA/MSA, Area Codes, Airports, and European Union statistical areas (NUTS codes) to be mapped automatically. Geographies can be grouped to create custom territories or custom geocoding used to extend existing geographic roles in the product.

Data sources

Tableau Software can connect to data sources such as regular text files (.txt, .csv), Microsoft Excel (.xlsx), Microsoft Access (.accdb), import from Tableau workbook (.tbm), Tableau Table data Extract (.tds) and many other types. It also allows to connect to data using multiple pre-built connectors

Data Type

Tableau express automatically data types and fields. Tableau will make use of the data type that the data source has defined if it exits, or it will choose a data type if the data source does not specify one. In Tableau, the following data types are supported

• Text (string) Value
• Date Value
• Date and Time Value
• Numerical Value
• Geographic Values (Latitude and longitude used for maps)
• Boolean Values (True / False Conditions)
• Image role (used with image link URLs)
• Cluster Group (used with Find Clusters in Data)