Deloitte 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. LOD usage, filter actions
Add your answer
Q2. Basic sql queries
Add your answer

Q1. Tableau used cases
Ans. 
Tableau is used for data visualization and analysis in various industries such as finance, healthcare, retail, and marketing.
• Helping businesses track key performance indicators (KPIs)

• Creating interactive dashboards for real-time data analysis

• Identifying trends and patterns in data for informed decision-making

• Visualizing sales data to identify opportunities for growth

• Analyzing patient outcomes in healthcare to improve t
Answered by AI
Add your answer
Q2. LOD calculations
Add your answer

Q1. 1: what is measure and dimension? 2: live/extract filter? 3: join vs blending? 4: relationship? 5: practical use of quick table and compute using 6: LOD : Types and their application? 7: filter? 8: parame...read more
Ans. 
Tableau Developer interview questions covering measures, dimensions, filters, joins, LOD, parameters, and scheduling.
• Measures are quantitative data (e.g. sales, profit) while dimensions are categorical data (e.g. region, product category).

• Live filters apply to the data source directly, while extract filters apply after the data is extracted.

• Joins combine data from different tables based on a common field, while blendin...read more
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

My projects I have worked on.

Every details about my projects machine learning algorithms I have worked on detailed discussion about the algorithms.

How to handle missing values?

How to handle outliers?

Best technique handle missing values?

Neural networks, architectures, Why and Which Neural Network you have used. Why not the other one.

Q1. What are outliers and how to handle this?
Ans. 
Outliers are data points that deviate significantly from the rest of the data. They can be handled by removing, transforming or imputing them.
• Outliers can be detected using statistical methods like Z-score, IQR, or visual methods like box plots.

• Removing outliers can lead to loss of information, so transforming or imputing them is preferred.

• Transforming outliers can be done by applying mathematical functions like log, s...read more
Answered by AI
Add your answer
Q2. What is CNN? How to use it?? No of layers you have used in your case? Ensemble techniques
Ans. 
CNN stands for Convolutional Neural Network, used for image classification and object recognition.
• CNN is a type of neural network that uses convolutional layers to extract features from images.

• It is commonly used for image classification and object recognition tasks.

• CNNs can have multiple layers, including convolutional, pooling, and fully connected layers.

• The number of layers used depends on the complexity of the task...read more
Answered by AI
Add your answer