Nisa College Chennai Qlikview 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. 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. 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. 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

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

Problem solving skills

Logical reasoning numerical reasoning abstract reasoning verbal reasoning

Q1. Self introduction
Add your answer
Q2. Family background
Add your answer
Q3. Salary expectation
Add your answer