KhataBook Lead Business Analyst Interview Questions and Answers

Q1. Joins outputs for various types of joins
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• 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 JOIN returns all rows from the right table and the matched rows from the left table

• FU...read more
Answered by AI
Add your answer
Q2. Query using window functions
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are used in SQL to perform calculations on a set of rows related to the current row.

• They allow you to perform calculations like ranking, moving averages, and cumulative sums.

• Examples of window functions include ROW_NUMBER(), RANK(), and SUM() OVER().
Answered by AI
Add your answer

Q1. Introduction abt yourself
Ans. 
Experienced business development executive with a proven track record of driving revenue growth and building strong client relationships.
• Over 5 years of experience in business development roles

• Successfully increased sales by 30% in previous position

• Skilled in identifying new business opportunities and negotiating contracts

• Strong communication and interpersonal skills

• Bachelor's degree in Business Administration
Answered by AI
Add your answer
Q2. Demo how to convince a customer to buy the product
Ans. 
To convince a customer to buy the product, highlight the benefits, address their needs, provide social proof, and offer a special promotion.
• Highlight the key benefits of the product that meet the customer's needs

• Address any concerns or objections the customer may have

• Provide social proof such as testimonials or case studies to build credibility

• Offer a special promotion or discount to incentivize the purchase
Answered by AI
Add your answer

Q1. Brief abt the company
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Resume walkthrough
Add your answer

Case study based on take home assignment about product analysis

Q1. Personal discussion about culture fit
Add your answer

Case study and output presentation

Q1. Scenario based question on work ethics
Add your answer
Q2. Previous work experience and roles
Add your answer

Excel question
Excel case study

Case study of Rupeek website

Q1. Basic questions on joins and aggregate functions.
Add your answer
Q2. Basic theoretical sql questions
Add your answer

Q1. Basic questions on python
Add your answer

Case studies about Navi UPI

Case studies about Navi UPI App

Quantitative case study on cost benefit analysis of 2 types of public buses running in a city. Need to choose one of them with higher profits

Fraud detection model: 3rd party firm proposing to use thier model for fraud detection. Need to profit analysis of whether to go for it or not.

Q1. Culture fit round to understand if compatible with the company
Add your answer