Trell Business Analyst Interview Questions and Answers

8 SQL questions with increase in complexity and 1 case study

Q1. SQL and Statistics screaning
Add your answer

Q1. Business case studies, guess estimates, little technical
Add your answer

Q1. Complete profile screaning, Checking if candidate is suited for the role, case studies, guess estimates
Add your answer

Q1. Why sudden job change plan
Add your answer
Q2. Why Swiggy and what values did you see before applying
Ans. 
I chose Swiggy for its innovative technology, market leadership, and growth potential.
• Swiggy's cutting-edge technology in the food delivery industry stood out to me

• The company's strong market presence and leadership position were appealing

• I was impressed by Swiggy's rapid growth and expansion in the market

• Swiggy's customer-centric approach and focus on quality service were values I admired
Answered by AI
Add your answer

Advance SQL test conducted by hackerrank

Q1. SQL and business case questions
Add your answer
Q2. Joins and windows
Add your answer

Focus on SQL and case studies related to Swiggy's business

Q1. Didn't reach to that point
Add your answer

Hackerrank SQL questions and one case study question

Q1. SQL questions related to rank, dense rank, joins
Add your answer
Q2. Flipkart wants to replace its payment options from credit card to upi. so what will be the null and the alternate hypothesis for this. and what will be the metrics to check
Add your answer

Q1. Your uber rating is 4.2. for your first 80 rides. uber has started a new scheme where they give additional 10% of to those customers who have a rating of 4.5 and above. what is the minimum number of trips ...read more
Ans. 
The minimum number of trips required to achieve a rating of 4.5 is 20.
• To calculate the minimum number of trips required, we need to find the difference between the current rating and the desired rating.

• Since the desired rating is 4.5 and the current rating is 4.2, the difference is 0.3.

• Each trip contributes to the rating, so we need to divide the difference by the rating increment per trip.

• The rating increment per trip...read more
Answered by AI
View 5 more answers
Q2. Flipkart's this week sales was lesser than last week. there was no schemes run by its competitors. so what metrics will you check and also come up with a framework for it
Add your answer
Q3. Myntra which is only offline now wants to make its presence offline. using myntra data, which city will it open the outlet
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

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

Q1. Ques.1 How many delivery boy have called customers more than 5 times?
Ans. 
The number of delivery boys who called customers more than 5 times is not provided.
• Data on the number of delivery boys who called customers more than 5 times is missing.

• Need to gather data on the number of delivery boys and their call logs.

• Analysis can be done once the data is available.
Answered by AI
View 5 more answers
Q2. Question 2. Count distinct uniques names from the table
Ans. 
To count distinct unique names from a table, use the SELECT DISTINCT statement with the name column.
• Use SELECT DISTINCT to retrieve unique names

• Specify the name column in the SELECT statement

• Example: SELECT DISTINCT name FROM table_name

• Store the result in an array of strings
Answered by AI
Add your answer