Skip to content

Latest commit

 

History

History
94 lines (66 loc) · 3.66 KB

README.md

File metadata and controls

94 lines (66 loc) · 3.66 KB

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

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
    image

  • Cost
    image

  • Occurance
    image

  • Effect
    image

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/