Categories: Power BI
Tags:

This Power BI dashboard provides an Exploratory Data Analysis (EDA) of Ola Bike Ride Requests, helping identify user trends, seasonal demand, and weather effects on bookings. The key KPIs and visualizations highlight crucial ride statistics:

Get the Dataset : Click Here

✅ Top Metrics

  • Avg Temperature: 20.14°C
  • Avg Windspeed: 24.96 km/h
  • Avg Humidity: 59.95%
  • Casual Customers: 267K
  • Registered Customers: 1.084M
  • Total Users: 1.351M

📈 Key Visualizations

  1. Total Rides Over Time: Line graph showing trends by year, quarter, and month.
  2. Humidity Impact: Bar chart comparing rides by humidity for casual and registered users.
  3. Temperature Bins: Total rides based on temperature ranges—rides dip when temps exceed 30°C.
  4. Weather Influence: Donut chart showing nearly equal distribution of rides across weather types (Clear, Misty, Light Rain, Heavy Rain).
  5. Seasonal Demand: Tree map showing highest rides in Winter (339K), with Spring, Summer, and Fall close behind.
  6. Peak Ride Hours: Line chart showing booking spikes at ~8 AM and ~5 PM, indicating daily commute times.

🎯 Filters Provided

  • SeasonName: Fall, Spring, Summer, Winter
  • WeatherName: Clear, Heavy Rain, Light Rain, Misty
  • Month: April to December