Tech Mahindra Tableau Developer Interview Questions and Answers

Q1. One round interview
Add your answer
Q2. Good questions
Add your answer

Q1. Good questions on Tableau
Add your answer
Q2. Good questions on visualization
Add your answer

Q1. Top 5 and Bottom 5 customer
Add your answer
Q2. Flag for data not updated
Ans. 
Create a flag to identify data that has not been updated
• Add a new column in the dataset called 'Updated Flag'

• Use a formula to check if the data has been updated recently

• For example, if the last update date is more than 30 days ago, set the flag to 'Not Updated'
Answered by AI
Add your answer

Q1. What is the order of operations of the Tableau filters?
Ans. 
The order of operations of Tableau filters is context filters, extract filters, data source filters, and then dimension filters.
• Context filters are applied first, followed by extract filters, data source filters, and finally dimension filters.

• Context filters create a temporary table that only includes the data relevant to the filter.

• Extract filters are applied to the data extract before it is loaded into Tableau.

• Data s...read more
Answered by AI
Add your answer
Q2. What is a context filter?
Ans. 
A context filter is a filter that is applied to a specific worksheet or dashboard, affecting only the data displayed in that context.
• Context filters are used to filter data at a more granular level within a worksheet or dashboard.

• They allow users to focus on specific data points without affecting the overall data set.

• Context filters can be created by right-clicking on a field in the Filters shelf and selecting 'Add to ...read more
Answered by AI
Add your answer
Q3. What do you mean by rolling 3,6,12 months? How it is different than YTD, MTD, QTD?
Ans. 
Rolling 3, 6, 12 months refers to analyzing data over the past 3, 6, or 12 months, while YTD, MTD, QTD refer to year-to-date, month-to-date, quarter-to-date.
• Rolling 3, 6, 12 months involves looking at data over the past 3, 6, or 12 months, providing a trend analysis over a specific time period.

• YTD (Year-to-Date) refers to data from the beginning of the current year up to the present date.

• MTD (Month-to-Date) refers to d...read more
Answered by AI
Add your answer
Q4. How will you calculate %YoY growth?
Ans. 
To calculate %YoY growth, subtract the previous year's value from the current year's value, divide by the previous year's value, and multiply by 100.
• Calculate YoY growth = ((Current Year Value - Previous Year Value) / Previous Year Value) * 100

• For example, if sales were $100 in 2020 and $120 in 2021, YoY growth = (($120 - $100) / $100) * 100 = 20%
Answered by AI
Add your answer

Q1. Live and Extract
Add your answer
Q2. Scenario Donut chart
Add your answer
Q3. LOD Scenario use case
Add your answer
Q4. Difference between rank and dense rank
Ans. 
Rank assigns unique ranks to each row, while dense rank assigns consecutive ranks without gaps.
• Rank leaves gaps in rank numbers if there are ties, while dense rank does not

• Rank function is non-consecutive, while dense rank function is consecutive

• Rank function can skip numbers, while dense rank function does not
Answered by AI
Add your answer
Q5. 2nd highest salary
Add your answer

Basic Level questions about Tableau

Q1. Types of LODs in Tableau
Ans. 
Types of LODs in Tableau include Fixed, Include, and Exclude.
• Fixed LOD: Computes a value using specified dimensions, regardless of the visualization level.

• Include LOD: Computes a value at a specified level of detail, including dimensions not in the visualization.

• Exclude LOD: Computes a value at a specified level of detail, excluding dimensions not in the visualization.
Answered by AI
Add your answer

Logical reasoning , verbal ability and quantitative ability

Q1. How to create dashboards
Ans. 
Creating dashboards involves selecting relevant data, designing visualizations, and arranging them in a user-friendly layout.
• Identify key metrics and data sources to include in the dashboard

• Design appropriate visualizations such as bar charts, line graphs, and maps

• Arrange visualizations in a logical and intuitive layout

• Use filters and parameters to allow users to interact with the data

• Add annotations and titles to prov
Answered by AI
Add your answer

Q1. Where do you see yourself in 5 years
Add your answer

Q1. Tell me about Architecture of Tableau?
Ans. 
Tableau follows a client-server architecture with a three-tier structure.
• Tableau Desktop is the client application used for creating and publishing content.

• Tableau Server is the central server that manages user authentication, data sources, and content distribution.

• Tableau Online is a cloud-based version of Tableau Server.

• Tableau's three-tier structure includes the data source, the VizQL server, and the application ser...read more
Answered by AI
Add your answer
Q2. What are different filters in tableau?
Ans. 
Different filters in Tableau include dimension filters, measure filters, top N filters, wildcard filters, and context filters.
• Dimension filters allow users to filter data based on categorical variables.

• Measure filters allow users to filter data based on numerical variables.

• Top N filters allow users to filter data based on the top or bottom N values.

• Wildcard filters allow users to filter data based on patterns or partia...read more
Answered by AI
View 1 more answer