Exl India Tableau Developer Interview Questions and Answers

Q1. Basic concepts on tableau
Add your answer
Q2. Lod concepts
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. Live vs extract connection
Ans. 
Live connection allows real-time data updates while extract connection improves performance by storing data locally.
• Live connection connects directly to the data source for real-time updates.

• Extract connection stores a snapshot of the data locally for faster performance.

• Live connection is suitable for small datasets or when real-time updates are crucial.

• Extract connection is recommended for large datasets or when perfo
Answered by AI
Add your answer
Q2. Joins vs blending
Ans. 
Joins are used to combine data from different tables based on a related column, while blending is used to combine data from different data sources within the same worksheet.
• Joins are used when you have related data in different tables and want to combine them based on a common column.

• Blending is used when you have data from different sources like Excel and SQL and want to combine them in the same worksheet.

• Joins requir...read more
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

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