Illusion Technologies Data Analyst Interview Questions and Answers

Questions on string arrays

Basic computer knowledge, English grammar

Q1. Tell me about yourself Common question
Add your answer
Q2. Tell me about yourself
Add your answer
Q3. Common topic we say about that topic
Add your answer
Q4. Testing english knowledge
Add your answer

Q1. Just observe how we work
Add your answer

Q1. What is bias variance tradeoff in machine learning
Ans. 
Bias-variance tradeoff is the balance between underfitting and overfitting in machine learning models.
• Bias refers to error from erroneous assumptions in the learning algorithm, leading to underfitting.

• Variance refers to error from sensitivity to small fluctuations in the training set, leading to overfitting.

• The tradeoff involves finding the right level of model complexity to minimize both bias and variance.

• Regularizati...read more
Answered by AI
Add your answer
Q2. Explain your project
Add your answer
Q3. Write a SQL code to find 2nd highest salary
Ans. 
SQL code to find 2nd highest salary
• Use the MAX() function to find the highest salary

• Use the WHERE clause to exclude the highest salary

• Order the salaries in descending order and limit the result to 1
Answered by AI
Add your answer

Typing data off mobile

Coding AB C any code

Sql Coding round questions were asked

Q1. SQL coding round
Add your answer

Q1. Sql Coding round
Add your answer

Q1. Basic questions salary expectations
Add your answer

Questions on string arrays

Q1. What are your strengths and weaknesses?
Add your answer
Q2. What is your family background?
Add your answer
Q3. Tell me about yourself.
Add your answer

Q1. Basic questions on our previous work experince
Add your answer
Q2. What are the charters you have worked on
Add your answer

Q1. Some technical questions on excel and sql
Add your answer