RedBus 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

Basic RCA question to diagnose falling numbers in a matrix.

Basic left join, right join, sub query, ranking etc.

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

Q1. SQL QUERY QUESTIONS ON JOINS
Add your answer

Q1. Excel basic formulas like lookup
Add your answer

Q1. About Yourself, resume grilling
Add your answer

Python, SQL, Quant, Statistics, Numpy

Q1. SQL, Python, Puzzle total 9Q
Add your answer
Q2. Table, Query, 2 puzzle, Python 1 code (4 Sub code)
Add your answer

Q1. Yet to declare result for the round 2 i feel +ve for round 2 result lets se
Add your answer

MCQ Mostly - Aptitude and Time Distance

RCA - Drop in Metrics

Q1. SQL & Pythonassad
Add your answer