Upload Button Icon Add office photos
Engaged Employer

i

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

Meesho Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Meesho Business Intelligence Analyst Interview Questions and Answers

Updated 13 Aug 2024

Meesho Business Intelligence Analyst Interview Experiences

1 interview found

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

I applied via Referral and was interviewed in Feb 2022. There were 5 interview rounds.

Round 1 - Assignment 

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

Round 2 - Technical 

(2 Questions)

  • Q1. Case study on the customer churn.
  • Q2. Questions on Probability and CLT
Round 3 - Technical 

(11 Questions)

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

  • Answered by AI
  • 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...

  • Answered by AI
  • 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
  • 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 ...

  • Answered by AI
  • 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
  • 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...

  • Answered by AI
  • 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...

  • Answered by AI
  • 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...

  • Answered by AI
  • 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
  • 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...

  • Answered by AI
Round 4 - Case Study 

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

Round 5 - Case Study 

How do you reduce partner churn in UC?

Interview Preparation Tips

Topics to prepare for Urban Company Senior Data Analyst interview:
  • Machine Learning
  • Statistics
  • Case Studies
Interview preparation tips for other job seekers - Be thorough with Mathematics behind ML Algo, Practice Case Study Interviews.

Skills evaluated in this interview

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
4
Good
Difficulty level
-
Process Duration
-
Result
-
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 

Build a simple cat and dog image classifier

Round 3 - Technical 

(1 Question)

  • Q1. ML related questions
Round 4 - HR 

(1 Question)

  • Q1. Behavioural questions, basically to check if you will be fit in a team

Meesho Interview FAQs

How many rounds are there in Meesho Business Intelligence Analyst interview?
Meesho interview process usually has 3 rounds. The most common rounds in the Meesho interview process are Assignment, Technical and One-on-one Round.
What are the top questions asked in Meesho Business Intelligence Analyst interview?

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

  1. Guesstimates on how many air planes fly in Bangalore airport in a ...read more
  2. Difference between having and wh...read more
  3. SQL query using jo...read more

Tell us how to improve this page.

Meesho Business Intelligence Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Flipkart Interview Questions
4.0
 • 1.4k Interviews
Swiggy Interview Questions
3.8
 • 435 Interviews
BigBasket Interview Questions
3.9
 • 356 Interviews
Udaan Interview Questions
4.0
 • 335 Interviews
CARS24 Interview Questions
3.6
 • 326 Interviews
Myntra Interview Questions
4.0
 • 215 Interviews
Blinkit Interview Questions
3.7
 • 181 Interviews
BlackBuck Interview Questions
3.8
 • 174 Interviews
FirstCry Interview Questions
3.7
 • 166 Interviews
Tata 1mg Interview Questions
3.6
 • 146 Interviews
View all
Key Account Manager
737 salaries
unlock blur

₹2.8 L/yr - ₹6.9 L/yr

City Manager
205 salaries
unlock blur

₹4 L/yr - ₹10 L/yr

Business Analyst
189 salaries
unlock blur

₹8.6 L/yr - ₹21.5 L/yr

Business Development Manager
172 salaries
unlock blur

₹3 L/yr - ₹7.5 L/yr

Team Lead
168 salaries
unlock blur

₹1.6 L/yr - ₹9 L/yr

Explore more salaries
Compare Meesho with

Amazon

4.1
Compare

Flipkart

4.0
Compare

Myntra

4.0
Compare

GlowRoad

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