/Airlines_Analysis-India-

The Detailed Analysis of Indian Airlines.

Primary LanguageJupyter Notebook

Airlines_Analysis-India-

The Detailed Analysis of Indian Airlines.

EVERYTHING IS GIVEN IN THE .DOCX FILES GIVEN.

Power BI Dashboard

A dashboard is also given for visualization purpose.

Conclusion

  1. 'Air Asia' offers the cheapest flight tickets while flying Economy class while 'Air India' is cheapest while flying Business class.
  2. Booking tickets 3-7 weeks before travel will be cheaper than buying them within 3 weeks of travel as prices rise rapidly in 2-20 days period. Tickets can be cheap when bought just 1 day before however they might not be as cheap as when bought more than 3 weeks before
  3. Ticket price grow linearly with duration of flight peaking when duration of flight reaches 20 hours. However due to some outliers they again fall for for flights with duration of more than 20 hours. Relation can be approximated by 2nd degree curve
  4. Flight departing late at night and arriving early morning or late at night are cheapest.
  5. Flight prices increase with increase in number of stops.
  6. Delhi offers the cheapest flights while Hyderabad is most expensive city to fly to.