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

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

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

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

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%

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.