WINAA

Inspiration

Initially, the inspiration behind our product was the pilot shortage experienced around the world and the subsequent compromises companies make to fulfill flights.

What it does

Our program takes into account a large quantity of flight data (roughly 250000 flights per day) and tracks each pilot's performance over their career. The collected data consists of flight elevation, mileage of flight, weather forecast during flight, aircraft, etc... Using the provided information, American Airlines is capable of deciding the ideal pilot for a multitude of situations, increasing both customer safety and company efficiency.

How we built it

We built our application using React and Typescript for our front end in order to incorporate a live updated application with the most recent data from our API. Furthermore, we used node.js in order to access our API as it provides easy communication with react. Furthermore, for our data processing and subsequent data alterations and educated numerical generation, we used python and javascript (backend).

Challenges we ran into

Our team faced a massive challenge upon reaching our final product. We had previously used an SQL database in which we were storing all the imported and generated information. Subsequently, we realized the issues when attempting to live query the information. Since our program accesses roughly 250000 different flights, actively accessing each data set upon run time resulted in major delays. In order to overcome such issues, ew had to create an initial call to the API to access all data at once and then access and organize the data in our own backend, eliminating the need for a database and querying in total as it was made directly accessible to our front end.

Accomplishments that we're proud of

We are proud that we switched away from storing all of our data in a locally stored database. Although a weird thing to be proud of, we were proud that our team was able to make the executive decision to prioritize the functionality of the program rather than the ease of allowing obvious faults.

What we learned

Our group learned an extensive amount within this project. One of the most important skillsets that our team learned was collaboration. Our team comes from a vastly different background with specialization in different coding languages and practices. Although different in our methodology, this experience taught us the necessary steps in developing a LVP (Least valuable product) and expanding on it step by step in order to ensure you always have a final product (especially in a time crunch).