Madhusudan Technologies Data Analyst and Tableau Developer Interview Questions and Answers

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'

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

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

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

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 toget...read more

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.