Airline Passengers Analysis
Introduction
This project, the fourth at the Analyst League, aims to analyze the satisfaction levels of airline passengers using various ratings. Key metrics include the number of passengers, their age distribution, gender, and satisfaction rates.
Data.
TThe dataset, provided by the Analyst League, consists of 129,880 records and 24 columns. Below are the columns with brief descriptions:
ID: PassengerID
Gender: Passenger gender
Age: Passenger age
CustomerType: The Customer Type
TypeofTravel: Purpose of the flight of the passengers
Class: Travel class in the plane of the passengers
FlightDistance: Flight Distance
DepartureDelay: Minutes Delayed When Departure
ArrivalDelay: Minutes delayed when Arrival
Departure&ArrivalTimeСonvenience: Convenience of departure and arrival times for passengers
EaseofOnlineBooking: Easytobook
Check-inService: Ease Registration
OnlineBoarding: Convenience Of Online Registration
GateLocation: Gate Location Estimation
On-boardService: Service Onboard
SeatComfort: Comfortable Seating
LegRoomService: Leg room service level
Cleanliness: Cleanliness Level
FoodandDrink: Quality Of Food And Drinks
In-flightService: Level Of Service Onboard
In-flightWifiService: Wifi quality level onboard
In-flightEntertainment: Rating Of In-flight entertainment
BaggageHandling: Opinion Baggage Handling
Satisfaction: Airline Satisfaction Level
Data visualization approach
The visualizations use distinct colors to identify whether a passenger is satisfied or not. Each visual presents an overview of the trends or patterns in the data. For example, the first chart in the dashboard uses a single visual to represent ten different rating categories, allowing dynamic selection of the rating type. Important variables include customer type, travel type, class, gender, and age distribution.
Insights
The analysis reveals that 57% of passengers are not satisfied with the airline’s services. This dissatisfaction is widespread across all categories except for business class passengers. New passengers are particularly dissatisfied, with over 18,000 out of 23,780 new passengers reporting dissatisfaction.
Recommendations
From the visualizations and the insight generated, it is worth noting to recommend that the company should implement the following:
- Upgrading seating comfort.
- Improving in-flight entertainment options.
- Enhancing meal quality and variety
- A dedicated onboarding process that educates new passengers about the services and amenities.
- Personalized welcome packages or messages.
- Enhanced support and assistance during the travel experience.
- Strengthen loyalty programs to retain frequent flyers and incentivize repeat business, providing tangible rewards and benefits for continued patronage