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.

Type of Tableau Extension File

Tableau uses different file formats which depend on the purpose of their uses. The various formats have unique file types which are identified by their extensions. These Tableau files can be opened in XML format and edited and modified as required.

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

Fact Table

Fact Table

Type of Fact-

1-Additive- Additive facts are facts that can be summed through all of the dimensions in the fact table.
2-Semi-Additive- Semi-aditive facts are that can be summed through some of the dimensions and cannot be summed through some dimensions.
3-Non-Additive- Non-additive facts are that can not be summed up for any dimensions in fact table

Factless Fact table-

A factless table is fact table which does not contains any measure. It is just an intersection of dimenstions.

Dataware Housing Concept

Data warehousing concept is a process of collecting, organizing, and managing data from different data sources to create and provide useful business insights. 

The main features of a data warehouse are as below:

• Subject Oriented- A data-ware house provides information about subject (area) of organization. like sales, marketing etc.

• Integrated- A data warehouse integrates data from different heterogeneous sources. They should not have naming conflicts and differences between values of measures.

• Non-Volatile- Non-volatile means, data should not be removed over the time. because data is used for analysis purpose.

• Time Variant- Data in data warehouse changes with time. It stores more data as time passes.