🌍 Trip Away : Travel Aggregator Analysis

Travel Aggregator Banner





🎯 Project Aim

Trip Away is a multi-service travel aggregator, and this project digs into how its customers actually search, book, and behave across the platform. The aim was to understand booking patterns, device habits, and route demand well enough to point to real, usable improvements in user experience, route planning, and overall platform performance.

πŸ“‚ Project Structure

πŸ“ Data_Analysis_Travel-Aggregator-Analysis
│── πŸ“‚ assets            
     │── banner_travel_aggregator.png        
│── πŸ“‚ data                                          # Dataset files
│── πŸ“‚ notebook             
     │── πŸ“œ travel_aggregator_analysis.ipynb        # Complete exploratory analysis, visuals, and insights
│── πŸ“œ business_impact.md                           # Consolidated business insights & strategic recommendations 
│── πŸ“œ README.md                                    # Project overview, structure, key findings, and visuals
│── πŸ“œ requirements.txt                             # Python dependencies for running the analysis

πŸ›  Installation & Setup

  1. Clone the repository

    git clone https://github.com/mcadriaans/Data_Analysis_Travel-Aggregator-Analysis.git
    cd Data_Analysis_Travel-Aggregator-Analysis
    
  2. Install dependencies

    pip install -r requirements.txt
    

πŸ“‹ Data Overview

bookings.csv (Contains booking information)

Column NameDescription
customer_idUnique identifier for customers
booking_idUnique booking reference
from_cityOrigin city of the booking
from_countryOrigin country of the booking
to_cityDestination city of the booking
to_countryDestination country of the booking
booking_timeTimestamp when the booking was made
device_type_usedDevice type used for booking (e.g., Desktop, Android, iOS)
INR_AmountBooking cost in Indian Rupees (INR)
service_namePlatform used for booking (e.g., MMT, Goibibo, EaseMyTrip)
no_of_passengersNumber of passengers in the booking
days_to_departureDays left before departure at the time of booking
distance_kmDistance covered in the booking

sessions.csv (Contains search session data)

Column NameDescription
session_idUnique session identifier
search_idUnique search reference
search_timeTimestamp when the search was conducted
session_starting_timeTimestamp of when the session started
booking_idUnique booking reference if a booking was made from the session (nullable)

πŸ” Key Findings

πŸ“Š Dataset Summary

πŸ“… Booking Behavior

🏷️ Service Performance

✈️ Route Demand

⏱️ Lead-Time Patterns

πŸ“ˆ Correlation Insights

πŸ“± Device Preferences

πŸ—“οΈ Quarterly Trends

πŸ”» Search-to-Booking Funnel

For detailed business recommendations, see: πŸ‘‰ business_impact.md

πŸ“ˆ Key Visualizations

Here's what's covered visually in the notebook:

🧩 Challenges

A couple of things came up while building this that are worth mentioning:

❗ Conclusion

This analysis gives Trip Away a clearer picture of who's booking, when, from where, and on what device, along with a good look at where the platform is losing people between a search and a completed booking. The findings here are meant to feed directly into pricing, marketing, and route-planning decisions β€” the specifics are laid out in business_impact.md.