Goibibo Business Intelligence Analyst Interview Questions and Answers

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

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

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

Q1. Based on previous projects
Add your answer

Q1. Based on previous projects
Add your answer

Q1. Tell me about your projects?
Add your answer
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...read more
Answered by AI
Add your answer

Q1. What are you future goals?
Add your answer
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
Add your answer

Q1. Basic Recommendation System Questions
Add your answer
Q2. A B Testing Questions
Add your answer

Q1. PROJECT DETAILS
Add your answer
Q2. SQL Qns
Add your answer

Q1. PROJECT DETAILS
Add your answer
Q2. SQL Qnd
Add your answer

Q1. Simple groupby questions in pandas?
Add your answer
Q2. Group by questions in SQL?
Add your answer

Q1. SQL Basic Questions
Add your answer
Q2. RCA question if consumption metric goes down
Add your answer

Question in sql based on join advance sql

Q1. Most question related to my project python sql
Add your answer

Q1. What yourself why you want ti change
Add your answer