ShipBob Business Analyst Interview Questions and Answers

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. Work experience
Add your answer
Q2. Expected CTC, and current CTC
Add your answer

Excel formulas and typing speed

Q1. How 3pl logistic work
Ans. 
3PL logistics involve outsourcing logistics services to a third-party provider for efficient supply chain management.
• Third-party logistics providers handle transportation, warehousing, distribution, and fulfillment services for businesses.

• They help businesses save time and money by streamlining their supply chain operations.

• Examples of 3PL companies include DHL, FedEx Supply Chain, and XPO Logistics.
Answered by AI
Add your answer
Q2. Previous company experince
Ans. 
I have 5 years of experience working at XYZ company in a sales role.
• Worked at XYZ company for 5 years

• Experience in sales role

• Achieved 150% of sales target in the last quarter
Answered by AI
Add your answer

Q1. Some Sql questions. Approach was more focussed than coding part
Add your answer

A Product case study, the interviewer asks scenairo based questions from the case study

Q1. Give me details of your past projects that impacted organisation?
Add your answer
Q2. Resolve the current case problem by providing your approach.
Add your answer

Q1. What are your salary expectations?
Ans. 
I am open to discussing salary based on the responsibilities and requirements of the position.
• Focus on the value you can bring to the company rather than a specific number

• Research the average salary range for similar positions in the industry and location

• Consider your experience, skills, and qualifications when determining your salary expectations
Answered by AI
Add your answer
Q2. Share details of your previous job.
Ans. 
I worked as a Financial Analyst at XYZ Company.
• Analyzed financial data and prepared reports for management.

• Conducted financial forecasting and budgeting.

• Performed variance analysis to identify trends and areas for improvement.

• Assisted in the development of financial models and projections.

• Collaborated with cross-functional teams to support decision-making processes.

• Presented findings and recommendations to senior manag...read more
Answered by AI
Add your answer
Q3. Tell me about yourself.
Ans. 
I am an experienced analyst with a strong background in data analysis and problem-solving.
• Experienced analyst with expertise in data analysis and problem-solving

• Proficient in using analytical tools and software

• Strong ability to interpret and present complex data

• Proven track record of delivering actionable insights

• Excellent communication and collaboration skills
Answered by AI
Add your answer

Q1. 1. Tell me about your self and experience? 2. Core expertise and work experience related questions ? 3. Long term goals and company expectations
Add your answer

Sir/ mem already me pehle work kar chuka hu