Fella Homes Business Analyst Interview Questions and Answers

Q1. Self introduction
Add your answer
Q2. Introduction about me
Add your answer
Q3. Working experience
Add your answer
Q4. Target and achievements
Add your answer

Q1. Working experience
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

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

Q1. Asked each and every thing from cv and some estimate questions
Add your answer

Q1. About previous experience and some basic questions.
Add your answer

Q1. About basic to advance level of Excel, power bi
Add your answer

Q1. No question: referral.
Add your answer

Q1. Why would you like to work for us?
Add your answer

Q1. About your slef and skil
Add your answer
Q2. What is MVC and architecture of CI
Ans. 
MVC is a software design pattern that separates an application into three main components: Model, View, and Controller. CI follows the MVC architecture.
• Model represents the data and business logic of the application.

• View is responsible for displaying the data to the user.

• Controller acts as an intermediary between Model and View, handling user input and updating the Model accordingly.

• CodeIgniter (CI) is a PHP framework ...read more
Answered by AI
View 1 more answer
Q3. Advanced MySQL query with example
Ans. 
An advanced MySQL query involves using complex joins, subqueries, and functions to retrieve specific data.
• Use JOIN to combine data from multiple tables

• Utilize subqueries to retrieve data based on results from another query

• Leverage functions like COUNT, SUM, AVG for calculations

• Example: SELECT * FROM table1 JOIN table2 ON table1.id = table2.id WHERE table1.column = (SELECT column FROM table3 WHERE condition)
Answered by AI
Add your answer