MakeYourTrip is a thoughtfully designed synthetic dataset that captures the essence of a modern travel booking platform. From flights and hotels to customer preferences and payment flows, it offers everything you need to explore how users interact with travel services. Ideal for data scientists, developers, and analysts, it helps you dive into user behavior, uncover booking patterns, and test recommendation engines or backend booking workflows — all without dealing with real user data or privacy concerns.
The dataset features detailed records on users, trips, bookings, reviews, payments, and even cancellations and discounts. It’s perfect for building smart pricing models, segmenting travelers, or forecasting demand across seasons and locations. Whether you're prepping for interviews, simulating booking systems, or fine-tuning your data skills, MakeYourTrip gives you a complete, realistic environment to work with.
Highlights:
- Simulates an end-to-end travel booking platform, including flights, hotels, destinations, and customer interactions.
- Ideal for building models in travel recommendation systems, price prediction, and demand forecasting.
- Supports testing of backend systems such as booking management, payment processing, and customer support workflows.
- Provides data for analyzing booking trends, customer segmentation, and the impact of promotions on sales.
- Great for SQL practice, time-series analysis, and A/B testing to optimize travel-related services.
The Make Your Trip schema supports a travel booking platform, managing users, flights, hotels, tours, bookings, payments, and reviews. It enables customers to book flights, hotels, and tours while also handling payments, discounts, and notifications.
Key tables in the dataset include:
- Users: Stores user details such as username, email, phone number, role (customer, admin, agent), and timestamps for account creation and updates.
- Flights: Contains information about available flights, including flight number, airline, departure/arrival cities, times, available seats, and price.
- Hotels: Stores hotel details such as name, location, available rooms, price per night, amenities (e.g., pool, wifi), and rating.
- Tours: Contains information about tours, including tour name, destination, dates, available slots, price, and description.
- Bookings: Records booking information, including the user ID, booking type (flight, hotel, or tour), booking date, status, and total amount.
- Flight Bookings: Details bookings specific to flights, linking to the bookings table and storing the number of passengers and total price for flight bookings.
- Hotel Bookings: Stores bookings specific to hotels, linking to the bookings table and storing the number of rooms, check-in/check-out dates, and total price.
- Tour Bookings: Stores bookings specific to tours, linking to the bookings table and storing the number of persons and total price for tour bookings.
- Payments: Stores payment information, including payment method, status, amount, transaction ID, and timestamps for payment processing.
- Reviews: Allows users to submit reviews on their bookings, including ratings (1-5) and text feedback for flights, hotels, and tours.
- Discounts: Defines discount codes, including the discount percentage and valid date range, which can be applied to bookings.
- Notifications: Records notifications sent to users about bookings, payment statuses, offers, or other relevant messages. Tracks whether notifications are read or unread.
The MakeYourTrip dataset was generated to reflect the operations of an end-to-end travel and booking platform. It includes synthetic data covering flight reservations, hotel bookings, vacation packages, payment records, and user reviews. AI-driven models were used to simulate realistic user journeys, seasonal trends, booking behaviors, and availability logic. No real user or trip data was used—ensuring complete privacy and security. The dataset is suitable for testing travel tech systems, itinerary builders, booking engines, and user engagement tools in the travel industry space.
MakeYourTrip offers comprehensive travel-related data, from hotel and flight bookings to payments and customer reviews. Designed to power recommendation systems and travel analytics, the dataset integrates smoothly with local tools, relational databases, and cloud warehouses for scalable analysis and real-time simulations.
- Available file formats: CSV, JSON, Excel
- Available databases: MySQL, PostgreSQL, SQL Server
- Cloud database access: Snowflake
