Tableau Specialist
What are the two options for saving a local data source?
*Data Source* (.tds) - Contains only information you need to connect to the data source. *Packaged Data Source* (.tdsx) - contains all information in the data source (.tds) file, as well as a copy of any local file-based or extracts.
Bookmark File Type?
.tbm
What is an Extract file type?
.tde
Data Source file type?
.tds
Packaged Data Source file type?
.tdsx
Workbook file type?
.twb
Packaged Workbook file type?
.twbx
What does a tdsx file contain?
A Tableau Packaged Data Source contains a zip file that contains the data source file (tds) as well as any other local files such as extracts (tde), excel, or access files. Use this format to create a single file that you can share with others who may not have access to the original data stored locally on your computer.
What does a .twbx file contain?
A Tableau packaged workbook contains a single zip file that contains a workbook along with any supporting local files data and background images. This format is the best way to package work for others who don't have access to the original data.
What is a data blend?
A data blend simulates a left join. The main difference between the two is when aggregation is performed. A coin combines the data then aggregates. A blend aggregates then combined tithe data.
What does a .tds file conain?
Data sources contain shortucuts for quickly connecting to the orignial data that you use often. Data source files do not contain the actual data but rather the information required to connect to the data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, and so on.
What types of attributes can an alias be created for?
Only Discrete Dimensions
What Color are Parameters in Calculations?
Purple
What does an .tde file contain?
Tableau Extracts contain a local copy of a subset or an entire data set that you can use to share data with others.
what does a .tbm file contain?
Tableau bookmark files contain a *single worksheet* and are a quick way to share work.
What does a .twb file contain?
What does this file contain? Workbooks hold one or more worksheets, plus zero or more dashboards and stories.
What color are Fields in calculations
Yellow
Alias vs Rename
You use rename when you want to rename the field name (metadata) and you use alias when you want the dimensions members to appear in your view the way you want (data).
Parameter
a global placeholder value that can by dynamically changed within a calculation, filter, or reference line.
How do you save a data source (click path)
right-click data source -> 'Add to Saved Data Sources' -> Enter file name/select format and click 'Save'.