Data Blending

Data blending is used when we have to use data from more than one data source in a single workbook.
Data blending based on the common dimension used to join both the databases.
Two data source used in data blending referred as a primary data source and secondary data source.
A small chain image appears next to the dimension which is common between both data sources.
Data blending is used for combining data from one Data source with column data from other data source in a single table.
Why data blending is useful over join-
1- Data is at different granularity.
2- Data is not supported by cross database  join

Tableau Data Extract

Tableau data extract (.dte) -
Stores tableau data as a filtered and aggregated extract.
TDE files are data extracted from the external source such as MS Access or Excel. It is used for external data.  This data can be text,  numerical or statistical data.
TDE extracts are Tableau's method of caching data logically so as to reduce database hits for frequent access reports.
TDE extract can be refreshed manually through Tableau desktop or to be scheduled for periodic refresh through the enterprise edition.

Tableau Packaged Workbook

Tableau packaged workbook contains the Tableau package and extracted local data. The packaged workbook also includes background picture and customized settings in a workbook.
The main purpose of a packaged workbook is to share it with other Tableau Desktop users, who do not have data access. These users can modify the workbook also.
Tableau Reader user can also use packaged workbook but they can't modify it.

The workbook is not connected to original data source and images. It is saved with a .twbx file extension.

Tableau Workbook

Tableau workbook files have the .twb file extension. It is default file type for Tableau users. It does not contain any data in the file.
Tableau Workbook is in XML format. ( it can be edited in a text editor). A workbook contains one or more worksheets. It can also contain dashboards or stories.
It contains information about all formatting, styles, and aggregations applied to any sheet or dashboards in the workbook.
It also contains information about the data source connection and metadata created due to all connections.
Tableau workbook files can be shared with colleagues and clients but they should have access to the data sources.

Tableau Extension File

Tableau uses different file formats which depends on the purpose of there use.

The different formats have unique file types which are identified by there extensions.

These Tableau files can be open in XML format and it can be edited and modified as per requirement.

1. [.TWB]      Tableau Workbook
2. [.TWBX]    Tableau Packaged Workbook
3. [.TDS]       Tableau Data Source
4. [.TDSX]     Tableau Packaged Data Source
5.  [.TDE]      Tableau Data Extract
6. [.TDM]       Tableau Bookmark
7. [.TMS]       Tableau Map Source
8. [.TPS]        Tableau Preference

Tableau Dashboard Tool

Tableau is data visualization and business analytics tool. It is used To build interactive dashboards which allow the user to analyze and explore data
It is developed in Stanford University, Computer Science department between 1999 and 2002.
In Tableau, you can connect any data source. Eg Excel,  SAP etc
You can drag various data fields to the desired part of the sheet.
It is used for interactive dashboards
Tableau automatically makes the inner join.
We can add the different data source in a single table.

Tableau has different products -

1- Tableau Desktop

2- Tableau Public

3- Tableau server

4- Tableau Online

5- Tableau Reader