Airline Data Analysis

Overview

This repository contains an analysis of airline data to address profitability challenges faced by our company. The analysis aims to identify opportunities to increase occupancy rates and boost average profit per seat.

Business Problem

Our air transportation company is facing challenges due to:

• Stricter environmental regulations
• Higher flight taxes
• Increased interest rates
• Rising fuel prices
• Tight labor market leading to higher labor costs

These factors are putting pressure on the company's profitability, necessitating a data-driven approach to find solutions.

Key Findings

Aircraft Analysis

• Boeing 777-300 has the maximum number of seats (402)
• Airbus A319-100 has the highest average number of Business and Economy class seats
• Boeing 777-300 has the maximum number of Comfort seats

Booking Trends

• Gradual increase in ticket bookings from June 22nd to July 7th
• Stable bookings from July 8th until August, with a notable peak on one day
• Revenue closely correlated with number of tickets booked

Revenue Analysis

• SU9 aircraft generates the highest total revenue, likely due to lower ticket prices
• CN1 aircraft has the lowest total revenue, possibly due to limited economy class offering

Recommendations

1. Optimize pricing strategies for gradual revenue growth
2. Focus on improving occupancy rates through targeted marketing and operational adjustments
3. Analyze factors contributing to booking peaks to replicate success
4. Balance profitability with consumer satisfaction and safety

Data Source

The data used in this analysis is sourced from Kaggle - Airline Data Analysis.