Explore topic-wise InterviewSolutions in .

• Workbooks: Workbooks CONTAIN one or more worksheets and dashboard elements.
• Bookmarks: CONTAINS a single worksheet that is easier to share.
• Packaged Workbooks: Contains a workbook along with supporting local file data and BACKGROUND images.
• Data Extraction FILES: Extract files that contain a subset of data.
• Data Connection Files: SMALL XML file with various connection information.

CREATING a story is effective in Tableau which is created by combining various charts to portray a plot of viewers. A story is a SHEET that contains all the methods USED to create those worksheets. To create a story:

1. Click the New Story on the dashboard.
2. Choose the right size of the story from the bottom-left corner or choose a CUSTOM size.
3. Start building the story by double-clicking the sheet and add it to the story point.
4. Add a CAPTION to the story by clicking Add a caption.
5. You can update the highlights by clicking Update in the toolbar. You can also add layout options, format a story, or fit the story to your dashboard.

TDE is Tableau DESKTOP Extension with extension .tde. TDE file points to a file that contains data from external sources like MS Excel, MS Access, or CSV FILES. TDE makes it easier to analyze and DISCOVER data.

The components displayed in a dashboard are:

• HORIZONTAL: Horizontal view allows the USERS to combine the worksheets and dashboard elements from LEFT to right and edit the height of the elements.
• Vertical: Vertical view allows the users to combine the worksheets and dashboard elements from top to bottom and edit the width of the elements.
• Text: All the textual fields.
• Image Extract: To extract an image Tableau applies some code, extracts the image, and saves it in a WORKBOOK in the XML format.
• WEB URL: Hyperlink that points to a web page, file, or other web resources outside of Tableau

Data EXTRACTS are the subsets of data created from data sources. SCHEDULES are scheduled refreshes made on extracts after publishing the workbook. This keeps the data up-to-date. Schedules are strictly MANAGED by the server administrators.

Both the maps help in analyzing data. While a heat map visualizes and compares different categories of data, a treemap displays a hierarchical structure of data in rectangles. Heat map visualizes measures against dimensions by depicting them in different colors. Similar to a text table with values DEFINED in different colors.

Treemap visualizes the hierarchy of data in nested rectangles. Hierarchy levels are DISPLAYED from LARGER rectangles to smaller ones.

Example - Below treemap shows aggregated sales totals across a range of product categories:

Image - tableau.com

Dual axes are used to analyze two DIFFERENT MEASURES at two different scales in the same graph. This lets you compare multiple attributes on one graph with two independent axes layered one above the other.

To ADD a measure as a dual-AXIS, drag the field to the right side of the view and drop it when you see a black dashed line appear. You can also right-click (control-click on Mac) the measure on the Columns or Rows shelf and select Dual Axis.

Tableau has 6 different TYPES of filters:

• EXTRACT FILTER: This filter retrieves a SUBSET of data from the data source.
• Dimension Filter: This filter is for non-aggregated data (discrete).
• Data Source Filter: This filter refrains users from viewing sensitive information and thus reduces data feeds.
• Context Filter: This filter creates datasets by applying presets in Tableau.
• Measure Filter: This filter APPLIES various operations like sum, median, avg, etc.
• Table Calculation Filter: This filter is applied after the view has been created.

An analytical database that computes instant QUERY responses, predictive analysis of the server, and integrated data. The data engine is USEFUL when you NEED to CREATE, refresh, or query EXTRACTS. It can be used for cross-database joins as well.