KPMG India Business Intelligence Analyst and Tableau Developer Interview Questions, Process, and Tips

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

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.

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

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