Capgemini Tableau Developer Interview Questions, Process, and Tips

Q1. What is Slowly Changing Dimension (SCD) in Tableau?
Add your answer
Q2. Difference between historic and current data
Add your answer
Q3. LODS and types with example
Add your answer
Q4. Extract and Live Connection
Add your answer
Q5. What is an empty extract, and what is the process for creating one?
Add your answer
Q6. Window Functions
Add your answer
Q7. Context Filter
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

Basic Level questions about Tableau

Q1. Tableau working scenarios
Add your answer

Q1. SQL Queries on tableau use cases
Add your answer