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 Business Intelligence Analyst Interview Questions and Answers

Updated 8 Nov 2019

Goibibo Business Intelligence Analyst Interview Experiences

1 interview found

I applied via Naukri.com and was interviewed in Oct 2019. There were 5 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. To provide a business model to setup a Uber cab services from scratch where Ola has already been established and has a strong customer base.
  • Q2. How to penetrate the market? How to attract the drivers from Ola? What's the business model?
  • Ans. 

    To penetrate the market and attract drivers from Ola, a business model focused on competitive pricing, driver incentives, and superior customer experience can be implemented.

    • Offer competitive pricing to attract drivers from Ola

    • Provide attractive incentives and benefits for drivers to switch

    • Focus on delivering a superior customer experience

    • Leverage technology and data analytics to optimize operations and improve efficie...

  • Answered by AI
  • Q3. SQL and SAS

Interview Preparation Tips

Interview preparation tips for other job seekers - It was a good experience and they were looking for approach and confidence more than the exact code. There were 5 rounds in total.

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Just 10 maths base logical questions they are use this question for all hiring for TL,BI for all

Interview Preparation Tips

Interview preparation tips for other job seekers - Porter is hiring for mis team and they put designation as BI analyst i work there just copy paste kind of work not existing work
Not a proper training given by team and some team members are being bossy every time
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Aug 2023. There were 3 interview rounds.

Round 1 - Assignment 

Set of SQL questions using Joins , Create an sql query for user cohort analysis

Round 2 - Technical 

(2 Questions)

  • Q1. Difference between having and where
  • Ans. 

    The difference between having and where in SQL queries

    • HAVING is used with GROUP BY to filter grouped rows based on a specified condition

    • WHERE is used to filter rows before any grouping is done

    • HAVING is used with aggregate functions like SUM, COUNT, AVG, etc.

    • WHERE is used with individual columns for filtering

  • Answered by AI
  • Q2. SQL query using joins
  • Ans. 

    SQL query using joins to combine data from multiple tables

    • Use INNER JOIN to combine rows from two or more tables based on a related column between them

    • Specify the columns to select from each table in the SELECT statement

    • Use ON clause to specify the join condition

  • Answered by AI
Round 3 - One-on-one 

(2 Questions)

  • Q1. How would you go about understanding competitors
  • Ans. 

    To understand competitors, I would conduct market research, analyze their products/services, pricing strategies, marketing tactics, and customer feedback.

    • Conduct market research to identify key competitors in the industry

    • Analyze competitors' products/services, pricing strategies, and target market

    • Monitor competitors' marketing tactics and promotional activities

    • Gather customer feedback and reviews to understand competit

  • Answered by AI
  • Q2. Guesstimates on how many air planes fly in Bangalore airport in a day
  • Ans. 

    It is estimated that around 400-500 airplanes fly in and out of Bangalore airport daily.

    • Consider the number of flights scheduled for the day

    • Take into account the number of domestic and international flights

    • Factor in the average number of flights per hour

    • Look at the airport's capacity and traffic volume

  • Answered by AI

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
2-4 weeks
Result
No response

I applied via LinkedIn and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Based on previous projects
Round 2 - One-on-one 

(1 Question)

  • Q1. Based on previous projects

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't waste your time attending this interview. The interviewer was rude. He was shouting at me as if I am his employee,Very unprofessional.He was unable to understand my explanation, He was asking very generic questions. HR responses were delayed due to unknown reasons.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Tell me about your projects?
  • Q2. How do you approach the project if you are using logistic regression model?
  • Ans. 

    Approach involves data preprocessing, model training, evaluation, and interpretation.

    • Perform data preprocessing such as handling missing values, encoding categorical variables, and scaling features.

    • Split the data into training and testing sets.

    • Train the logistic regression model on the training data.

    • Evaluate the model using metrics like accuracy, precision, recall, and F1 score.

    • Interpret the model coefficients to under...

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. What are you future goals?
  • Q2. What would you do if your interested field doesnt have any work in the company?
  • Ans. 

    I would seek opportunities to apply my skills in related fields within the company.

    • Explore other departments or teams within the company that may have projects related to my field of interest

    • Offer to collaborate with colleagues in different departments to bring a new perspective to their projects

    • Seek out professional development opportunities to expand my skills and knowledge in related areas

  • Answered by AI

Skills evaluated in this interview

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

(2 Questions)

  • Q1. Basic Recommendation System Questions
  • Q2. A B Testing Questions
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. PROJECT DETAILS
  • Q2. SQL Qns
Round 2 - Technical 

(2 Questions)

  • Q1. PROJECT DETAILS
  • Q2. SQL Qnd
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Simple groupby questions in pandas?
  • Q2. Group by questions in SQL?

Interview Preparation Tips

Interview preparation tips for other job seekers - Lot of opportunity for learning within the company
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. SQL Basic Questions
  • Q2. RCA question if consumption metric goes down

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and straight forward
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Question in sql based on join advance sql

Round 2 - Technical 

(1 Question)

  • Q1. Most question related to my project python sql
Round 3 - HR 

(1 Question)

  • Q1. What yourself why you want ti change

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well

Goibibo Interview FAQs

What are the top questions asked in Goibibo Business Intelligence Analyst interview?

Some of the top questions asked at the Goibibo Business Intelligence Analyst interview -

  1. How to penetrate the market? How to attract the drivers from Ola? What's the bu...read more
  2. To provide a business model to setup a Uber cab services from scratch where Ola...read more
  3. SQL and ...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Swiggy Interview Questions
3.8
 • 424 Interviews
Udaan Interview Questions
4.0
 • 333 Interviews
Meesho Interview Questions
3.7
 • 328 Interviews
Oyo Rooms Interview Questions
3.3
 • 217 Interviews
Myntra Interview Questions
4.0
 • 214 Interviews
Blinkit Interview Questions
3.7
 • 178 Interviews
BlackBuck Interview Questions
3.8
 • 175 Interviews
Spinny Interview Questions
3.7
 • 169 Interviews
FirstCry Interview Questions
3.7
 • 168 Interviews
Tata 1mg Interview Questions
3.6
 • 146 Interviews
View all
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

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