# 🚖 City Ride Analysis

An interactive Power BI dashboard built to analyze city ride booking data and uncover business insights related to bookings, revenue, cancellations, payment methods, ride categories, customer behavior, and operational performance.

---

📌 Project Overview

This project transforms raw ride booking data into an interactive dashboard that enables stakeholders to monitor key business metrics and make data-driven decisions.

The dashboard provides insights into:

• Total Bookings
• Booking Value
• Successful vs Cancelled Rides
• Ride Volume Trends
• Vehicle Type Performance
• Payment Method Analysis
• Customer Ratings
• Driver Ratings
• Ride Distance Distribution
• Booking Status Analysis
• Monthly Booking Trends

---

🛠️ Tools & Technologies

• Power BI Desktop
• Power Query
• DAX
• Data Modeling
• Data Visualization

---

📊 Dashboard Features

Executive Dashboard

• Total Bookings KPI
• Total Booking Value
• Total Distance Travelled
• Average Ride Distance
• Cancellation Analysis
• Booking Status Distribution
• Monthly Booking Trend

Vehicle Analysis

• Performance by Vehicle Type
• Booking Count
• Revenue Contribution
• Average Ride Distance

Customer & Driver Analysis

• Customer Ratings
• Driver Ratings
• Customer Behavior
• Ride Completion Rate

Payment Analysis

• Payment Method Distribution
• Revenue by Payment Type

---

📈 Key KPIs

• Total Bookings
• Successful Bookings
• Cancelled Bookings
• Total Revenue
• Average Booking Value
• Total Distance
• Average Ride Distance
• Customer Rating
• Driver Rating

---

📂 Project Structure

City-Ride-Analysis/
│
├── Dashboard/
│   └── City Ride Analysis.pbix
│
├── Dataset/
│   └── city_ride_dataset.csv
│
├── Screenshots/
│   ├── Cancellation.png
│   ├── Homepage.png
│   ├── Overall.png
│   ├── Rating.png
│   ├── Revenue.png
│   ├── Summary.png
│   └── Vehicle.png
│
├── README.md
└── LICENSE

---

📸 Dashboard Preview

📊 Home Dashboard

---

📊 Overall Dashboard

---

📊 Vehicle Dashboard

---

📊 Cancellation Dashboard

---

📊 Revenue Dashboard

---

📊 Rating Dashboard

---

📊 Summary Dashboard

---

---

📊 Business Insights

• Identified peak booking periods.
• Measured ride cancellation trends.
• Compared vehicle category performance.
• Analyzed customer and driver ratings.
• Evaluated payment method preferences.
• Monitored overall ride demand.

---

💡 Skills Demonstrated

• Data Cleaning
• Data Transformation
• Data Modeling
• DAX Measures
• KPI Design
• Dashboard Design
• Business Analysis
• Interactive Reporting
• Data Visualization

---

🎯 Learning Outcome

Through this project, I strengthened my understanding of:

• Power BI Dashboard Development
• Data Modeling
• DAX Calculations
• KPI Reporting
• Business Intelligence
• Analytical Thinking

---

👨‍💻 Author

Sanjay Chourasiya

📧 Email: sanjaychourasiyadmo240999@gmail.com

🔗 LinkedIn: www.linkedin.com/in/sanjay-chourasiya-02393025a

💻 GitHub: https://github.com/sanjay2449

🌐 Portfolio: https://sanjaychourasiya.vercel.app

---

⭐ If you found this project useful, consider giving it a Star.