Upload Button Icon Add office photos

Filter interviews by

Trell Business Analyst Interview Questions and Answers

Updated 8 Nov 2021

Trell Business Analyst Interview Experiences

1 interview found

I applied via Job Portal and was interviewed in Oct 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SQL queries, Date related manipulations in Excel and SQL

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL and Excel well w.r.t ecommerce domain and what might be the day to day activities or requirements.

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself
Round 2 - One-on-one 

(1 Question)

  • Q1. About the industry

Interview Preparation Tips

Interview preparation tips for other job seekers - Have an idea about the travel industry before you go for the interview.

I applied via Referral and was interviewed before Nov 2018. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Advanced sql queries related to dense rank, row num, self joins, pivoting, case studies, visualization questions, puzzles, questions on probability

Interview Preparation Tips

Interview preparation tips for other job seekers - Relax and go with open minds

I applied via Referral and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How can you understand the supply of restaurant in a particular area of a city ?
  • Ans. 

    To understand the supply of restaurants in a particular area of a city, we can use various methods.

    • Collect data from online directories like Yelp, Zomato, etc.

    • Conduct surveys to gather information about the number of restaurants in the area.

    • Analyze the population density and demographics of the area to estimate the demand for restaurants.

    • Check the number of restaurant permits issued by the local government.

    • Use GIS mapp...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand any city's demographics for instance. Take most busy road and assume that 70% supply will be on food -tech (MArket Standard). Open Sw / Zo and see the supply available in that area in peak time. There can be more than one way to solve for these question

I was interviewed in Mar 2021.

Interview Questionnaire 

4 Questions

  • Q1. Sql, A/B testing, case study about how to increase sales in particular area, what are the metrics that effect sales.
  • Q2. Steps involved in analysis of decrease in sales for particular area
  • Ans. 

    Steps involved in analyzing decrease in sales for a particular area

    • Identify the time period for which sales have decreased

    • Analyze the sales data for the area and compare it with previous periods

    • Identify any external factors that may have contributed to the decrease in sales

    • Conduct customer surveys to identify any issues with products or services

    • Analyze competitor activity in the area

    • Develop a plan to address the issues...

  • Answered by AI
  • Q3. Write sql query to find mean waiting period for delivery partner given driver I'd, ordered time and delivered time.
  • Ans. 

    SQL query to find mean waiting period for delivery partner given driver ID, ordered time and delivered time.

    • Use AVG function to calculate mean waiting period

    • Subtract ordered time from delivered time to get waiting period

    • Filter data by driver ID and delivery partner

    • Group by delivery partner

  • Answered by AI
  • Q4. Write query for rolling sum
  • Ans. 

    Rolling sum query adds up a specified number of rows in a table based on a given condition.

    • Use the OVER() function to specify the window frame for the rolling sum.

    • Specify the number of rows to include in the window frame using ROWS BETWEEN.

    • Use ORDER BY to specify the order of rows in the window frame.

    • Example: SELECT column1, SUM(column2) OVER (ORDER BY column1 ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FR

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for SQL, you have to be strong in SQL.
there will be two round one sql and other cae study

Skills evaluated in this interview

I was interviewed in Nov 2021.

Round 1 - Video Call 

(1 Question)

Round duration - 60 minutes
Round difficulty - Easy

Prepare well for SQL, you have to be strong in SQL. Questions related to SQL and A/B testing were asked.

  • Q1. Can you write a query to calculate the rolling sum?
  • Ans. 

    Query to calculate rolling sum

    • Use window functions like SUM() OVER() in SQL

    • Specify the window frame to define the range for the rolling sum

    • Example: SELECT date, value, SUM(value) OVER (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FROM table_name

  • Answered by AI

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPASwiggy interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPS, Database and SQLTime required to prepare for the interview - 3 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Prepare well for SQL, you have to be strong in SQL.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Questions were from SQL, Python, Statistics & Business Case Studies/Metrics in the form of 4-5 rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - So Key Takeaway is You have to be good with your Technical Knowledge (SQL Expert, Python, Overall Stats Knowledge) and That is not really enough. What differs a Business Analyst from other Developers/Statisticians etc. is Business acumen, Problem Solving Skills etc. To have a Business Knowledge and Understanding such that you find the problems/solutions/ Metrics and then solve them using the Technology.

Interview Questionnaire 

1 Question

  • Q1. How much work experience
  • Ans. 

    The amount of work experience is an important factor in determining the suitability of a candidate for the Business Analyst role.

    • Work experience helps in developing a deep understanding of business processes and industry trends.

    • It allows the candidate to gain practical knowledge and skills in data analysis, problem-solving, and project management.

    • Having relevant work experience demonstrates the ability to work effectiv...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview ended after the ist question

I applied via Referral and was interviewed before Mar 2021. There were 4 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Types of Joins in SQL, minimum and maximum number of rows possible from these joins
  • Ans. 

    Types of SQL joins and their minimum and maximum possible rows.

    • Types of joins: Inner, Left Outer, Right Outer, Full Outer, Cross

    • Minimum rows: Inner - 0, Left/Right Outer - 1, Full Outer - 0, Cross - product of rows

    • Maximum rows: Inner/Left/Right/Full Outer - product of rows, Cross - product of rows

  • Answered by AI
  • Q2. Mean, median, mode, measures of central tendency
Round 2 - Case Study 

1.Features you would look for if you have to buy an elevator
2. How do you estimate the number of trains passing through a station

Round 3 - Behavioral 

(1 Question)

  • Q1. Why do you want to join swiggy ? What are your plans for upcoming years ?
Round 4 - HR 

(1 Question)

  • Q1. What are your salary expectations?

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident and don't behave cocky. At Swiggy, candidate attitude and team fit is given a lot of importance.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
2-4 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Sep 2023. There were 4 interview rounds.

Round 1 - Coding Test 

SQL and case study and was of an hour length

Round 2 - Technical 

(1 Question)

  • Q1. Mostly SQL based questions
Round 3 - Technical 

(1 Question)

  • Q1. Statistics and data Visualization and SQL again
Round 4 - Behavioral 

(1 Question)

  • Q1. Job fit and more sql

Trell Interview FAQs

How to prepare for Trell Business Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Trell. The most common topics and skills that interviewers at Trell expect are Analytics, Data Analytics, Data Modeling, Python and SQL.

Tell us how to improve this page.

Trell Business Analyst Salary
based on 13 salaries
₹6 L/yr - ₹18 L/yr
32% more than the average Business Analyst Salary in India
View more details

Trell Business Analyst Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

3.0

Skill development

3.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Content Moderator
23 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Executive
17 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Analyst
13 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Content Strategist
13 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Program Manager
10 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Trell with

Thrillophilia

3.8
Compare

Cleartrip

3.4
Compare

MakeMyTrip

3.6
Compare

Yatra

3.4
Compare
Did you find this page helpful?
Yes No
write
Share an Interview