Shulou(Shulou.com)06/03 Report--

Tableau data source operation 1. Data type

Common data types are as follows:

STRING

String type, enclosing NUMBER in single or double quotation marks

Numeric types, that is, integer and floating point BOOLEAN

Boolean value type, indicating true or false DATE

Date type, such as 2012-12-12DATETIME

Date-time type, such as 2012-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12 Data source

Tableau supports connecting to all common data sources.

File system: such as Excel,CSV file relational system: Oracle,MySQL,DB2 and other relational database cloud systems: other sources such as Windows Azure,Google BigQuery use ODBC or JDBC

Three characteristics of data source

Real-time connection: Tableau connects to real-time data sources and continuously reads data for real-time data analysis data cache: caches data in memory to process data in memory, no longer connects to data sources when analyzing data, combines data from different sources together. Connect data source connect Excel data

To connect to the official instance data, the following information is displayed after a successful connection

Connect MySQL data

Connect to a remote MySQL server

After the connection is successful, select the database

Select the student table and update it immediately

Multi-table connection

Multi-table connection methods are: inner connection, left connection and right connection, which is inner connection by default.

Data mixing

Gather data from different sources for data analysis

Extract data

Use a filter to extract the data and select the data you want. Select add filter to pop up the following dialog box

For example, to extract order information from East China, do the following

At this time, the viewing area columns are all in East China.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.