This project focuses on analyzing bird strike data provided by the Federal Aviation Administration (FAA) to gain insights into bird strike occurrences at airports. The analysis aims to identify risk factors, assess mitigation strategies, and highlight seasonal trends in bird strike occurrences.
- Developed a logical data model and relational schema for FAA bird strike data.
- Implemented MySQL on the Google Cloud Platform, achieving a database setup time of under 2 hours.
- Executed SQL queries in R to identify the top 10 airports for 1000 airlines, revealing significant insights for risk assessment and mitigation strategies.
- Imported over 25,000 bird strike records into the MySQL database for analysis.
- Performed monthly analysis of bird strike occurrences, visualizing the data in R to highlight seasonal trends and patterns.
The analysis provided valuable insights into bird strike occurrences, allowing stakeholders to make informed decisions regarding risk assessment and mitigation strategies. By leveraging SQL queries and visualization techniques, the project facilitated a comprehensive understanding of bird strike patterns and trends.
- R Studio
- MySQL
- Google Cloud Platform
The bird strikes analysis project offers a robust framework for analyzing bird strike data and extracting actionable insights. By leveraging data modeling, SQL queries, and visualization techniques, the project provides a comprehensive understanding of bird strike occurrences, aiding in the development of effective risk mitigation strategies.