Flight Delay and cancellation Predition for the year 2015 Tableau Project

Overview

Welcome to my Flight Delay and cancellation Predition for the year 2015 Tableau project! This repository contains two Tableau workbooks with the extension .twb, showcasing insightful visualizations derived from datasets related to flights, airlines, and airports.

Data Source

Data Source

Tableau Public link for this project

https://public.tableau.com/app/profile/rutuja.pohare/vizzes

Tableau Workbooks

1. Workbook 1: [Pohare Tableau Term Project 230] (https://github.com/rutujapohare24/Flight-delay-prediction-using-Tableau/blob/main/Pohare_Tableau_Term_project_230.twb)

   • Description: Provides a overview of all datasets which are connected to inner and outer joins and many to many relationaship.
   • Key Visualizations: Airline's maximum and minimum Arrival and departure delays, Airline Delay based on weekdays and delays, Delays based on the airports.

2. Workbook 2: [Pohare Tableau Term Project 230 1] (https://github.com/rutujapohare24/Flight-delay-prediction-using-Tableau/blob/main/Pohare_Tableau_Term_project_230_1.twb)

   • Description: This Tableau workbook features a visually compelling map that displays average flight delays based on the origin and destination airports for both arrivals and departures. The interactive dashboard allows users to select specific airports, providing insights into the average delays associated with these selections.

     Additionally, a Sankey chart is included, illustrating the relationship between airlines and the number of cancelled flights, categorized by month. This visual representation facilitates the analysis of the cancellation percentages for each airline, offering insights into both the individual and overall impact of cancellations on flights for each respective month in the year 2015. The Sankey chart utilizes sigmoid curves to visually depict the connections between the source (months) and target (airlines) components, enabling a comprehensive understanding of cancellation trends over the specified time period.

   • Key Visualizations: Sankey Chart, Arrival and deaprture visuals on map portal of tableau.

How to Use

1. Clone the Repository:

   https://github.com/rutujapohare24/Flight-delay-prediction-using-Tableau.git

2. Open Tableau Workbooks:

   • Locate the .twb files in the repository.
   • Open each workbook in Tableau to explore the visualizations.

3. Explore Visualizations:

   • Interact with the visualizations to gain insights.
   • Check tooltips and legends for additional information.

4. Provide Feedback:

   • Feel free to open issues or contribute to further enhancements.
   • Share your feedback and insights gained from exploring the visualizations.

Additional Resources

-[Link to PowerPoint Presentation]: https://github.com/rutujapohare24/Flight-delay-prediction-using-Tableau/blob/main/Pohare_DATA230_TREM_PROJECT.pptx

-[Link to Complete Report]: (https://github.com/rutujapohare24/Flight-delay-prediction-using-Tableau/blob/main/Pohare_Term_project_Report.docx)

Thank You