Tecnova India Market Research Analyst Interview Questions and Answers

Regarding problem-solving

Regarding sql question

Q1. Tell me about yourself and standard tell me about a project
Add your answer

Interviewer gave business scenarios and asked what will do in this problem statement

Q1. Asked sql, python query questions
Add your answer

Basic level appitude and reasoning test

Case scenario will be given to solve

Q1. General family back ground, location questions.
Add your answer

Q1. Normal questions asked
Add your answer

Q1. SQL questions were asked
Add your answer

Q1. Python, SQL, ML questions
Add your answer

Q1. About projects worked.
Add your answer

Q1. When do you use vlookup in excel
Ans. 
VLOOKUP in Excel is used to search for a value in a table and return a corresponding value from another column.
• Use vlookup to find specific data in a large dataset

• Use vlookup to merge data from different tables

• Use vlookup to create dynamic reports by pulling data from multiple sources

• Example: =VLOOKUP(A2, Sheet2!A:B, 2, FALSE) - this formula searches for the value in cell A2 in the first column of Sheet2 and returns th
Answered by AI
Add your answer
Q2. Can you explain about joins in sql
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT ...read more
Answered by AI
Add your answer

Q1. Which model is using for classification?
Ans. 
We are using the Random Forest model for classification.
• Random Forest model is an ensemble learning method that builds multiple decision trees and merges them together to get a more accurate and stable prediction.

• It is widely used for classification tasks due to its ability to handle large datasets with high dimensionality.

• Random Forest is a popular choice in machine learning for its robustness and ability to reduce ov...read more
Answered by AI
Add your answer

Q1. Salary discussion
Add your answer