Skip to content

Boston Consulting Group Case study to mine Global Air Traffic data to predict and find key areas of improvement for airliners and airports

Notifications You must be signed in to change notification settings

geekidharsh/analyze-and-optimize-airtrafficroutes

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

28 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Air Traffic Optimization:

A Data mining and Analysis Case Study to Optimize best routes for a Top Flight Carrier and help them grow, this data was part of an exercise done for one of the top consulting firms.

Goal:

Goal of this case study was to evaluate Transtats Yearly data for a particular year, mine it, create data models and answers business challenges, provide recommendations and more.


Project Solution Layout:

- I used python to decompress raw data, build some cleaning functions using pandas. Next up, i pused the data on MySQL built models for it and ran queries to answer the questions provided.
- I also gathered some data that wasn't provided, like some lookup datasets for flights and used join to map them to the original dataset in order to better understand the case. 
- I built a presentation for the entire study drawing inferences from the data and my learnings and better convey the story. Optionally, bult a little webpage using html5 and css and embeded Tableau viz. 

This project includes the following contents:

  • assets - raw data and gathered data.
  • codes - sql and py scripts i wrote for wrangiling data.
  • data - a sample of the dataset from TranStat. I've included first, last months and airline lookup files. More can be found here
  • presentation and reports
  • Optional Dashboard homepage- Built in javascript, html and css with embeded Tableau. Visit Project Homepage

Below is part of the report:

Report

About

Boston Consulting Group Case study to mine Global Air Traffic data to predict and find key areas of improvement for airliners and airports

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published