Vegrow Data Analyst Interview Questions and Answers

The requirement of bananas in a city like Mumbai can be calculated based on population, consumption habits, and availability.

• Calculate the population of Mumbai

• Estimate the average consumption of bananas per person

• Consider factors like tourism and events that may increase demand

• Take into account the availability of bananas from local markets and imports

A good retailer focuses on customer satisfaction, product quality, and efficient operations.

• Good retailers prioritize customer satisfaction by providing excellent customer service and addressing customer needs.

• Good retailers offer high-quality products that meet customer expectations.

• Good retailers have efficient operations, including inventory management, supply chain logistics, and streamlined processes.

• Bad retailers...read more

Advanced Excel formulas are complex functions used for data analysis and manipulation.

• Advanced formulas in Excel include VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, and IFERROR.

• These formulas are used for tasks like data lookup, conditional calculations, and summarizing data.

• For example, VLOOKUP is used to search for a value in a table and return a corresponding value from another column.