Upload Button Icon Add office photos

Treebo Hotels

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Treebo Hotels Data Analyst Interview Questions and Answers

Updated 5 Dec 2024

Treebo Hotels Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 5 Dec 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - Assignment 

SQL, excel, tableau , looker studio

Round 2 - HR 

(1 Question)

  • Q1. What is your notice period.

Interview questions from similar companies

I applied via LinkedIn and was interviewed in Sep 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. How your work will increase our revenue? By sharing the data we can improve our services.
  • Ans. 

    Sharing data insights can help improve services and identify revenue opportunities.

    • Analyzing customer behavior can help identify areas for improvement

    • Identifying trends in sales data can help optimize pricing strategies

    • Using data to personalize marketing efforts can increase customer engagement

    • Predictive modeling can help identify potential revenue opportunities

    • Tracking key performance indicators can help optimize busi

  • Answered by AI
  • Q2. Do you believe in the overtime if yes then why? I don believe in the rare cases we should help our team mates

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay cool and be optimistic.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.

Round 1 - Assignment 

Assignment contained multiple set of questions - python, data science, sql, statistics, data literacy , visualization . Test went on for 1 hour and results were given immediately.

It was a good test. Although I scored 65% , and did not make it, but still had a good experience.

Suggestion - prepare for timebound , basic problem solving.

I applied via LinkedIn and was interviewed before Aug 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(4 Questions)

  • Q1. Advance Excel (Vlookup, Index, Countifs, sumifs and others)
  • Q2. Python Basics (data frame, data types, lamda, series etc)
  • Q3. SQL Functions (joins, limits, partitions, orders by and group by)
  • Q4. 3rd round was managerial round, where mostly non-technicial questions asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident, while answering the questions and you don't have to know all the questions rightly. It's okay if you don't know some.
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Mar 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. Excel and SQL based questions
Round 3 - Technical 

(1 Question)

  • Q1. Python and project based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Took 2 interviews over the course of 2 weeks and then 1 hour before my scheduled final / HR round declined to hire me as they decided that they don't want to.
Utter disregard for a candidate's time and work. The humiliating level of such degraded professionalism that they cannot decide before posting an interview that they don't want to hire.
But they have the audacity to expect 7 days and open-ended work schedule from the candidates.
DO NOT APPLY.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
No response

I was interviewed in Aug 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Calculate no of rows after join
  • Ans. 

    Calculate the number of rows after joining two datasets.

    • Count the number of rows in each dataset

    • Perform the join operation

    • Count the number of rows in the resulting dataset

  • Answered by AI
  • Q2. Split person name in excel
  • Ans. 

    Use Excel's text to columns feature to split person names into separate columns.

    • Select the column containing the full names

    • Go to the Data tab and click on Text to Columns

    • Choose 'Delimited' and select the delimiter that separates the names (e.g. space)

    • Click Finish to split the names into separate columns

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Sql, advance Excel formulas
Interview experience
2
Poor
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - One-on-one 

(7 Questions)

  • Q1. Explain Moving Average
  • Ans. 

    Moving Average is a statistical technique used to analyze data points by creating a series of averages of different subsets of the full data set.

    • Moving Average helps in smoothing out fluctuations in data to identify trends over time.

    • It is calculated by taking the average of a specific number of data points within a defined window.

    • For example, a 3-day moving average for stock prices would be the average of the stock pri...

  • Answered by AI
  • Q2. Explain Decorators
  • Ans. 

    Decorators in Python are functions that modify the behavior of other functions.

    • Decorators are denoted by the @ symbol followed by the decorator function name.

    • They allow you to add functionality to an existing function without modifying its code.

    • Common use cases include logging, timing, and authentication.

    • Example: @decorator_function def function_to_decorate(): pass

  • Answered by AI
  • Q3. Explain Object Oriented Programming
  • Ans. 

    Object Oriented Programming is a programming paradigm based on the concept of objects, which can contain data and code.

    • OOP focuses on creating objects that interact with each other to solve complex problems.

    • Objects have attributes (data) and methods (functions) that can manipulate the data.

    • Encapsulation, inheritance, and polymorphism are key principles of OOP.

    • Example: In a car simulation program, a 'Car' object can hav...

  • Answered by AI
  • Q4. Explain classes objects
  • Ans. 

    Classes are blueprints for creating objects in object-oriented programming.

    • Classes define the properties and behaviors of objects

    • Objects are instances of classes

    • Classes can inherit properties and behaviors from other classes

    • Classes can have constructors to initialize objects

    • Classes can have methods to perform actions

  • Answered by AI
  • Q5. Explain Functions
  • Ans. 

    Functions are blocks of code that perform a specific task and can be reused multiple times in a program.

    • Functions help in organizing code and making it more modular.

    • They can take input parameters and return output values.

    • Functions can be called multiple times from different parts of the program.

    • Examples: summing two numbers, finding the maximum value in a list.

  • Answered by AI
  • Q6. Pandas and Numpy
  • Q7. Swap L1 and L5 in a list
  • Ans. 

    Swap L1 and L5 in a list

    • Create a temporary variable to store the value of L1

    • Assign the value of L5 to L1

    • Assign the value of the temporary variable to L5

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Cleartrip Data Analyst interview:
  • Advanced Python
  • Advanced SQL
  • Advanced Excel
Interview preparation tips for other job seekers - The Job Description Listed Excel, SQL Data Visualization as key skills and python would be an add on. But all questions were asked on advanced python which may not be relevant for data analysis.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Duration - 1hr, Mostly questions are from Excel and SQL ( But a little knowledge of R and Python is very useful) .For me, it's knowing the concepts and answering no codes were ask to write.

Round 2 - One-on-one 

(1 Question)

  • Q1. Basic 1-on-1 round with your manager/ or any senior from the company

Analyst Interview Questions & Answers

Oyo Rooms user image Shobhit Shrivas

posted on 1 Nov 2015

I applied via Campus Placement

Interview Questionnaire 

7 Questions

  • Q1. I was asked 2 questions from a course called principle of economics, such as what is elasticity etc
  • Q2. It was again from my course work they asked me how to solve linear programming problem graphically
  • Q3. Then they asked me to tell me about my self
  • Q4. They asked me to estimate number of microwaves manufactured in india per year
  • Q5. Then I was asked what is my biggest achivement till now
  • Q6. Then I was asked if I have any question for them
  • Q7. He gave me 15 min to convence him so that he hirs me for his company

Interview Preparation Tips

Round: Resume Shortlist
Experience: They were mainly looking for people who has or worked in Start ups or who has some good PORs. They also shortlisted students with CGPA of more than 7.5.
Tips: Try taking good PORs and maintain a healthy CGPA. Make a one page resume.

Round: Technical Interview
Experience: It was good. This was my first interview, I was bit nurvous for obvious reasons but controlled my emotions perfectly. As interview progressed things started becoming normal.
Tips: Be confidant of what ever you speak. Try hidding you nervousness, its okay if you are not able to answer any question but make strong comeback in next.

Round: HR Interview
Experience: I was very confidant of myself and told some 8-9 qualities that I have and gave examples of where I used them in past.
Tips: Again be very confidant. Its okay if you fumble in between but make strong comeback. look into the eyes of interviewer it shows you are confidant. Don't lie, be yourself.

General Tips: Keep working hard, there is no subsitute of hardwork, even in IITs. And don't forget sometimes you have to loose small battels to win Wars.
All the best:)
Skills:
Duration: 8-10weeks
College Name: IIT Madras
Motivation: Oyo is progressing very fast and I wanted to be the part of there amazing journey.
Funny Moments: I kept looking into the eyes of both of my interviewer just to show them I was very confidant but the reality is I was very nervous and I was bluffing them:). After interview I had a headache.
Contribute & help others!
anonymous
You can choose to be anonymous

Treebo Hotels Interview FAQs

How many rounds are there in Treebo Hotels Data Analyst interview?
Treebo Hotels interview process usually has 2 rounds. The most common rounds in the Treebo Hotels interview process are Assignment and HR.
How to prepare for Treebo Hotels Data 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 Treebo Hotels. The most common topics and skills that interviewers at Treebo Hotels expect are Data Analytics, Excel, SQL, Data Analysis and Advanced Excel.

Recently Viewed

INTERVIEWS

Croma

No Interviews

SALARIES

WinWire

INTERVIEWS

Dabur

No Interviews

INTERVIEWS

WinWire

No Interviews

INTERVIEWS

WinWire

No Interviews

INTERVIEWS

Tata Play

No Interviews

INTERVIEWS

Dabur

No Interviews

INTERVIEWS

Tata Play

No Interviews

INTERVIEWS

Dabur

No Interviews

INTERVIEWS

Tata Play

No Interviews

Tell us how to improve this page.

Treebo Hotels Data Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Data Analyst Interview Questions from Similar Companies

View all
Treebo Hotels Data Analyst Salary
based on 6 salaries
₹4 L/yr - ₹9.7 L/yr
At par with the average Data Analyst Salary in India
View more details

Treebo Hotels Data Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

4.0

Skill development

4.0

Work-life balance

3.0

Salary

3.0

Job security

4.0

Company culture

3.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Territory Sales Manager
178 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Area Operation Manager
50 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Territory Sales Leader
25 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
22 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Executive
22 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Treebo Hotels with

Oyo Rooms

3.3
Compare

FabHotels

3.0
Compare

Goibibo

4.3
Compare

MakeMyTrip

3.6
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent