Business Intelligence Analyst and Tableau Developer

Business Intelligence Analyst and Tableau Developer Interview Questions and Answers

Updated 25 Nov 2024

Popular Companies

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

Q2. 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([Measure])}.

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.

Q4. 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 with complex relationships.

Are these interview questions helpful?

Q5. 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 data flows, making it easier for users to understand and ...read more

Q6. 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 filters can provide users with more control over the data the...read more

Share interview questions and help millions of jobseekers 🌟

Q7. DIFF BW GROUPS AND SET

Ans.

GROUP and SET are both Tableau functions used for creating subsets of data, but GROUP is used for combining data based on a common field, while SET is used for creating custom subsets based on conditions.

GROUP is used to combine data based on a common field, such as grouping sales data by region.
SET is used to create custom subsets of data based on conditions, such as creating a set of high-value customers.
GROUP can be used to aggregate data within a specific category, while ...read more