Knight Frank Business Analyst Interview Questions and Answers

Q1. Basic of sql and excel
Add your answer
Q2. What is joins and types oj joins
Ans. 
Joins are used in databases 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 t...read more
Answered by AI
Add your answer

Manager round general questions about joining

Q1. Tell about yourself
Add your answer

Some basic sql questions

Q1. How many spheres can be accomadated in a bus if dimensions provided?
Ans. 
The number of spheres that can be accommodated in a bus depends on the dimensions of the bus and the size of the spheres.
• Calculate the volume of the bus using its dimensions

• Calculate the volume of a sphere using its radius

• Divide the volume of the bus by the volume of a sphere to get the maximum number of spheres that can fit
Answered by AI
Add your answer

They gave us 2 case studies to build DCF model from scratch for 2 assets classes.

Q1. Technical questions pertaining to Intangible asset class Valuation
Add your answer

Q1. Technical round
Add your answer

Online assessment around 30-50mins

Q1. Interview screening
Add your answer

Q1. Client via involved via web meet
Add your answer

Q1. Poters 5 force mdodel
Add your answer
Q2. Describe ansoff matrix
Ans. 
Ansoff Matrix is a strategic planning tool that helps businesses decide their growth strategy by analyzing market penetration, market development, product development, and diversification.
• Ansoff Matrix was developed by Igor Ansoff in 1957.

• It consists of four growth strategies: market penetration, market development, product development, and diversification.

• Market penetration involves selling more of the existing produc...read more
Answered by AI
Add your answer

Q1. What irritate you most
Ans. 
I find inefficiency and lack of communication in teams to be particularly frustrating, as they hinder productivity and collaboration.
• Irritation with unclear project goals can lead to wasted time and resources. For example, if team members are not aligned on objectives, it can result in duplicated efforts.

• Poor communication can create misunderstandings. For instance, if data requirements are not clearly communicated, it...read more
Answered by AI
Add your answer
Q2. What is moto in your life
Ans. 
My life motto is to embrace challenges as opportunities for growth and learning, fostering resilience and adaptability.
• Embrace challenges: For instance, when faced with a difficult project, I see it as a chance to enhance my skills.

• Continuous learning: I dedicate time each week to learn new data analysis tools and techniques.

• Resilience: After setbacks, I reflect on what went wrong and how I can improve for the future.
Answered by AI
Add your answer
Q3. How will you handle customer
Ans. 
Handling customers involves effective communication, understanding their needs, and providing timely solutions.
• Listen actively to understand customer concerns and needs.

• Use data analysis to identify trends in customer feedback and behavior.

• Provide clear and concise information to address customer inquiries.

• Follow up with customers to ensure their issues are resolved satisfactorily.

• Utilize CRM tools to track interaction
Answered by AI
Add your answer

Q1. Valuation meanings and advance excels plus powerbi
Add your answer

Q1. Situational Questions
Add your answer
Q2. Do you have any experience in real estate
Add your answer