Ernst & Young Tableau Developer and Business Analyst Interview Questions and Answers

Use LOD calculations to display top and bottom values in one sheet in Tableau.

• Use Level of Detail (LOD) calculations to create separate calculated fields for top and bottom values.

• Use these calculated fields in the same sheet to display both top and bottom values.

• For example, create a calculated field for top values using {FIXED [Dimension]: MAX([Measure])} and another for bottom values using {FIXED [Dimension]: MIN([M

Parameters and filters are key features in Tableau for dynamic data analysis and visualization.

• Parameters allow users to input values that can be used in calculations, filters, and reference lines.

• Filters are used to limit the data displayed in a visualization based on specified criteria.

• Parameters can be used to create dynamic filters that allow users to interact with the data in real-time.

• Combining parameters and fil...read more

Types of LOD include Fixed, Include, and Exclude LOD calculations for different use cases.

• Fixed LOD: Used to ignore the level of detail in the view and compute an aggregate value.

• Include LOD: Used to compute an aggregate value at a higher level of detail than the view.

• Exclude LOD: Used to compute an aggregate value at a lower level of detail than the view.

Tableau Prep is a data preparation tool that allows users to clean, combine, and shape data for analysis in Tableau.

• Tableau Prep helps in cleaning and transforming data before visualizing it in Tableau Desktop.

• It allows users to easily combine multiple data sources and perform data cleaning tasks like removing duplicates, splitting columns, and aggregating data.

• Tableau Prep also provides a visual interface for creating...read more

Snowflake schema is a normalized form of Star schema with multiple levels of dimension tables.

• Snowflake schema has normalized dimension tables, while Star schema has denormalized dimension tables.

• Snowflake schema is more complex and requires more joins compared to Star schema.

• Star schema is easier to understand and query, making it more suitable for smaller datasets.

• Snowflake schema is more suitable for larger datasets

Use Tableau to create a sheet displaying the top 5 and bottom 5 sales.

• Create a new worksheet in Tableau

• Drag the sales measure to the Rows shelf

• Sort the sales measure in descending order

• Limit the view to show only the top 5 sales

• Duplicate the sheet and change the sort order to ascending to show the bottom 5 sales

Parameters in Tableau are dynamic values that can be used to filter, group, or control the data displayed in a visualization.

• Parameters allow users to change the view of the data without modifying the underlying data source.

• They can be used in calculations, filters, and reference lines.

• For example, a parameter can be created to allow users to select a specific date range to view in a dashboard.

Action filters allow users to interact with visualizations by selecting data points to filter other views.

• Action filters are used to filter data in one visualization based on selections in another visualization.

• They can be set up to filter data at the worksheet, dashboard, or story level.

• For example, clicking on a bar chart can filter a map to show only data related to the selected bar.

• Action filters can be set to incl

Order of execution in Tableau determines the sequence in which calculations are performed.

• Filters are applied first

• Then calculations are performed

• Aggregations are computed next

• Table calculations are executed last