Square Yards Business Analyst Interview Questions and Answers

Technical + Analytics
I gave my coding test this august 2024, it was purely based on SQL coding
8 question, 3 easy, 3 intermediate and 3 hard.

Q1. Introduction and explain any one of the projects plus what was the analytics you used
Ans. 
Implemented a project to optimize marketing campaigns using predictive analytics
• Developed a predictive model to identify the most effective marketing channels

• Utilized data from past campaigns to train the model

• Used techniques such as regression analysis and decision trees to analyze the data

• Generated insights on customer behavior and preferences to improve campaign targeting
Answered by AI
Add your answer
Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.
Add your answer

Q1. SQL Question using window functions
Add your answer
Q2. Guesstimate on Number of McD orders
Ans. 
The number of McDonald's orders can be estimated based on factors like location, time of day, and day of the week.
• Consider the population density of the area where the McDonald's is located

• Take into account the time of day - more orders during meal times

• Factor in the day of the week - weekends may have higher order volumes

• Look at historical data or industry averages for similar locations

• Consider any promotions or speci
Answered by AI
Add your answer

Q1. Sql Medium Level questions
Add your answer
Q2. Easy guesstimates were asked
Add your answer

Q1. Caee Study was asked
Add your answer
Q2. Resume grilling was done
Add your answer

Q1. Why you want to join Ola ?
Ans. 
I want to join Ola because of its innovative technology, market leadership, and potential for growth.
• Ola is a market leader in the ride-sharing industry, which presents exciting challenges and opportunities for a business analyst.

• I am impressed by Ola's focus on innovation and technology, which aligns with my passion for leveraging data and analytics to drive business decisions.

• I believe Ola's fast-paced environment an...read more
Answered by AI
Add your answer
Q2. Salary Negotiation was done
Add your answer

Q1. What work have you done in previous company
Ans. 
I have worked on various projects including data analysis, process improvement, and system implementation.
• 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 stakeholders to map out current processes and identify areas for improvement

• Created detailed documentation outlining project requ
Answered by AI
Add your answer

Basis CAT like aptitude with 2 simple python coding question

Q1. What Central limit theorem
Ans. 
The Central Limit Theorem states that the sampling distribution of the sample mean approaches a normal distribution as the sample size increases.
• States that the sampling distribution of the sample mean will be approximately normally distributed regardless of the shape of the population distribution

• Helps in making inferences about the population mean based on the sample mean

• Important concept in statistics and hypothesis...read more
Answered by AI
Add your answer

Q1. More about your role and insurance based questions
Add your answer

Q1. More about insurance based and brd, requirements gathering, sdlc
Add your answer

Written test, asked to write queries on paper for given questions

Medium difficultty on pandas SQL

Q1. Coding interview python pandas medium difficulty
Ans. Solved it and had to discuss with manager
Answered by govind goel
Add your answer