Treebo Hotels Data Analyst Interview Questions and Answers

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.

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

Q1. Excel and SQL based questions
Add your answer

Q1. Python and project based questions
Add your answer

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
Add your answer
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
Add your answer

Q1. Sql, advance Excel formulas
Add your answer

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...read more
Answered by AI
Add your answer
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
Add your answer
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...read more
Answered by AI
Add your answer
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
Add your answer
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
Add your answer
Q6. Pandas and Numpy
Add your answer
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
Add your answer

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.

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