Fundamentals of Tableau Interview Questions
- What is a Dimension in Tableau?
- What is a Measure in Tableau?
- What is a Worksheet in Tableau?
- What is a Dashboard in Tableau?
- What is Aggregation in Tableau?
- What is a Filter in Tableau?
- What is a Join in Tableau?
- What is a Parameter in Tableau?
- What is a Calculated Field in Tableau?
- What is Data Blending in Tableau?
- How can you zoom in and out on a Tableau worksheet?
- How can you navigate between worksheets in a Tableau workbook?
- How can you move a worksheet within a Tableau dashboard?
- How can you resize a worksheet in Tableau?
- How can you switch between different views within a worksheet in Tableau?
- How can you switch between different views within a worksheet in Tableau?
- How can you show or hide a specific field in a Tableau worksheet?
- How can you switch between different sheets in a Tableau workbook?
- How can you navigate to a specific data source in Tableau?
- How can you undo or redo actions in Tableau?
- Which chart type in Tableau is best suited for comparing values across different categories?
- Which chart type in Tableau is best suited for showing trends over time?
- Which chart type in Tableau is best suited for showing the distribution of a continuous variable?
- Which chart type in Tableau is best suited for comparing values across both categories and time periods?
- Which chart type in Tableau is best suited for visualizing the relationship between two continuous variables?
- Which chart type in Tableau is best suited for visualizing the relationship between two continuous variables?
- Which chart type in Tableau is best suited for comparing values across multiple dimensions?
- Which chart type in Tableau is best suited for displaying hierarchical data?
- Which chart type in Tableau is best suited for showing the composition of a whole?
- Which map type in Tableau is best suited for displaying geographic data?
- What is the purpose of the arithmetic operator (+) in Tableau?
- What is the purpose of the comparison operator (=) in Tableau?
- What is the purpose of the logical operator (AND) in Tableau?
- What is the purpose of the wildcard operator () in Tableau?
- What is the purpose of the aggregation operator (SUM) in Tableau?
- What is the purpose of the concatenation operator (&) in Tableau?
- What is the purpose of the logical operator (OR) in Tableau?
- What is the purpose of the comparison operator (<>) in Tableau?
- What is the purpose of the string operator (CONTAINS) in Tableau?
- What is the purpose of the logical operator (NOT) in Tableau?
- What does the IF function in Tableau do?
- What is the purpose of the AND function in Tableau?
- What is the purpose of the SUM function in Tableau?
- How does the MIN function in Tableau work?
- What does the OR function in Tableau do?
- How does the COUNT function in Tableau work?
- What is the purpose of the NOT function in Tableau?
- How does the AVG function in Tableau work?
- What does the IFNULL function in Tableau do?
- What is the purpose of the MAX function in Tableau?
What is a Dimension in Tableau?
Answer: A dimension in Tableau refers to a categorical or qualitative data field that provides context and describes the data. Examples of dimensions include product categories, customer segments, or geographic regions.
What is a Measure in Tableau?
Answer: A measure in Tableau refers to a quantitative or numerical data field that can be aggregated, summarized, or used for calculations. Examples of measures include sales revenue, profit, or quantity sold.
What is a Worksheet in Tableau?
Answer: In Tableau, a worksheet is a visual canvas where you can create and display data visualizations. It is the primary space for building charts, graphs, and other visual representations of your data.
What is a Dashboard in Tableau?
Answer: A dashboard in Tableau is a collection of multiple worksheets, views, and visualizations displayed together on a single screen. Dashboards allow you to present and interact with different aspects of your data in a consolidated and meaningful way.
What is Aggregation in Tableau?
Answer: Aggregation in Tableau refers to the process of combining multiple data values into a single value, often through functions like sum, average, count, or maximum. Aggregating data helps to summarize and analyze large datasets.
What is a Filter in Tableau?
Answer: A filter in Tableau allows you to limit the data displayed in a worksheet or dashboard based on specific conditions or criteria. Filters help in focusing on specific subsets of data for analysis and visualization.
What is a Join in Tableau?
Answer: A join in Tableau combines data from multiple tables or data sources based on a common field or key. It allows you to bring together related data to create a comprehensive view for analysis and visualization.
What is a Parameter in Tableau?
Answer: A parameter in Tableau is a dynamic input that allows users to change certain values or settings in a visualization. Parameters provide flexibility and interactivity by enabling users to adjust variables and see the impact on the data.
What is a Calculated Field in Tableau?
Answer: A calculated field in Tableau is a custom field created using formulas and expressions. It allows you to perform calculations, transformations, or manipulations on existing fields to derive new insights or metrics.
What is Data Blending in Tableau?
Answer: Data blending in Tableau refers to the process of combining data from different sources or databases into a single analysis. It allows you to work with multiple data sets simultaneously and perform cross-database analysis.
Tableau Navigation
How can you zoom in and out on a Tableau worksheet?
Answer: You can zoom in and out on a Tableau worksheet by using the zoom slider located at the bottom right corner of the worksheet. Slide it to the right to zoom in and slide it to the left to zoom out.
How can you navigate between worksheets in a Tableau workbook?
Answer: To navigate between worksheets in a Tableau workbook, you can use the worksheet tabs located at the bottom of the Tableau window. Simply click on the desired worksheet tab to switch to that particular worksheet.
How can you move a worksheet within a Tableau dashboard?
Answer: To move a worksheet within a Tableau dashboard, click and drag the title bar of the worksheet and drop it into the desired position within the dashboard.
How can you resize a worksheet in Tableau?
Answer: To resize a worksheet in Tableau, you can click and drag the edges of the worksheet to adjust its dimensions. Alternatively, you can right-click on the worksheet and choose “Size” from the context menu to specify exact dimensions.
How can you navigate between dashboards in a Tableau workbook?
Answer: To navigate between dashboards in a Tableau workbook, you can use the dashboard tabs located at the top of the Tableau window. Simply click on the desired dashboard tab to switch to that particular dashboard.
How can you switch between different views within a worksheet in Tableau?
Answer: To switch between different views within a worksheet in Tableau, you can use the drop-down menu located at the top left corner of the worksheet. Click on the drop-down menu and select the desired view from the list.
How can you show or hide a specific field in a Tableau worksheet?
Answer: To show or hide a specific field in a Tableau worksheet, you can use the field list pane located on the left side of the Tableau window. Simply check or uncheck the checkbox next to the field name to show or hide it.
How can you switch between different sheets in a Tableau workbook?
Answer: To switch between different sheets in a Tableau workbook, you can use the sheet tabs located at the bottom of the Tableau window. Click on the desired sheet tab to switch to that particular sheet.
How can you navigate to a specific data source in Tableau?
Answer: To navigate to a specific data source in Tableau, you can use the data source tab located at the bottom left corner of the Tableau window. Click on the data source tab to access and explore the underlying data.
How can you undo or redo actions in Tableau?
Answer: To undo or redo actions in Tableau, you can use the undo and redo buttons located at the top left corner of the Tableau window. Click on the backward arrow to undo an action and click on the forward arrow to redo an action.
Charts and Maps
Which chart type in Tableau is best suited for comparing values across different categories?
Answer: The bar chart in Tableau is best suited for comparing values across different categories. It displays the values as horizontal or vertical bars, allowing for easy comparison between categories.
Which chart type in Tableau is best suited for showing trends over time?
Answer: The line chart in Tableau is best suited for showing trends over time. It connects data points with lines, providing a clear visualization of how values change over a continuous axis.
Which chart type in Tableau is best suited for showing the distribution of a continuous variable?
Answer: The histogram chart in Tableau is best suited for showing the distribution of a continuous variable. It divides the range of values into bins and displays the frequency or count of values in each bin.
Which chart type in Tableau is best suited for comparing values across both categories and time periods?
Answer: The stacked bar chart in Tableau is best suited for comparing values across both categories and time periods. It displays the values as stacked bars, allowing for comparison within categories and across different time periods.
Which chart type in Tableau is best suited for visualizing the relationship between two continuous variables?
Answer: The scatter plot chart in Tableau is best suited for visualizing the relationship between two continuous variables. It plots data points on a Cartesian coordinate system, with one variable represented on the x-axis and the other on the y-axis.
Which chart type in Tableau is best suited for displaying proportions or percentages?
Answer: The pie chart in Tableau is best suited for displaying proportions or percentages. It represents the values as slices of a pie, with each slice representing a portion of the whole.
Which chart type in Tableau is best suited for comparing values across multiple dimensions?
Answer: The treemap chart in Tableau is best suited for comparing values across multiple dimensions. It uses rectangles of different sizes to represent the values, allowing for comparison within and between dimensions.
Which chart type in Tableau is best suited for displaying hierarchical data?
Answer: The tree chart in Tableau is best suited for displaying hierarchical data. It uses a branching structure to represent the relationships and hierarchy among different categories or groups.
Which chart type in Tableau is best suited for showing the composition of a whole?
Answer:The stacked area chart in Tableau is best suited for showing the composition of a whole. It displays the values as stacked areas, providing a visual representation of how each part contributes to the whole.
Which map type in Tableau is best suited for displaying geographic data?
Answer: The filled map in Tableau is best suited for displaying geographic data. It uses color shading or patterns to represent the values associated with different geographic regions.
Tableau Operators
What is the purpose of the arithmetic operator (+) in Tableau?
Answer: The arithmetic operator (+) in Tableau is used to perform addition between two or more numerical values or fields.
What is the purpose of the comparison operator (=) in Tableau?
Answer: The comparison operator (=) in Tableau is used to check if two values or fields are equal. It returns a Boolean value of true if the values are equal and false if they are not.
What is the purpose of the logical operator (AND) in Tableau?
Answer: The logical operator (AND) in Tableau is used to combine multiple conditions in a logical expression. It returns true only if all the conditions are true.
What is the purpose of the concatenation operator (&) in Tableau?
Answer: The concatenation operator (&) in Tableau is used to combine text or string values together. It merges the values or fields into a single string.
What is the purpose of the wildcard operator () in Tableau?
Answer: The wildcard operator () in Tableau is used as a placeholder to represent one or more characters in a string. It is commonly used with the LIKE operator to perform pattern matching.
What is the purpose of the aggregation operator (SUM) in Tableau?
Answer: The aggregation operator (SUM) in Tableau is used to calculate the sum of numerical values within a specified scope, such as a dimension or a group of data.
What is the purpose of the logical operator (OR) in Tableau?
Answer: The logical operator (OR) in Tableau is used to combine multiple conditions in a logical expression. It returns true if any of the conditions are true.
What is the purpose of the comparison operator (<>) in Tableau?
Answer: The comparison operator (<>) in Tableau is used to check if two values or fields are not equal. It returns a Boolean value of true if the values are not equal and false if they are equal.
What is the purpose of the string operator (CONTAINS) in Tableau?
Answer: The string operator (CONTAINS) in Tableau is used to check if a string value contains a specific substring. It returns a Boolean value of true if the substring is found and false if it is not.
What is the purpose of the logical operator (NOT) in Tableau?
Answer: The logical operator (NOT) in Tableau is used to negate a logical expression. It returns true if the expression is false and false if the expression is true.
Logical & Aggregate Functions
What does the IF function in Tableau do?
Answer: The IF function in Tableau allows you to perform conditional logic. It evaluates a specified condition and returns one value if the condition is true, and another value if the condition is false.
What is the purpose of the AND function in Tableau?
Answer: The AND function in Tableau is a logical function that returns true if all the specified conditions are true. It is commonly used to combine multiple conditions in a logical expression.
What is the purpose of the SUM function in Tableau?
Answer: The SUM function in Tableau is an aggregate function that calculates the sum of a specified field or expression. It is used to perform numerical summation within a given data set or scope.
How does the MIN function in Tableau work?
Answer: The MIN function in Tableau is an aggregate function that returns the smallest value from a specified field or expression. It is used to find the minimum value within a given data set or scope.
What does the OR function in Tableau do?
Answer: The OR function in Tableau is a logical function that returns true if any of the specified conditions are true. It is commonly used to combine multiple conditions in a logical expression.
How does the COUNT function in Tableau work?
Answer: The COUNT function in Tableau is an aggregate function that counts the number of non-null values from a specified field. It is used to determine the cardinality or size of a data set.
What is the purpose of the NOT function in Tableau?
Answer: The NOT function in Tableau is a logical function that negates a given condition. It returns true if the condition is false, and false if the condition is true.
How does the AVG function in Tableau work?
Answer: The AVG function in Tableau is an aggregate function that calculates the average or mean value from a specified field or expression. It is used to determine the central tendency of a set of numerical data.
What does the IFNULL function in Tableau do?
Answer: The IFNULL function in Tableau allows you to replace null values with a specified alternative value. It checks if a value is null and returns the alternative value if it is, or the original value if it is not.
What is the purpose of the MAX function in Tableau?
Answer:The MAX function in Tableau is an aggregate function that returns the largest value from a specified field or expression. It is used to find the maximum value within a given data set or scope.
