Travclan Technology India Business Development Intern Interview Questions and Answers

New market launch strategy

SQL intermediate level

Q1. Tell me about your self. Tell about past background. About education and past employment.
Add your answer
Q2. Advance Excel questions.
Add your answer

Q1. Business Analyst Related Questions, KPI details on live use cases
Ans. Provide metric and solution how it would solve the usecase
Answered Anonymously
Add your answer

Q1. Team Management questions and Aptitude questions
Add your answer

Q1. Basic analytical question
Add your answer

Q1. Why do we hire you ?
Add your answer
Q2. How can you be helpful to organisation?
Ans. 
I can be helpful to the organization by analyzing data, identifying trends, and providing insights to support decision-making.
• Conduct thorough data analysis to identify patterns and trends

• Generate reports and presentations to communicate findings to stakeholders

• Collaborate with cross-functional teams to provide insights and recommendations

• Utilize tools such as Excel, SQL, and Tableau to analyze and visualize data
Answered by AI
Add your answer

SQL and python questions on group by , joins and pivot were asked .

Q1. How SQL joins work ?
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• SQL joins are used to retrieve data from multiple tables based on a related column between them.

• Types of SQL 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 rig...read more
Answered by AI
Add your answer
Q2. How group by function works ?
Ans. 
Group by function is used to group data based on a specific column or expression.
• Group by function is used in SQL to aggregate data based on a specific column.

• It is often used with aggregate functions like SUM, COUNT, AVG, etc.

• For example, SELECT department, SUM(salary) FROM employees GROUP BY department will group employees by department and calculate the total salary for each department.
Answered by AI
Add your answer

Q1. Asked me to write a complex SQL query and 2-3 questions from Advanced excel.
Add your answer

Q1. Can you explain your previous projects and work experience?
Ans. 
I have worked on various projects as a Business Analyst, including data analysis, process improvement, and stakeholder management.
• Led a team in analyzing sales data to identify trends and opportunities for growth

• Implemented a new CRM system to streamline customer interactions and improve efficiency

• Collaborated with cross-functional teams to develop and implement process improvements

• Conducted market research to identify
Answered by AI
Add your answer