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

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 file types

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

Options

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

Not included in .tds file

Included in .tds file

TDS data source files

Filters

Tableau filters

Order of Operations

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

Default aggregations

Connecting Data in Tableau

Hands-on interactive exercise