Filter interviews by
I applied via Job Portal and was interviewed in Oct 2021. There were 3 interview rounds.
posted on 6 Nov 2019
I applied via Referral and was interviewed before Nov 2018. There were 5 interview rounds.
I applied via Referral and was interviewed before May 2020. There was 1 interview round.
To understand the supply of restaurants in a particular area of a city, we can use various methods.
Collect data from online directories like Yelp, Zomato, etc.
Conduct surveys to gather information about the number of restaurants in the area.
Analyze the population density and demographics of the area to estimate the demand for restaurants.
Check the number of restaurant permits issued by the local government.
Use GIS mapp...
I was interviewed in Mar 2021.
Steps involved in analyzing decrease in sales for a particular area
Identify the time period for which sales have decreased
Analyze the sales data for the area and compare it with previous periods
Identify any external factors that may have contributed to the decrease in sales
Conduct customer surveys to identify any issues with products or services
Analyze competitor activity in the area
Develop a plan to address the issues...
SQL query to find mean waiting period for delivery partner given driver ID, ordered time and delivered time.
Use AVG function to calculate mean waiting period
Subtract ordered time from delivered time to get waiting period
Filter data by driver ID and delivery partner
Group by delivery partner
Rolling sum query adds up a specified number of rows in a table based on a given condition.
Use the OVER() function to specify the window frame for the rolling sum.
Specify the number of rows to include in the window frame using ROWS BETWEEN.
Use ORDER BY to specify the order of rows in the window frame.
Example: SELECT column1, SUM(column2) OVER (ORDER BY column1 ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FR
I was interviewed in Nov 2021.
Round duration - 60 minutes
Round difficulty - Easy
Prepare well for SQL, you have to be strong in SQL. Questions related to SQL and A/B testing were asked.
Query to calculate rolling sum
Use window functions like SUM() OVER() in SQL
Specify the window frame to define the range for the rolling sum
Example: SELECT date, value, SUM(value) OVER (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FROM table_name
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Prepare well for SQL, you have to be strong in SQL.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.
The amount of work experience is an important factor in determining the suitability of a candidate for the Business Analyst role.
Work experience helps in developing a deep understanding of business processes and industry trends.
It allows the candidate to gain practical knowledge and skills in data analysis, problem-solving, and project management.
Having relevant work experience demonstrates the ability to work effectiv...
I applied via Referral and was interviewed before Mar 2021. There were 4 interview rounds.
Types of SQL joins and their minimum and maximum possible rows.
Types of joins: Inner, Left Outer, Right Outer, Full Outer, Cross
Minimum rows: Inner - 0, Left/Right Outer - 1, Full Outer - 0, Cross - product of rows
Maximum rows: Inner/Left/Right/Full Outer - product of rows, Cross - product of rows
1.Features you would look for if you have to buy an elevator
2. How do you estimate the number of trains passing through a station
I applied via Company Website and was interviewed in Sep 2023. There were 4 interview rounds.
SQL and case study and was of an hour length
based on 1 review
Rating in categories
Content Moderator
23
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Development Executive
17
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Analyst
13
salaries
| ₹0 L/yr - ₹0 L/yr |
Content Strategist
13
salaries
| ₹0 L/yr - ₹0 L/yr |
Program Manager
10
salaries
| ₹0 L/yr - ₹0 L/yr |
Thrillophilia
Cleartrip
MakeMyTrip
Yatra