UA_Hackathon hackathon organized by united airlines

Based on our analysis the following are the key factors
which drives the Inflight Satisfaction:
From the table we can see that the higher the score of the
food higher will be the satisfaction. Similarly for arrival
delay the more the delay lower will be the satisfaction
score.

1. Vaibhav Birla
[email protected]
9310426860
Hackathon Project
United Airlines

2. Problem Statement
and Objective
Inflight Satisfaction
Analysis and Key
Findings
Inventory analysis
Customer Comments
Insights
Recommendations
Inventory Management
INDEX

3. To determine factors which drives the F&B
satisfaction rate
Customer Reviews Insights
Inventory analysis

.
Objective
Problem Statement
and Objective
Problem Statement
Identifying opportunity areas in United’s
current Food &Beverage(F&B) service and make
recommendations which can help in increasing
F&B (Food &Beverage) service satisfaction rate
by identifying pain points for our customers and
challenges in our current inventory planning.

4. Overview
We'll deep diving into the factors which drives the Inflight
Satisfaction Rates.
Driving insights from customer reviews
Identifying themes and trends which could help in optimizing the
inventory.
The Inflight Satisfaction Rate for the month of September is 35%
Source:www.grandviewresearch.com

5. Food Score (actual_score)
Arrival of flight
Distance Flown
Arrival delay
Based on our analysis the following are the key factors
which drives the Inflight Satisfaction:
From the table we can see that the higher the score of the
food higher will be the satisfaction. Similarly for arrival
delay the more the delay lower will be the satisfaction
score.
Factors Governing Inflight Satisfaction
Positively Correlated
Negatively Correlated

6. CUSTOMER "COMMENTS"
INSIGHTS
According to customer reviews, we
can clearly see that only about 20% of
the customers have positive review
about the food. Which is a major area
of concern...

7. Chicken Entrée
Other Items
Veg Entrée
From the bubble chart we can clearly see that most ordered
food in flight:
1.
2.
3.
Whereas the average rating of the food remains contant in
comparison:
Customer Food Preferences:

8. Source:www.oec.world
Over the course of whole september over 400K
meals were forecasted. Our Inventory
Prediction model predicted meals with 43%
accuracy.
Hot Entrée is the most pre ordered category of
food whereas sandwiches are the least.

Inventory and Pre-Ordered Meal Analysis

9. Recommendation
Enhance Food Quality and Variety: Based on our correlation analysis and customer
reviews. The satisfaction rates are super heavily dependent on food taste, quality and
variety
Improve Arrival Experience: Improving arrival times and reducing delays can also help
in improving satisfaction scores
Personalized Service: Providing personalized experience to the members using data
driven assistance.
Based on the analysis we performed we can conclude that Inflight Satisfaction Rates are
driven various factors
Following are some recommendation in order to improve the F&B satisfaction score:

10. Future Considerations

Optimizing Inventory by leveraging Pre-Ordered meal data like using machine
learning models to optimize the inventory but its was not possible due to
mutual exclusivity and time constraint
I would also like to see which loyalty segment of customers are pre-ordering
the meals, so we can apply that same strategy to other loyalty programs.
Thank you