Infosys Senior Tableau Developer Interview Questions and Answers

Logical, Verbal, reasoning 90 mins

Q1. ML algorithms and Explain it?
Add your answer
Q2. Print even numbers in for loop?
Add your answer

Q1. Basic Stats questions
Add your answer
Q2. Basic ML questions
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 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. Started with basic os or network fundamentals like analyzing a core dump, handling tcp packet loss, difference between rest api and grpc etc. Then, from ML started with basic questions like bias variance t...read more
Add your answer

Q1. Difference between bias and variance
Ans. 
Bias is error due to overly simplistic assumptions, variance is error due to overly complex models.
• Bias is error introduced by approximating a real-world problem, leading to underfitting.

• Variance is error introduced by modeling the noise in the training data, leading to overfitting.

• High bias can cause a model to miss relevant relationships between features and target variable.

• High variance can cause a model to be overl...read more
Answered by AI
Add your answer
Q2. What’s is Learning rate
Ans. 
Learning rate is a hyperparameter that controls how much we are adjusting the weights of our network with respect to the loss gradient.
• Learning rate determines the size of the steps taken during optimization.

• A high learning rate can cause the model to converge too quickly and potentially miss the optimal solution.

• A low learning rate can cause the model to take a long time to converge or get stuck in a local minimum.

• Com...read more
Answered by AI
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

Q1. Server components, upgradation,job fails
Add your answer

Q1. How you handle if worker node fail
Ans. 
We ensure high availability by configuring multiple worker nodes and using load balancers.
• Configure multiple worker nodes to distribute the load and ensure redundancy.

• Use load balancers to distribute the traffic among the available worker nodes.

• Monitor the worker nodes for any failures and take appropriate actions to replace or repair them.

• Ensure that the Tableau Server is configured to automatically recover from worke...read more
Answered by AI
Add your answer
Q2. Restore with single dashboard
Ans. 
To restore a single dashboard, select the dashboard from the backup file and import it to the server.
• Locate the backup file containing the dashboard

• Open Tableau Server and go to the 'Import' tab

• Select the backup file and choose the dashboard to restore

• Click 'Import' to restore the dashboard to the server
Answered by AI
Add your answer