Tableau Developer and Business Analyst Interview Questions and Answers

Practical implementation of features on Tableau Desktop

• Creating interactive dashboards

• Using calculated fields for data manipulation

• Utilizing parameters for dynamic filtering

• Incorporating advanced analytics like forecasting

• Implementing data blending for combining multiple data sources

LODS (Level of Detail Expressions) and rank functions are used in Tableau for advanced calculations and analysis.

• LODS allow you to control the level of detail in your visualization by specifying the dimensions at which you want to aggregate data.

• Rank functions like RANK(), DENSE_RANK(), and ROW_NUMBER() are used to assign a rank to each row of data based on a specified criteria.

• LODS and rank functions can be used together to create complex calculations and rankings in Tableau...read more

A Windows function store procedure is a stored procedure that can be executed in response to a Windows event.

• Windows function store procedures are used in SQL Server to execute code in response to Windows events.

• They can be used to automate tasks or trigger actions based on specific conditions.

• Examples include executing a stored procedure when a file is created or deleted, or when a specific event occurs in the Windows event log.

Blending combines data from different data sources in a single view, while joins combine data from the same data source based on a common field.

• Blending is used when data comes from different sources and cannot be joined together directly.

• Joins are used when data comes from the same source and can be combined based on a common field.

• Blending allows for combining data at different levels of granularity.

• Joins require a common field to match records from different tables.

• Example...read more

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 include or exclude data based on user selections.