Digimetrix Technologies Power BI and Tableau Developer Interview Questions and Answers

Q1. Ask about filters
Add your answer
Q2. What are all the maps used in tableau
Add your answer
Q3. Difference between tree map and heat map
Add your answer
Q4. What are Lods used
Add your answer
Q5. Windows analytical function
Add your answer
Q6. Real time question connecting to the data source facing any issues
Add your answer
Q7. Any other bi tool you know
Add your answer
Q8. What is groups and sets and when to you use
Add your answer
Q9. Data source filter
Add your answer
Q10. Handle null values
Add your answer

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. 1. Joins - asked a little question regarding different joins and how duplicates in a table will impact the counts while joining. 2. Tableau related - Basics - Parameters, how will you create a visualizatio...read more
Add your answer

Q1. In-depth Technical here. 1. Parameters in detail. 2. LODs 3. SETS. 4. How will you move b/w visualizations. 5. Data Blending
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. What are LODS, rank functions
Ans. 
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
Answered by AI
Add your answer
Q2. Tell me about yourself
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