DaveAI Business Analyst Intern Interview Questions and Answers for Freshers

Q1. Advanced formulas of Excel
Ans. 
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.
Answered by AI
Add your answer

Q1. How to calculate requirement of Banana is a city like Mumbai
Ans. 
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
Answered by AI
Add your answer
Q2. How to know , difference between a good or bad retailer
Ans. 
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
Answered by AI
Add your answer
Q3. Simple SQL questions
Add your answer

Problem solving approach check

Q1. Case study and problem solving
Add your answer
Q2. Root cause Analysis
Add your answer

Q1. How would you approach a client who is not known to you
Add your answer

Q1. About industry experience
Add your answer

Q1. Call demo from current job
Add your answer

Q1. Work profile and how it will be
Add your answer

Q1. Salary and details
Add your answer

Q1. About us and our experience
Add your answer