Ernst & Young Tableau Developer Interview Questions and Answers

Q1. Top and Bottom in one sheet
Ans. 
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
Answered by AI
Add your answer
Q2. Usage of parameter and filters
Ans. 
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
Answered by AI
Add your answer
Q3. Types of LOD and its use case
Ans. 
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.
Answered by AI
Add your answer
Q4. Performance Optimization
Add your answer

Q1. Project Overview and Size
Add your answer
Q2. Performance Optimization
Add your answer
Q3. Open for work in different technologies
Add your answer

Q1. Introduction and Role
Add your answer
Q2. Tableau Prep and its usage
Ans. 
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
Answered by AI
Add your answer
Q3. Snowflake vs Star Schema
Ans. 
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
Answered by AI
Add your answer

Q1. Find Top 5 and Botton 5 sales in same sheet
Ans. 
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
Answered by AI
Add your answer
Q2. User safety filter
Add your answer

Medium leetcode and basic SQL queries

Questions related to previous Project work, ML system design, model performance metrics

Q1. Focus on business outcomes and metrics, problem identification and understanding a possible scenario for choosing the right approach to solve the problem using algorithm/ general rules
Add your answer

Q1. Order of execution
Ans. 
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
Answered by AI
Add your answer
Q2. Window functions
Add your answer

Q1. 1. Joins - asked a little question regarding different joins and how duplicates in a table will impact the counts while joining. 2. Tableau related - Basics - Parameters, how will you create a visualizatio...read more
Add your answer

Q1. In-depth Technical here. 1. Parameters in detail. 2. LODs 3. SETS. 4. How will you move b/w visualizations. 5. Data Blending
Add your answer

Q1. What is parameters
Ans. 
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.
Answered by AI
Add your answer
Q2. Action filters with detail
Ans. 
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
Answered by AI
Add your answer

Q1. Row level security
Add your answer
Q2. SQL queries basic
Add your answer

Q1. Brief introduction project details
Add your answer

Q1. Order of execution
Ans. 
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
Answered by AI
Add your answer
Q2. Window functions
Add your answer