🚖 NCR Ride Booking Data Dashboard

📊 Project Overview

This project focuses on analyzing ride booking data from NCR (National Capital Region) to understand booking trends, customer behavior, and operational performance.
The dashboard was created in Microsoft Excel using various data visualization and analysis techniques such as Pivot Tables, Charts, and Slicers.

---

🎯 Objectives

• Analyze total rides, completed rides, and cancelled rides.
• Identify key reasons for ride cancellations.
• Study driver and customer performance through rating analysis.
• Track daily, weekly, and monthly booking trends.
• Provide data-driven insights to improve ride booking efficiency.

---

🧰 Tools & Techniques Used

• Microsoft Excel
  • Pivot Tables & Charts
  • Slicers and Interactive Filters
  • Conditional Formatting
  • Data Cleaning using Power Query
  • KPI Metrics and Trend Analysis

---

📂 Repository Contents

File Name	Description
NCR Ride Booking Dashboard.xlsx	Main Excel dashboard file containing all visualizations and insights
NCR Booking Dataset.csv	Raw dataset used for creating the dashboard (if applicable)
NCR Dashboard Report.pdf	Exported PDF version of the Excel dashboard for presentation or sharing

---

📈 Key Insights

• Overall ride completion rate and cancellation rate.
• Most common cancellation reasons (e.g., No Driver Found, Cancelled by Driver/Customer).
• Peak hours and days for booking demand.
• Average driver and customer ratings comparison.
• Trends showing customer satisfaction and driver availability patterns.

---

🚀 How to Use

1. Download the Excel file (NCR Ride Booking Dashboard.xlsx).
2. Open it in Microsoft Excel (2019 or later).
3. Use slicers and filters to interact with the data (e.g., by date, status, or city).
4. Review charts and KPIs to understand ride booking performance.

---

📚 Dataset Description

The dataset includes key fields such as:

• Booking ID
• Booking Date and Time
• Booking Status (Completed, Cancelled, No Driver Found, etc.)
• Driver and Customer Ratings
• Trip Distance and Fare

---

👩‍💻 Author

Ponraj Kumar R
Excel Data Analyst | Dashboard Developer
📍 Tamil Nadu, India
📧 https://www.linkedin.com/in/pnrjkmr/

---

⭐ If you found this project insightful, don’t forget to star this repository!