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 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.
- 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