Deloitte 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

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

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

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