Book Image

Getting Started with Tableau 2018.x

By : Tristan Guillevin
Book Image

Getting Started with Tableau 2018.x

By: Tristan Guillevin

Overview of this book

Tableau is one of the leading business intelligence tools used worldwide, in organizations of every scale. In its latest release, Tableau 2018 promises richer and more useful features related to visual analytics, reporting, dashboarding, and a host of other data visualization aspects. Getting Started with Tableau 2018.x will get you up and running with these features. The book starts with all the new functionalities of the different Tableau 2018 versions, along with concrete examples of how to use them. However, if you're new to Tableau, don't worry! The rest of the book will guide you through each major aspect of Tableau with examples. You'll learn how to connect to data, build a data source, visualize your data, build a dashboard, and share it online. In the final chapters, you'll also learn advanced techniques such as creating a cross-database join, data blending, and more. By the end of the book, you will have a firm understanding of how to effectively use Tableau to create quick, cost-effective, and business-efficient business intelligence solutions.
Table of Contents (21 chapters)
Title Page
Copyright and Credits
Packt Upsell
Contributors
Preface
Free Chapter
1
Catching Up with Tableau 2018
Index

Join data easily


A Join creates a single Data Source with columns coming from two (or more) tables. How do Joins work? How can you create them? Are there risks? You'll learn everything in this section.

The Join principle

So far, we've only used one table. A Join is automatically created when using two or more tables. There is always a left table and a right table. In the following screenshot, you see a Join between Orders (the left table), and People (the right table):

The result of a Join is a Data Source that contains the columns from the different tables. As highlighted in the screenshot, you can see that the Profit column comes from the Orders table, and the Person column comes from the People table:

There are four different types of join. Discover them in the next section.

Join requirements and types

To create a Join between two tables, you need at least one column in each table that contains the same values. These common columns create the link between the two tables. When you create a Join...