Data Visualization of Bird Strikes between 2000-2011

This repository showcases a Power BI dashboard analyzing bird strike incidents in the aviation industry. The project leverages a MySQL database as the data source and advanced Power BI functionalities to provide actionable insights into trends, risks, and preventive strategies for minimizing bird strikes and their associated costs.

---

Table of Contents

• Overview
• Key Features
• Insights and Recommendations
• Data Sources
• Power BI Functionalities Used
• Dashboard Screenshots
• Getting Started
• Feedback

---

Overview

Bird strikes pose significant safety and financial risks to the aviation industry. This Power BI dashboard analyzes over 25,000 bird strike incidents to uncover:

• High-risk locations (airports and states).
• Key phases of flight and altitudes prone to incidents.
• Cost trends and their association with aircraft size.

The insights aim to help aviation stakeholders implement effective wildlife management and safety protocols.

---

Key Features

• Yearly Analysis: Visualizes the trend of bird strikes over time, highlighting a 117% increase between 2000 and 2011.
• Top Airlines and Airports: Identifies the top 10 airlines and 50 airports with the highest number of incidents.
• Cost Analysis: Breaks down costs by year, state, and airlines, revealing critical financial impacts.
• Flight Phase and Altitude: Examines bird strikes by altitude bins and phases of flight, enabling targeted prevention strategies.
• Environmental Factors: Explores the impact of weather and sky conditions on bird strike frequency.

---

Insights and Recommendations

1. High-Risk Locations: Dallas/Fort Worth Intl Airport reported the highest incidents, requiring advanced wildlife management systems.
2. Phases of Flight: Most strikes occur during approach and landing, emphasizing the need for real-time bird activity monitoring.
3. Low Altitude Risks: Over 80% of strikes happen below 1,000 feet, suggesting enhanced ground-level deterrents.
4. Cost Trends: Costs surged by 157.68% over a decade, highlighting the need for proactive measures to reduce financial impacts.

---

Data Sources

• Dataset: Bird Strike records (2000-2011) including:
  • Incident details (date, location, and phase of flight).
  • Environmental factors (weather, sky conditions).
  • Financial data (costs incurred).
• Dataset Link: https://drive.google.com/drive/folders/1hLkL5HO4xG9rIjL8XeS6q-uAjwbTDSX6

---

Power BI Functionalities Used

• Data Modeling: Established relationships between incident, cost, and environmental data.
• DAX Calculations:
  • Year-over-Year growth metrics.
  • Average altitude and aggregated costs.
• Interactive Visualizations:
  • Bar charts, line charts, and slicers for dynamic filtering.
• Power Query: Cleaned and transformed raw data for analysis.
• Tooltips and Drill-Downs: Enabled detailed exploration of trends and metrics.

---

Screenshots

• Overview of Bird Strike in US
  

• Cost
  

• Occurance
  

• Effect
  

---

Getting Started

1. Open the Bird_Strike_Analysis.pbix file in Power BI Desktop.
2. Explore the interactive dashboard and customize as needed.

---

📩 Feedback

If you have any feedback, please reach out to me at Linkedin: https://www.linkedin.com/in/vineet-patel416/