Data Visualization MCQ-2 (Tableau)

 

1. Amongst which of the following shows in Box plot?                               

A. First quartile           B. Median       C. Outliers       D. All of the mentioned above

Answer: D. All of the mentioned above

2. Which of the following statements is true about Tableau?

 

A. Tableau is a relational database management system.

B. Tableau is a business intelligence and data visualization tool.

C. Tableau is a programming language used for statistical analysis.

D. Tableau is an operating system.

 

Answer: B. Tableau is a business intelligence and data visualization tool.

 

Explanation: Tableau is a software application used for business intelligence and data visualization. It allows users to connect to and analyze data from various sources, and create interactive dashboards, reports, and visualizations.

 

3. Which one of the following is not a type of join in Tableau?

 

A. Inner join

B. Left join

C. Right join

D. Top join

 

Answer: D. Top join

 

Explanation: There is no join called “Top join” in Tableau. The valid types of joins in Tableau are Inner join, Left join, Right join, and Full outer join.

 

4. Which one of the following is not a valid aggregation function in Tableau?

 

A. Sum

B. Count

C. Average

D. Maximize

 

Answer: D. Maximize

 

Explanation: There is no aggregation function called “Maximize” in Tableau. The valid aggregation functions in Tableau are Sum, Count, Average, Median, Minimum, Maximum, and more.

 

5. Which one of the following is not a valid chart type in Tableau?

 

A. Line chart

B. Bar chart

C. Pie chart

D. Cube chart

 

Answer: D. Cube chart

 

Explanation: There is no chart type called “Cube chart” in Tableau. The valid chart types in Tableau are Line chart, Bar chart, Pie chart, Scatter plot, Heat map, and more.

 

6. What is a dimension in Tableau?

 

A. A measure that is computed based on the values of one or more dimensions.

B. A column in a data source that contains categorical data.

C. A data type used to represent numerical values.

D. A type of join used to combine data from multiple tables.

 

Answer: B. A column in a data source that contains categorical data.

 

Explanation: In Tableau, a dimension is a column in a data source that contains categorical data, such as names, dates, or geographic locations. Dimensions are used to slice and dice data, and are typically placed on the Rows and Columns shelves in a view.

 

7. What is a measure in Tableau?

 

A. A column in a data source that contains categorical data.

B. A data type used to represent numerical values.

C. A type of join used to combine data from multiple tables.

D. A value that can be aggregated or computed based on other measures.

 

Answer: D. A value that can be aggregated or computed based on other measures.

 

Explanation: In Tableau, a measure is a value that can be aggregated or computed based on other measures, such as sum, average, or count. Measures are typically placed on the Marks card in a view.

 

8. Which one of the following is not a valid filter type in Tableau?

 

A. Dimension filter

B. Measure filter

C. Table filter

D. Context filter

 

Answer: C. Table filter

 

Explanation: There is no filter type called “Table filter” in Tableau. The valid filter types in Tableau are Dimension filter, Measure filter, Top N filter, Relative date filter, and Context filter.

 

9. What is a parameter in Tableau?

 

A. A type of chart that displays values as bars.

B. A value that can be used to dynamically change the behavior of a calculation.

C. A type of data source that is optimized for live connections to data.

D. A type of join used to combine data from multiple tables.

 

Answer: B. A value that can be used to dynamically change the behavior of a calculation.

 

Explanation: In Tableau, a parameter is a user-defined value that can be used to dynamically change the behavior of a calculation. Parameters can be used to create dynamic filters, calculations, and more.

 

10. What is a calculated field in Tableau?

 

A. A column in a data source that is created by performing a calculation on existing columns.

B. A chart that displays values as bars.

C. A type of data source that is optimized for live connections to data.

D. A type of join used to combine data from multiple tables.

 

Answer: A. A column in a data source that is created by performing a calculation on existing columns.

 

Explanation: In Tableau, a calculated field is a column in a data source that is created by performing a calculation on existing columns. Calculated fields can be used to create custom aggregations, perform data transformations, and more.

 

11. What is a hierarchy in Tableau?

 

A. A type of chart that displays values as bars.

B. A grouping of related dimensions that can be navigated hierarchically.

C. A type of data source that is optimized for live connections to data.

D. A type of join used to combine data from multiple tables.

 

Answer: B. A grouping of related dimensions that can be navigated hierarchically.

 

Explanation: In Tableau, a hierarchy is a grouping of related dimensions that can be navigated hierarchically. Hierarchies can be used to drill down into data, and are typically created by dragging and dropping dimensions onto each other.

 

12. What is a group in Tableau?

 

A. A grouping of related dimensions that can be navigated hierarchically.

B. A type of chart that displays values as bars.

C. A type of data source that is optimized for live connections to data.

D. A type of join used to combine data from multiple tables.

 

Answer: A. A grouping of related dimensions that can be navigated hierarchically.

 

Explanation: In Tableau, a group is a grouping of related dimensions that can be navigated hierarchically. Groups can be used to combine multiple dimensions into a single dimension, and are typically created by selecting two or more dimensions and right-clicking to create a group.

 

13. What is a bin in Tableau?

 

A. A way to group numeric data into discrete ranges.

B. A type of chart that displays values as bars.

C. A type of data source that is optimized for live connections to data.

D. A type of join used to combine data from multiple tables.

 

Answer: A. A way to group numeric data into discrete ranges.

 

Explanation: In Tableau, a bin is a way to group numeric data into discrete ranges. Bins can be used to create histograms, and are typically created by right-clicking on a numeric dimension and selecting “Create bins”.

 

14. What is a dual axis chart in Tableau?

 

A. A chart that combines two different chart types on the same axis.

B. A chart that displays values as bars.

C. A type of data source that is optimized for live connections to data.

D. A type of join used to combine data from multiple tables.

 

Answer: A. A chart that combines two different chart types on the same axis.

 

Explanation: In Tableau, a dual axis chart is a chart that combines two different chart types on the same axis. For example, a dual axis chart can combine a line chart and a bar chart to show two different measures on the same chart.

 

15. What is the difference between a worksheet and a dashboard in Tableau?

 

A. A worksheet is a single chart or table, while a dashboard is a collection of worksheets.

B. A worksheet is a collection of worksheets, while a dashboard is a single chart or table.

C. A worksheet is used for data exploration, while a dashboard is used for data analysis.

D. There is no difference between a worksheet and a dashboard in Tableau.

 

Answer: A. A worksheet is a single chart or table, while a dashboard is a collection of worksheets.

 

Explanation: In Tableau, a worksheet is a single chart or table, while a dashboard is a collection of worksheets. Dashboards are used to bring multiple worksheets together into a single view, while worksheets are used for exploring individual data sets.