Trell Business Analyst Interview Questions and Answers

Q1. Tell me about yourself
Add your answer

Q1. About the industry
Add your answer

SQL test coding assessment which I am yet to give

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

Mostly sql question asked, moderate level

Q1. Sql join and sub query
Add your answer
Q2. Window functions
Add your answer

SQL And Excel Test with Intermidiate to Entry level questions

SQL Test with questions on Window fx and logic

Case on various company and there problems

Q1. Why revenue of Flipkart dropped 20% in December, Compared to November.
Ans. 
The drop in Flipkart's revenue in December compared to November can be attributed to seasonal factors, promotional activities, or changes in consumer behavior.
• Seasonal factors such as holiday sales in November leading to higher revenue compared to December

• Promotional activities like Black Friday or Cyber Monday driving higher sales in November

• Changes in consumer behavior, such as delayed purchases or reduced spending a
Answered by AI
Add your answer
Q2. Why you want to join Swiggy
Ans. 
I want to join Swiggy because of its innovative technology, fast-paced environment, and impact on the food delivery industry.
• Swiggy's cutting-edge technology and data-driven approach to food delivery excites me

• I am drawn to the fast-paced and dynamic work environment at Swiggy

• Swiggy's significant impact on the food delivery industry and its rapid growth potential are appealing to me
Answered by AI
Add your answer

Q1. SQL Queries were asked, most using direct functions
Add your answer

SQL and case study and was of an hour length

Q1. Mostly SQL based questions
Add your answer

Q1. Statistics and data Visualization and SQL again
Add your answer

Q1. Job fit and more sql
Add your answer