Zomato Data Analyst Interview Questions and Answers

The weight of an aircraft is crucial for its performance and safety.

• The weight of an aircraft includes the weight of the aircraft itself, fuel, passengers, cargo, and any other equipment on board.

• The weight of an aircraft is measured in pounds or kilograms.

• The weight of an aircraft affects its takeoff and landing performance, as well as its fuel efficiency and range.

• Aircraft manufacturers provide maximum takeoff and la...read more

SQL query to get top 100 Uber drivers by city

• Join drivers and users tables on city

• Aggregate driver ratings and count of rides

• Order by rating and count of rides

• Limit to top 100

Optimizing the listing of Restaurants on Swiggy involves using data-driven strategies to improve visibility, relevance, and user experience.

• Analyze user behavior and preferences to understand their needs and preferences

• Implement a ranking algorithm based on factors like ratings, reviews, popularity, and delivery time

• Optimize search functionality to ensure accurate and relevant results

• Collaborate with restaurants to imp...read more

Linear Regression is used for continuous data while Logistic Regression is used for categorical data.

• Linear Regression predicts continuous values while Logistic Regression predicts probabilities.

• Linear Regression uses a straight line to fit the data while Logistic Regression uses an S-shaped curve.

• Linear Regression uses Mean Squared Error as the cost function while Logistic Regression uses Log Loss.

• Linear Regression is...read more

Bias-Variance trade-off is the balance between overfitting and underfitting. High bias models are simple but inaccurate, low variance models are complex but overfit.

• Bias-Variance trade-off is a fundamental concept in machine learning.

• High bias models are simple and have low variance, but are inaccurate.

• Low bias models are complex and have high variance, but can overfit the data.

• Examples of high bias models are linear r...read more

Possible reasons for a car manufacturer's decline in profits by 40% year over year

• Decreased demand for cars due to economic downturn

• Increased competition from other car manufacturers

• Rising production costs and expenses

• Decline in consumer confidence and spending

• Changes in government regulations impacting the automotive industry

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

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

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

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