Tableau : Practice Questions and Answers

Tableau is a leading data visualization tool that helps users create interactive and shareable dashboards. It simplifies raw data into an understandable format, making it easier to derive actionable insights.

A Tableau workbook contains multiple worksheets, dashboards, and other visualization components.

Tableau Workbooks (.twbx) are packaged files that include both the workbook and the data source. These files are essential for sharing Tableau projects with others without requiring a separate data source connection.

Tableau offers products like Desktop, Server, and Cloud for data visualization and sharing. However, it does not provide a database management system (DBMS); it connects to external databases for data access.

A Tableau dashboard is a workspace where multiple visualizations (charts, graphs, and other data displays) are brought together in a single view. Dashboards allow users to compare related data points and derive insights quickly.

Tableau Reader is used to view and interact with Tableau reports that have been shared offline.

Parameters in Tableau enable the creation of dynamic filters that allow user input during analysis.

Calculated fields are used to perform custom computations and create new data fields based on existing data in Tableau.

Line charts are ideal for showing trends and changes over a continuous time period, such as sales over months or years.

The || operator is used in Tableau to concatenate strings.

The first step in Tableau is to connect to a data source or import data for analysis. Tableau supports connections to a wide range of sources, including Excel, SQL databases, and cloud services, simplifying the data preparation process.

While Tableau can connect to .xlsx files (Excel), it is not a Tableau-specific file format. Tableau uses .twb (workbooks), .tde (data extracts), and .hyper (newer extract format) as native file types.

SUM(), MIN(), MAX(), and other aggregate functions allow you to summarize data in Tableau.

Level of Detail (LOD) expressions allow calculations at a specific level of granularity, independent of the view's dimensions.

Data blending in Tableau combines data from multiple, unrelated sources, enabling users to analyze and visualize data that cannot be joined directly due to different structures or keys.

A live connection directly queries the data source, enabling real-time updates. Extracts create a static snapshot, which improves performance but doesn't reflect real-time changes.

A Heatmap uses colors to represent data density or magnitude, helping users quickly identify patterns or anomalies in the data.

Tableau Server allows teams to securely share dashboards and visualizations, ensuring collaboration while maintaining data privacy and access control.

The Data Interpreter feature in Tableau highlights errors or inconsistencies in connected data, such as incorrect headers or blank rows, and offers suggestions for cleaning the data.

A join combines columns from multiple tables based on a common field, while a union stacks rows from multiple tables or files with the same structure.