🚖 Ola Data Analyst Project (Excel | SQL | Power BI)

📌 Overview

This is an end-to-end Data Analytics Project where I analyzed Ola ride booking data to extract meaningful business insights.
The process included:

• Excel → Data cleaning & preprocessing
• SQL → Data analysis & KPI calculation
• Power BI → Interactive dashboards & visual storytelling

---

🗂 Dataset

• Rows: 100,000+ (Build Sample Data From ChatGPT)
• Key Columns: Date, Time, Booking Status, Vehicle Type, Pickup/Drop Locations, Ratings, Payment Method, etc.
• Data Source: Self-generated dummy dataset for learning purposes.

---

🛠 Tools & Technologies

• Microsoft Excel (Data Cleaning & Transformation)
• SQL (Data Analysis – MySQL/PostgreSQL)
• Power BI (Data Visualization & Dashboarding)

---

🔍 Project Workflow

1. Excel – Data Cleaning

   • Removed duplicates & null values
   • Corrected data types (Dates, Numbers)
   • Created derived columns (Weekend flag, Peak hours)
   • Ensured cancellation rates & ride success % matched project constraints

2. SQL – Analysis

   • Top 5 customers by rides & revenue
   • Booking trends by day/week
   • Average ratings per vehicle type
   • Cancellation analysis (by customer vs driver)
   • Revenue breakdown by payment method

3. Power BI – Visualization

   • Ride Volume Over Time
   • Booking Status Breakdown
   • Top Vehicle Types by Distance
   • Cancellation Reasons Analysis
   • Revenue by Payment Method
   • Driver vs Customer Ratings

---