Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Goibibo Team. If you also belong to the team, you can get access from here

Goibibo Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Goibibo Revenue Analyst Interview Questions and Answers

Updated 11 Sep 2020

Goibibo Revenue Analyst Interview Experiences

1 interview found

I applied via LinkedIn and was interviewed before Sep 2019. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Suppose there is a proposal to run a campaign on any one platform (amongst iOS, Android and Desktop). The offer runs for 8 hours on a particular user base. How will you calculate the impact of the offer
  • Ans. 

    To calculate the impact of an offer running on a platform for 8 hours on a user base, we need to analyze the revenue generated during and after the campaign.

    • Analyze revenue generated during the 8-hour campaign period

    • Compare revenue generated during the campaign period to revenue generated during a similar time period without the campaign

    • Analyze revenue generated after the campaign period to determine if there was a las...

  • Answered by AI
  • Q2. You see that the market share has gone down. How will you go about identify the root cause and what will be your sample solution
  • Ans. 

    To identify the root cause of market share decline, I will analyze market trends, customer behavior, and competitor strategies.

    • Conduct market research to identify trends and changes in customer preferences

    • Analyze sales data to identify patterns and potential causes of decline

    • Assess competitor strategies and market positioning

    • Consider external factors such as economic conditions and industry regulations

    • Develop a sample ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Maintain a calm and logical approach to the situations brought in front of you.

Revenue Analyst Jobs at Goibibo

View all

Interview questions from similar companies

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.

I appeared for an interview in Nov 2020.

Interview Questionnaire 

1 Question

  • Q1. Mainly about sql, previous job role
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Case Study 

How many cars in this world

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL Question using window functions
  • Q2. Guesstimate on Number of McD orders
  • Ans. 

    The number of McDonald's orders can be estimated based on factors like location, time of day, and day of the week.

    • Consider the population density of the area where the McDonald's is located

    • Take into account the time of day - more orders during meal times

    • Factor in the day of the week - weekends may have higher order volumes

    • Look at historical data or industry averages for similar locations

    • Consider any promotions or speci

  • Answered by AI

I applied via Referral and was interviewed in Apr 2022. There were 4 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 tips
Round 2 - Technical 

(1 Question)

  • Q1. Understanding of Basic SQL was checked. Writing Basic SQL queries with where condition. SQL query question using Analytical function. ( 2nd most revenue-generating country) Difference between Rank and Dens...
Round 3 - Case Study 

Guestimate the number of people travelling in Metro at 6:30pm on weekday.
Case Study- Funnel Drop in a value chain( customer journey)
find out the reasons, and give the ideas to overcome and rank the ideas based on priority.

Round 4 - One-on-one 

(1 Question)

  • Q1. Business Round with Project Manager: Basically, tell about yourself more(not about work), what kind of person you are, future plans, expectations from the company, what you know about spinny, are you rea...

Interview Preparation Tips

Interview preparation tips for other job seekers - Solve Many Guestimates as much as you can.
Learn all techniques and difference type of Case Studies how to solve.
Increasing your business skills by watching different business case studies.
Learn SQL.

I applied via LinkedIn and was interviewed in Mar 2022. There were 5 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 tips
Round 2 - Coding Test 

The test was based on SQL and the questions were similar to medium difficulty level questions in leetcode.

Round 3 - Technical 

(3 Questions)

  • Q1. Describe different types of joins
  • Ans. 

    Different types of joins are used in database queries to combine data from multiple tables.

    • Inner join: Returns only the matching records from both tables.

    • Left join: Returns all records from the left table and the matching records from the right table.

    • Right join: Returns all records from the right table and the matching records from the left table.

    • Full outer join: Returns all records when there is a match in either the ...

  • Answered by AI
  • Q2. 2 tables were given and I was asked to tell the number of rows in output based on different types of joins.
  • Q3. Calculated the rows based on joins and told the answer.
Round 4 - One-on-one 

(4 Questions)

  • Q1. Describe your previous experience
  • Ans. 

    I have 3 years of experience as a Business Analyst in the IT industry.

    • Worked on gathering and analyzing business requirements

    • Created functional specifications and user stories

    • Conducted stakeholder interviews and facilitated meetings

    • Performed data analysis and created reports

    • Collaborated with cross-functional teams to implement solutions

    • Utilized tools like JIRA and Confluence for project management

    • Improved business proc

  • Answered by AI
  • Q2. Shared the details regarding my experience
  • Q3. A SQL based puzzle based on window functions where I had to find 4 consecutive empty seats in a theater.
  • Q4. Solved using lag function.
Round 5 - Case Study 

The interviewer asked about my previous experience along with a few situation based questions and then gave me a case study to find out possible reasons for a decrease in the cancellations between order dispatch and order delivery.

Interview Preparation Tips

Topics to prepare for Meesho Business Analyst interview:
  • SQL
  • Problem solving
Interview preparation tips for other job seekers - SQL and problem solving are the most important for this interview.

Skills evaluated in this interview

Round 1 - Assignment 
Round 2 - One-on-one 

(1 Question)

  • Q1. Guesstimates, SQL, MS-Excel related questions.
Round 3 - Case Study 

A case study, few HR questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL, Excel are must. Python is good to have.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Oct 2022. There were 4 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 tips
Round 2 - Coding Test 

SQL Assignment: Decent SQL questions were provided, Answers were provided with detailed approach. Time-in out sql problem, cohorts problem was there

Round 3 - Technical 

(1 Question)

  • Q1. Partition functions,creating dynamic buckets and sql puzzles were the highlights
Round 4 - Case Study 

Case study to understand the problem-solving aptitude was asked. Focus was more on the approach rather than the final outcome

Interview Preparation Tips

Interview preparation tips for other job seekers - Case study,sql,guesstimates and puzzles are something that should be handy
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Inkedin and was interviewed in Sep 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 tips
Round 2 - Coding Test 

Sql and python,numpy,pandas

Round 3 - Technical 

(1 Question)

  • Q1. Analyst skills,data handlling

Goibibo Interview FAQs

How to prepare for Goibibo Revenue 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 Goibibo. The most common topics and skills that interviewers at Goibibo expect are Revenue Analysis, Advanced Excel, Data Analysis, Google Analytics and Revenue Management.
What are the top questions asked in Goibibo Revenue Analyst interview?

Some of the top questions asked at the Goibibo Revenue Analyst interview -

  1. You see that the market share has gone down. How will you go about identify the...read more
  2. Suppose there is a proposal to run a campaign on any one platform (amongst iOS,...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Swiggy Interview Questions
3.8
 • 428 Interviews
Udaan Interview Questions
4.0
 • 334 Interviews
Meesho Interview Questions
3.7
 • 328 Interviews
Oyo Rooms Interview Questions
3.3
 • 219 Interviews
Myntra Interview Questions
4.0
 • 215 Interviews
Blinkit Interview Questions
3.7
 • 182 Interviews
BlackBuck Interview Questions
3.8
 • 178 Interviews
Spinny Interview Questions
3.7
 • 170 Interviews
FirstCry Interview Questions
3.6
 • 170 Interviews
Tata 1mg Interview Questions
3.6
 • 146 Interviews
View all
Revenue Analyst - Ground Transport

Bangalore / Bengaluru

3-8 Yrs

Not Disclosed

Explore more jobs
Assistant Manager
51 salaries
unlock blur

₹4.9 L/yr - ₹11.5 L/yr

Senior Business Development Manager
50 salaries
unlock blur

₹4.3 L/yr - ₹8 L/yr

Senior Executive
44 salaries
unlock blur

₹2 L/yr - ₹5.8 L/yr

Senior Software Engineer
44 salaries
unlock blur

₹9.1 L/yr - ₹35.2 L/yr

Software Engineer
35 salaries
unlock blur

₹6.3 L/yr - ₹21.3 L/yr

Explore more salaries
Compare Goibibo with

Udaan

4.0
Compare

Swiggy

3.8
Compare

BlackBuck

3.8
Compare

Blinkit

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