ShipBob Senior Business Analyst Interview Questions and Answers

Q1. Basic sql questions
Add your answer
Q2. Case study question
Add your answer

Excel and aptitude test

Q1. Case study on OYO room
Add your answer
Q2. Guesstimate on number of delivery boys in Gurgaon.
Ans. 
There are approximately 10,000 delivery boys in Gurgaon.
• Consider the population of Gurgaon and the number of online food delivery services operating in the area.

• Assume an average of 5 delivery boys per restaurant and multiply by the number of restaurants in Gurgaon.

• Factor in the number of delivery boys working for other types of delivery services such as e-commerce and courier companies.

• The number may vary depending on...read more
Answered by AI
Add your answer

Q1. Tell me something about yourself and your previous roles
Add your answer

Q1. What is logistics? How you will handle pressure?
Ans. 
Logistics is the process of planning, implementing, and controlling the efficient flow and storage of goods, services, and information.
• Logistics involves activities such as transportation, warehousing, inventory management, and order fulfillment.

• It aims to ensure that the right products are delivered to the right place, at the right time, and in the right condition.

• Logistics plays a crucial role in supply chain managem...read more
Answered by AI
View 2 more answers
Q2. Is your excel good. ? How to solve any problem?
Ans. 
Yes, my excel skills are good. To solve any problem, I follow a systematic approach by analyzing, breaking down, and finding appropriate solutions.
• I have a strong understanding of Excel functions and formulas.

• I am proficient in data analysis and manipulation using Excel.

• I can create complex spreadsheets and automate tasks using macros.

• I have experience in data visualization and creating charts and graphs.

• I am skilled i...read more
Answered by AI
View 1 more answer

Q1. Questions about kubernetes and dockerfile
Add your answer

Q1. Questions about your past experience
Add your answer

Q1. It was in general discussion round
Add your answer

Q1. General discussion round
Add your answer

Q1. Give me details of your past projects that impacted organisation?
Add your answer
Q2. Resolve the current case problem by providing your approach.
Ans. 
Analyze the case problem using data-driven insights and structured methodologies.
• Define the problem clearly: Identify the key issues and objectives.

• Collect relevant data: Use surveys, databases, or existing reports.

• Analyze the data: Use statistical methods or data visualization tools.

• Interpret results: Draw conclusions and identify actionable insights.

• Communicate findings: Present results in a clear and concise manner.
Answered by AI
Add your answer

Q1. General questions and discussion about salary
Add your answer

Q1. Talk about past experience
Add your answer
Q2. Shippment related questions and incoterms
Add your answer

Q1. What was your overall journey
Add your answer

Q1. What do you know about FTL, LCL
Ans. 
FTL and LCL are terms used in logistics and transportation.
• FTL stands for Full Truck Load, which means a shipment that occupies the entire truck and is transported from one point to another without any stops or transfers.

• LCL stands for Less than Container Load, which means a shipment that does not occupy the entire container and is consolidated with other shipments to fill the container.

• FTL is usually faster and more e...read more
Answered by AI
Add your answer