This project aims to analyze Ola ride-hailing data to uncover key insights related to customer behavior and operational efficiency. By leveraging data analysis and visualization techniques, this project provides valuable insights to improve ride availability, driver allocation, and revenue optimization.
🔹 Tech Stack: SQL (MySQL), Power BI
🔹 Dataset: bookingcopy.csv
🔹 Scope: Identifying revenue,cancellation,reason for cancellation and booking value based on Vehicle Type.
✅ People are Booking Prime Sedan cars more.
✅ The cancellation percentage is 26.18% and reason for cancellation are Driver is not Moving or Personal related issue.
✅ Mini Segment Cars has the highest ratings.
📌 LinkedIn : www.linkedin.com/in/devsarthak24
📌 Gmail : [email protected]
Want to contribute? Feel free to fork the repository and explore new insights! 🚀