Data Features:
- Header: Summary of Flight Experience Review
- Author: Reviewer's Name
- Date: Date of Review
- Place: Country of Review Origin
- Content: Review Description
- Aircraft: Aircraft Type Flown
- Traveller Type: Type of Traveller (e.g., Business, Leisure)
- Seat Type: Class or Seat Type Flown
- Route: Flight Route Taken
- Date Flown: Date of the Flight
- Recommended: Willingness to Recommend British Airways to Others
- Trip Verified: Review and Trip Verification Status
- Rating: Overall Rating
- Seat Comfort: Rating for Seat Comfort
- Cabin Staff Service: Rating for Cabin Staff Service
- Food & Beverages: Rating for Food and Beverages
- Ground Service: Rating for Ground Services
- Value for Money: Rating for Value for Money
- Entertainment: Rating for Inflight Entertainment
Transformations:
- Data Type Conversions: Converted columns to appropriate data types for analysis.
- Removal of Null or Empty Values: Records with null or empty values were removed to ensure data quality.
- Data Modeling: Incorporated country details from a separate table, including acronyms, regions, and continents, to enrich the analysis.
- Grouping Aircraft: Due to the multitude of distinct aircraft types, those with less than 50 reviews were grouped under the "Other Various" category for better clarity and analysis.
Key Metrics: • Avg Overall Rating: 4.2 • Avg Cabin Staff Service Rating: 3.3 • Avg Food Beverages Rating: 2.4 • Avg Entertainment Rating: 1.4 • Avg Ground Service Rating: 3.0 • Avg Value for Money Rating: 2.8 • Avg Seat Comfort Rating: 2.9
