Exploring Tableau Concepts

What is the primary purpose of a join in Tableau?

• To combine data from multiple tables based on related columns.

• To create calculated fields in Tableau.

• To visualize data trends over time.

• To filter data from a single table.

How does a union differ from a join in Tableau?

• A union merges data from different databases, while a join filters data from the same table.

• A union stacks rows from similar tables, while a join combines columns from related tables.

• A union combines rows from unrelated tables, while a join stacks columns from similar tables.

• A union creates a new table, while a join modifies the existing table structure.

Define a dimension in the context of Tableau.

• A dimension in Tableau is a numerical field used for calculations.

• A dimension in Tableau is a qualitative field that categorizes data for analysis and visualization.

• A dimension in Tableau is a type of chart used for visualization.

• A dimension in Tableau is a setting that controls the layout of the dashboard.

What are measures in Tableau and how do they differ from dimensions?

• Measures are quantitative data that can be aggregated, while dimensions are qualitative data that categorize the measures.

• Measures are only used for filtering data.

• Dimensions can be aggregated like measures.

• Measures are always qualitative data.

What types of joins are available in Tableau?

• Cross Join

• Natural Join

• Inner Join, Left Join, Right Join, Full Outer Join

• Self Join

How can you create a calculated field in Tableau?

• Drag and drop a field into the view to create a calculation

• Use the 'Analysis' menu and choose 'Add Calculation'

• Right-click in the Data pane, select 'Create Calculated Field', enter a name and formula, then click 'OK'.

• Click on 'File' and select 'New Calculated Field'

What is the role of filters in Tableau visualizations?

• Filters help limit and refine the data displayed in Tableau visualizations.

• Filters automatically generate insights without user input.

• Filters enhance the aesthetic appeal of visualizations.

• Filters are used to create new data sources in Tableau.

Describe how to use parameters in Tableau.

• Parameters can only be applied to text fields in Tableau.

• Parameters are only used for visual formatting in Tableau.

• Parameters in Tableau allow users to replace a constant value in calculations, filters, and reference lines, enabling dynamic data analysis.

• Parameters are static values that cannot change during analysis.

How can you combine data from multiple sources in Tableau?

• Use only Excel for data analysis.

• Visualize data without combining sources.

• Export data to CSV before combining.

• Use data blending or join data in the data source tab.

What is a dashboard in Tableau?

• A dashboard in Tableau is a collection of visualizations displayed together on a single screen.

• A dashboard in Tableau is a single chart with no interactivity.

• A dashboard in Tableau is a report generated automatically.

• A dashboard in Tableau is a type of data source.