Airplane Passenger Satisfaction Dashboard
View interactive dashboard: https://www.novypro.com/project/trihandayani
The Airline Passenger Satisfaction Dashboard, created using Microsoft Power BI, provides valuable insights into passenger satisfaction based on customer type and type of travel. It also includes information on the number of male and female returning passengers, the effect of flight distance on passenger preferences, and the factors that contribute the most to passenger satisfaction. Leveraging the capabilities of Microsoft Power BI, this dashboard serves as a powerful tool for airlines to understand and enhance the overall passenger experience.
Introduction
The Airplane Passenger Satisfaction Dashboard is a comprehensive data analysis project developed using Microsoft Power BI. Its objective is to provide valuable insights into passenger satisfaction based on customer type and type of travel. By analyzing various factors, the dashboard aims to help airlines understand and enhance the overall passenger experience.
Objective
The objective of this project is to analyze and visualize the data related to passenger satisfaction and identify key factors that influence passenger satisfaction levels. The insights gained from this analysis will enable airlines to make informed decisions and improve their services accordingly.
Data Source
The primary data source for this project is reliable and authoritative data obtained from various sources, including MavenAnalytics. The data include information on passenger demographics, flight details, customer feedback, and satisfaction ratings.
Data Cleaning and Preparation
Before analysis, the data underwent a rigorous cleaning and preparation process. This involved removing duplicates, handling missing values, and ensuring data consistency. Additionally, data transformations and aggregations were performed to derive relevant metrics and variables for analysis.
Data Exploration and Visualization
Using Microsoft Power BI, the data were explored and visualized to uncover meaningful patterns and insights. Visualizations such as scatter plots, bar charts, and interactive dashboards were created to present the data in a clear and visually appealing manner. These visualizations allow users to explore passenger satisfaction based on different criteria, such as customer type, type of travel, and specific factors affecting satisfaction.
Insights
- First-time passengers on business trips show a higher number of neutral or dissatisfied responses (17,911) compared to satisfied passengers (5,668). In contrast, returning passengers on business trips indicate a higher number of satisfied responses (46,688) compared to neutral or dissatisfied responses (19,426). For returning passengers on personal trips, there are more neutral or dissatisfied responses (35,946) compared to satisfied responses (4,040).
- A scatter plot analysis reveals that for flight distances below 3,000 km, a majority of passengers choose economy plus or economy class. However, for distances exceeding 3,000 km, a higher number of passengers opt for business class.
- The total number of female returning passengers (53,056) slightly exceeds the number of male returning passengers (53,044), making up 50.01% and 49.99% respectively.
- Factors that significantly influence passenger satisfaction include online boarding and in-flight Wi-Fi service. When online boarding is rated higher (increased by 1.34), the likelihood of passengers being satisfied increases by 3.71 times. Similarly, when in-flight Wi-Fi service is rated above 4, the likelihood of satisfaction being satisfied increases by 2.70 times. Conversely, a decrease in online boarding rating (decreased by 1.34) corresponds to a 3.71 times higher likelihood of passengers being neutral or dissatisfied. In addition, when in-flight Wi-Fi service is rated between 1 and 3, the likelihood of satisfaction being neutral or dissatisfied increases by 1.98 times.
Recommendation
- Improve the experience for first-time passengers on business trips: Given the higher number of neutral or dissatisfied responses from this customer segment, it is crucial to identify the specific pain points and address them. This could involve providing better customer service, enhancing in-flight amenities, or offering personalized assistance for first-time business travelers.
- Enhance the satisfaction of returning passengers on personal trips: The significant number of neutral or dissatisfied responses from this group suggests a need for improvements in the overall passenger experience. Consider implementing measures such as upgraded amenities, special offers, or tailored services to make their personal trips more enjoyable and satisfying.
- Optimize seat allocation based on flight distance: The scatter plot analysis indicates a preference for different travel classes based on the flight distance. To meet passenger expectations, ensure that seat availability and allocation align with the expected duration of the flight. For longer distances, prioritize offering comfortable seating options and amenities that cater to the preferences of business class passengers.
- Strengthen online boarding and in-flight Wi-Fi services: The findings highlight the significance of online boarding and in-flight Wi-Fi service in influencing passenger satisfaction. Invest in enhancing the efficiency and convenience of the online boarding process, such as implementing user-friendly interfaces and reducing wait times. Additionally, focus on providing reliable and high-speed in-flight Wi-Fi connectivity to meet the increasing demand for connectivity during air travel.
- Continuously collect and analyze passenger feedback: Regularly gather feedback from passengers to identify areas for improvement and monitor the effectiveness of implementing changes. Conduct surveys, encourage reviews, and actively engage with passengers to understand their evolving needs and preferences. This feedback will help the airline stay responsive to customer expectations and make data-driven decisions to enhance overall passenger satisfaction.
Visit my portfolio: https://dataexplorewithyani.my.canva.site/
BI portfolio: https://www.novypro.com/profile_projects/trihandayani
LinkedIn profile: http://www.linkedin.com/in/tri-handayani007