Data anaytics portfolio team 3

It's the fourth week of our amazing journey in Side Hustle Portfolio Bootcamp, and as usual, we've been assigned another amazing project to work on. This week, we set out to decipher the airline passenger satisfaction survey

Content

Gender: Gender of the passengers (Female, Male)

Age: The actual age of the passengers

Type of Travel: Purpose of the flight of the passengers (Personal Travel, Business Travel)

Class: Travel class in the plane of the passengers (Business, Eco, Eco Plus)

Flight distance: The flight distance of this journey

Inflight wifi service: Satisfaction level of the inflight wifi service (0:Not Applicable;1-5)

Departure/Arrival time convenient: Satisfaction level of Departure/Arrival time convenient

Ease of Online booking: Satisfaction level of online booking

Gate location: Satisfaction level of Gate location

Food and drink: Satisfaction level of Food and drink

Online boarding: Satisfaction level of online boarding

Seat comfort: Satisfaction level of Seat comfort

Inflight entertainment: Satisfaction level of inflight entertainment

On-board service: Satisfaction level of On-board service

Leg room service: Satisfaction level of Leg room service

Baggage handling: Satisfaction level of baggage handling

Check-in service: Satisfaction level of Check-in service

Inflight service: Satisfaction level of inflight service

Cleanliness: Satisfaction level of Cleanliness

Departure Delay in Minutes: Minutes delayed when departure

Arrival Delay in Minutes: Minutes delayed when Arrival

Satisfaction: Airline satisfaction level(Satisfaction, neutral or dissatisfaction)

Step 1 : Downloading of data

Download data here

Step 2 : Importing the downloaded csv file "Airline passenger satisfaction" into Microsoft powerBi

Step 3 : we used decomposition tree to show the total number of dissatisfied and satisfied passenger

Note : out of 129880 respondents, 56428 were satisfied while 73452 were dissatisfied

Step 4 : we created a bin for age and visualized using stacked column chart by showing the "age range by satisfaction "

Note : To create a bin right click on the age and select group then you set the bin type to "Number of bins " and bin count "9" also note that we changed the age values from sum to count

Step 5 : we created a doughnut chart which shows the satisfaction by class

Step 6 : we also created a column chart which shows the satisfaction by type of travel and gender

Step 7 : created a column chart which shows the average rate of each airline services

Dashboard

Observations :

1 - we observed that ages between 41 - 49 are more satisfied

2 - we noticed that the business class passengers derived more satisfaction 3 - it was also observed that the wifi airline services has the lowest average

4 - lastly ,we could see that the female gender are always satisfied while traveling for business or personal purpose

Recommendations

1 - we recommend that the wifi services should be worked on

2 - we also recommended that the airline should make amendments were necessary so the Economy class will derive more satisfaction no matter how much they pay for the ticket