HealthifyMe Business Analyst Interview Questions and Answers

Different types of joins in SQL, Delete drop truncate difference

• Types of joins: Inner join, Left join, Right join, Full outer join

• Inner join returns only matching rows from both tables

• Left join returns all rows from left table and matching rows from right table

• Right join returns all rows from right table and matching rows from left table

• Full outer join returns all rows from both tables

• Delete is used to remove specific ...read more

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

Reducing delivery time can be achieved by optimizing the supply chain, improving communication, and automating processes.

• Analyze the supply chain and identify bottlenecks

• Implement automation tools to streamline processes

• Improve communication between departments and with customers

• Use data analytics to forecast demand and plan accordingly

• Consider outsourcing or partnering with third-party logistics providers

• Invest in tec...read more