Upload Button Icon Add office photos

Filter interviews by

Agoda Senior Data Analyst Interview Questions and Answers

Updated 17 Jun 2024

Agoda Senior Data Analyst Interview Experiences

1 interview found

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Coding Test 

Basic assessment test

Round 2 - Technical 

(3 Questions)

  • Q1. A/B testing analysis scenario based
  • Q2. Basic SQL code to get query
  • Q3. Scenario based qns to create campaign
Round 3 - Case Study 

Case study analysis for a data with many outliers

Round 4 - One-on-one 

(1 Question)

  • Q1. Presenting case study and answering questions from interviewer

Interview Preparation Tips

Interview preparation tips for other job seekers - Please don't waste your precious time on this interview process with Agoda as it is one of the worst experience you ever have. Writing this not because I didnt clear the final round but the way of approach and how they handle candidates is very bad.
Case study given to me was carefully analysed by me on individual case basis but the interviewer was not satisfied and was asking me irrelevant questions like finding an overall trend with the data having many outliers.

Interview questions from similar companies

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 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
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.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jul 2023. There were 3 interview rounds.

Round 1 - Coding Test 

I was asked with SQL querying questions.

Round 2 - Technical 

(2 Questions)

  • Q1. Set of questions related to excel.
  • Q2. Vlookup, sumifs, pivot tables
Round 3 - HR 

(2 Questions)

  • Q1. Related to past work experience.
  • Q2. Scenario based questions related to business industry.
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
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Guestimates, sql questions

Round 2 - Coding Test 

Sql questions geeks for geeks

Interview Preparation Tips

Interview preparation tips for other job seekers - Not very tough on skillset but grilled on business cases
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 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

Agoda Interview FAQs

How many rounds are there in Agoda Senior Data Analyst interview?
Agoda interview process usually has 4 rounds. The most common rounds in the Agoda interview process are Coding Test, Technical and Case Study.
What are the top questions asked in Agoda Senior Data Analyst interview?

Some of the top questions asked at the Agoda Senior Data Analyst interview -

  1. Presenting case study and answering questions from intervie...read more
  2. Scenario based qns to create campa...read more
  3. A/B testing analysis scenario ba...read more

Tell us how to improve this page.

Agoda Senior Data Analyst Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more
Software Engineer
31 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
28 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Product Manager
10 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Engineering Manager
9 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Strategic Account Manager
6 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Agoda with

MakeMyTrip

3.7
Compare

Yatra

3.4
Compare

Cleartrip

3.4
Compare

Oyo Rooms

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