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

This article mainly explains the "introduction and use of Tableau", the content of the explanation is simple and clear, easy to learn and understand, now please follow the editor's ideas slowly in depth, together to study and learn "the introduction and use of Tableau" bar!

Forgive me for the title party, today using a rare weekend, I used Tableau to do a simple introduction.

Since it is an introduction, there must be a lot of in-depth knowledge that I do not quite understand, but it does not matter, if you have the opportunity to contact in the future, slowly in the work and learning.

But some friends may say, can't you type the code to get the corresponding visual graphics? Why use professional data analysis software like Tableau?

So I think I need to know what Tableau is first.

Why Tableau?

First of all, let's introduce what Tableau is.

Some people may say that the PivotTable I made with excel is also very good, so why use software like Tableau, which is extremely expensive (it doesn't seem to be very expensive)? What is the uncracked version of the software in China?

Because I am not the boss, I will not talk about it from the point of view of cost. I am a data analysis enthusiast, and I am also a graphics enthusiast. I especially like to see those cool graphics, which may be useless. But cool is fine, ha. It is true that Tableau can draw a lot of cool graphics, such as

Wow, I am still a moving picture, isn't it very cool?

Ps: (the above graphics are all from the network, if the infringement is deleted immediately)

Before I begin my study, I would like to make a mind map to illustrate the order of learning Tableau and what I want to do through this article. What do you get.

The writing order of this article

A simple understanding of Tableau

I think learning any software? You can call Tableau software, right? you will have a basic understanding of the interface first.

I use version 10.5 of Tableau, and I don't know if there are any particularly useful features in the latest version.

I can't help but be vulgar. Let's introduce the main interface first.

Start page of Tableau

You can see that the start interface consists of three parts: connect, open, and explore.

First of all, introduce connection: connection can connect files directly: there are also many file types that can be connected in the figure, this is where Tableau is good, you can directly connect to Excel, text, JSON,Access database, PDF, spatial files.

Then you can connect to the server, and this is even more powerful, and it can basically connect to all the popular servers on the market.

This is a server that can be connected.

Now mainstream databases such as MySQL,Oracle,Hadoop,MongoDB can be connected.

After knowing the connection, let's take a look at the opening, after opening and clicking.

You can see that opening the workbook goes directly to the workbook that you can use, that is, the previously saved Tableau file.

And the last exploration, is the conscience of this software, there is a very basic introductory video, hand-in-hand to teach you to get started.

Of course, there are software updates and some advertisements.

Let's take a look at the next interface, the data source interface.

Here we connect a data (supermarket dataset) to better illustrate. You can see that the above is usually divided into three main areas, the left pane, the canvas and the grid.

Left pane: displays connected databases, servers, and tables in databases

* * canvas: * * one or more datasets can be connected here

Grid: you can view the fields in the data source and the data in the first 1000 rows. You can also make general changes to the data source, such as sorting, hiding fields, creating fields, and setting aliases.

Workbook interface:

The interface with the most practical operation

Let's take a look at what this interface has.

First, you can see that there is a dimension and measurement area on the left.

So what do dimensions and measures mean, respectively?

Dimensions: Tableau automatically assigns information fields containing discrete classification information to dimensions, such as strings and dates, when connecting to the data source for the first time. Of course, dimensions can also be converted into metrics.

Metrics: Tableau assigns fields that contain quantitative numerical information to metrics.

Since this interface is commonly used in the future, I will introduce some subsequent introductions in the last step of the actual operation.

OK, this is the end of the introduction of the basic interface of Tableau. Let's move on to the second step.

2. Data types supported by Tableau

Tableau supports string, date / date time, number and Boolean data types.

Here, take the dataset just now as an example, where the Abc in the header represents the text value.

The calendar-like icon marked in the image above is the date.

And something similar to # in this graph represents a numeric value.

There is also one that does not have T | F in this diagram. This is the commonly used Boolean value (relational data sources only).

And the earth chart above represents the geographical value (for maps).

If you want to change the data type is the above operations, just change the data type.

Operators and precedence

The operators supported by Tableau are arithmetic operator, logical operator and comparison operator.

1 arithmetic operator

+ (addition): for the addition of numbers, for strings to represent concatenation, for dates, you can add days and dates. For example: 'abc'+'def'='abcdef',#April 15, 2004, April 15, April 2004, April, April

-(subtraction): similarly, it is used for subtraction of numbers, inversion for expressions, for dates, and can be used to subtract days from dates.

* (multiplication): used for numeric multiplication, for example, 5-4-20

/ (division): used to represent division of numbers, for example, 20 times 4 times 5

% (remainder): this operator calculates the remainder of the number, 5% 4x1

^ (power): this symbol is equivalent to the POWER function and is used to calculate the specified power of a number, such as 6 ^ 3 = 216.

2 logical operator

AND logic operation and, both sides must use expression or Boolean value OR logic operation or, both sides must use expression or Boolean value NOT logic operation No, this operator can be used to invert another Boolean value or expression

3 comparison operator

Tableau has a wealth of comparison operators, such as = or =, >, =

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.