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. 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

Given time series data of provider, compute hour wise provider wise no of seconds online

Q1. Case study on the customer churn.
Add your answer
Q2. Questions on Probability and CLT
Add your answer

Q1. What are assumptions in Linear Regression
Ans. 
Assumptions in Linear Regression
• Linear relationship between independent and dependent variables

• Homoscedasticity (constant variance) of residuals

• Independence of residuals

• Normal distribution of residuals

• No multicollinearity among independent variables
Answered by AI
Add your answer
Q2. What are overfitting and underfitting
Ans. 
Overfitting and underfitting are two common problems in machine learning models.
• Overfitting occurs when a model is too complex and fits the training data too closely, resulting in poor performance on new data.

• Underfitting occurs when a model is too simple and cannot capture the underlying patterns in the data, resulting in poor performance on both training and new data.

• Overfitting can be prevented by using regularizati...read more
Answered by AI
Add your answer
Q3. How do you improve the performance of Linear Regression
Ans. 
To improve the performance of Linear Regression, you can consider feature engineering, regularization, and handling outliers.
• Perform feature engineering to create new features that capture important information.

• Apply regularization techniques like L1 or L2 regularization to prevent overfitting.

• Handle outliers by either removing them or using robust regression techniques.

• Check for multicollinearity among the independent...read more
Answered by AI
View 1 more answer
Q4. What are the metrics used to evaluate Linear Regression
Ans. 
Metrics used to evaluate Linear Regression
• Mean Squared Error (MSE)

• Root Mean Squared Error (RMSE)

• R-squared (R²)

• Adjusted R-squared (Adj R²)

• Mean Absolute Error (MAE)

• Residual Sum of Squares (RSS)

• Akaike Information Criterion (AIC)

• Bayesian Information Criterion (BIC)
Answered by AI
Add your answer
Q5. What is Cost function and Error Function
Ans. 
Cost function measures the difference between predicted and actual values. Error function measures the average of cost function.
• Cost function is used to evaluate the performance of a machine learning model.

• It measures the difference between predicted and actual values.

• Error function is the average of cost function over the entire dataset.

• It is used to optimize the parameters of the model.

• Examples of cost functions are ...read more
Answered by AI
Add your answer
Q6. How do you handle Overfitting in Linear Regression
Ans. 
Overfitting in Linear Regression can be handled by using regularization techniques.
• Regularization techniques like Ridge regression and Lasso regression can help in reducing overfitting.

• Cross-validation can be used to find the optimal regularization parameter.

• Feature selection and dimensionality reduction techniques can also help in reducing overfitting.

• Collecting more data can help in reducing overfitting by providing
Answered by AI
View 1 more answer
Q7. What is the difference between Least Squares Method and the maximum likelihood
Ans. 
Least Squares Method and Maximum Likelihood are both used to estimate parameters, but differ in their approach.
• Least Squares Method minimizes the sum of squared errors between the observed and predicted values.

• Maximum Likelihood estimates the parameters that maximize the likelihood of observing the given data.

• Least Squares Method assumes that the errors are normally distributed and independent.

• Maximum Likelihood does n...read more
Answered by AI
Add your answer
Q8. What is the formula of Logistic Regression
Ans. 
Logistic Regression formula is used to model the probability of a certain event occurring.
• The formula is: P(Y=1) = e^(b0 + b1*X1 + b2*X2 + ... + bn*Xn) / (1 + e^(b0 + b1*X1 + b2*X2 + ... + bn*Xn))

• Y is the dependent variable and X1, X2, ..., Xn are the independent variables

• b0, b1, b2, ..., bn are the coefficients that need to be estimated

• The formula is used to predict the probability of a binary outcome, such as whether...read more
Answered by AI
Add your answer
Q9. What is Type I and Type II error
Ans. 
Type I error is rejecting a true null hypothesis, while Type II error is failing to reject a false null hypothesis.
• Type I error is also known as a false positive

• Type II error is also known as a false negative

• Type I error occurs when the significance level is set too high

• Type II error occurs when the significance level is set too low

• Examples: Type I error - Convicting an innocent person, Type II error - Failing to convi...read more
Answered by AI
Add your answer
Q10. What metrics do you use to evaluate classification models
Ans. 
Metrics used to evaluate classification models
• Accuracy

• Precision

• Recall

• F1 Score

• ROC Curve

• Confusion Matrix
Answered by AI
Add your answer
Q11. How do you handle overfitting and underfitting in Decision Trees
Ans. 
Overfitting in decision trees can be handled by pruning, reducing tree depth, increasing dataset size, and using ensemble methods.
• Prune the tree to remove unnecessary branches

• Reduce tree depth to prevent overfitting

• Increase dataset size to improve model generalization

• Use ensemble methods like Random Forest to reduce overfitting

• Underfitting can be handled by increasing tree depth, adding more features, and reducing regu...read more
Answered by AI
Add your answer

Case Study - How do you improve user engagement of Facebook?
Guesstimates - How many people watched the Squid Game series on Netflix

How do you reduce partner churn in UC?