Ola Cabs Business Analyst Interview Questions and Answers

Quantifiable factors to rate cab drivers for company's purpose

• Customer ratings and feedback

• Number of completed trips

• Average trip duration

• Percentage of on-time pickups

• Accident and traffic violation history

• Vehicle cleanliness and maintenance

• Driver punctuality and professionalism

Discounting is a way to incentivize inactive customers by offering them reduced prices or special deals to encourage them to make a purchase.

• Discounting can help attract the attention of inactive customers who may have lost interest in the product or service.

• It can create a sense of urgency and motivate customers to take action before the discount expires.

• Discounting can also help clear out excess inventory or generate quick revenue for the business.

• Offering discounts to inac...read more

There are approximately 300 million bicycle tyres in India.

• India has a population of over 1.3 billion people, with a significant portion using bicycles as a mode of transportation.

• Assuming each bicycle has 2 tyres, we can estimate the total number of bicycle tyres in India.

• Factors such as urbanization, government initiatives promoting cycling, and economic growth can also impact the number of bicycle tyres in India.

Regular customers can be incentivized through loyalty programs, personalized discounts, exclusive offers, and rewards points.

• Implement a loyalty program where customers earn points for each purchase, which can be redeemed for discounts or free items.

• Offer personalized discounts based on the customer's purchase history or preferences.

• Provide exclusive offers or early access to new products/services for regular customers.

• Reward customers with special perks such as birthday disc...read more

Convert SQL to Python

• Use Python's built-in SQLite module to connect to the database

• Use SQL queries as strings in Python code

• Use fetchall() method to retrieve data from the database

• Use pandas library to read SQL data into a DataFrame