In this chapter, you'll learn how to combine data from different sources using joins, unions, and relationships. You'll also discover the difference between extracts and live connections. Finally, you'll learn how to save your work in Tableau.

Combining data tables

Options

Joins

Unions

Joins and unions

Unioning tables

Combining time data

Editing the union

Joining tables

Returned orders

Sales representatives

Relationships

Functionality of relationships

Establishing a relationship

Relationship to manufacturers

Worst products

Extracts

Creating extracts

Tableau Extracts

Tableau Packaged Workbooks

Tableau file types

Live Connection

Extract

Extract or live connection

Combining and Saving Data

Learn to manage data properties by renaming columns, assigning aliases and geographic roles, changing data types, and leveraging default properties. On top of that, you'll discover the different data connectors and filter types.

Data properties

Naming and data labels

Managing the presentation of data

Using aliases and colors

Default formatting

More data management

Assigning geo roles

Creating a hierarchy

Default aggregations

Tableau connectors

Connecting to data

Database connectors

TDS data source files

Filters

Tableau filters

Tableau's filtering order of operation

Adding a context filter

Using different filters

Managing and Connecting Data

Workbooks and Datasources

Great analysis begins with great data. But how do you connect Tableau to your databases and other file types, so that you can build a view and analyze your data? In this course, you'll learn how to use connectors in Tableau to create a live connection to CSV and Excel files. Through hands-on exercises, you’ll also learn how to combine multiple data tables with joins, unions, and relationships. Finally, you'll learn to manage different data properties, like renaming data fields, assigning aliases, changing data types, and changing default properties for a data field.

<h2>Great Analysis begins with Great Data</h2>
But how do you connect Tableau to your databases and other file types, so that you can build a view and analyze your data? In this course, you'll learn how to use connectors in Tableau to create a live connection to CSV and Excel files. 
<br><br>
<h2>Combine Multiple Data Sources</h2>
Through hands-on exercises, you’ll also learn how to combine multiple data tables with joins, unions, and relationships. 
<br><br>
Finally, you'll learn to manage different data properties, like renaming data fields, assigning aliases, changing data types, and changing default properties for a data field.


Introduction to Tableau

Learn to connect Tableau to different data sources and prepare the data for a smooth analysis.

Connecting Data in Tableau

Data Analyst in Tableau

Tableau Fundamentals

Tables merged on a key or a unique identifier

One table with the weather for each day in 2019 and another with ice cream sales for each day in 2019

Tables holding the same type of information with the same number of columns and data types

Twelve tables for sales data for each month in 2019

Joins and unions

Connecting Data in Tableau

Hands-on interactive exercise