Aircraft Wildlife/Bird Strikes in USA 06-01-2017 01:16 AM - last edited 06-13-2017 11:54 AM

[ketan10]

Topic:
Wildlife and bird strikes - sometimes called birdstrike is a collision between an wildlife species (usually a bird) and a human-made vehicle, especially aircraft.

Bird strikes pose a significant threat to flight safety, and have caused a number of accidents.

This report gives us a detailed outlook and some significant figures of the strikes in USA between the year 1990 and 2015

Data Source: Open Dataset on Kaggle/data.world

Icons/Images: Google

Report Flow (Pages):

1. Overview
2. Effects across Geography.
3. Impacts on Flights.
4. Distribution of strikes across Phases of Flight.
5. Seasonality & Weather Effect.
6. Wildlife Effects.
7. Strikes Distribution by State.
8. Miracle on the Hudson.
9. Author

PS: This report has been designed keeping in mind the theme - "Data Storytelling".

eyJrIjoiZThmNjIyZTItYmUwOS00N2I5LWEyZjgtODE4ZjU5NTE3ZGI2IiwidCI6IjNhOTI1M2YyLWEzYTItNDE0Mi1iYTkzLWU2MGNmZjMwNmJhZSIsImMiOjEwfQ

[deanne]

Hi, I think the presentation format is great - would it be possible to get a copy of the powerbi file?  Also, are you using PowerBI Cloud version?

[Anonymous]

Hi Ketan,

First off, I love the presentation! Amazing!

Just wondering how you've done the paging of the power BI report to look like that. Sorry for the stupid question, just a newbie when it comes to Power BI.

Thanks!

Kelvin

[CS]

I like your artistry.

[ToddChitt]

Great job. I like how you laid out the visuals. And your choice of color scheme is pleasing.

But I'm curious about the analysis aspect of your data. Are there more strikes in Texas, California, Florida, New York and Illinois simply because there are more flights from the airports in those cities? Are you just reporting the numbers, or doing percentage of events?  Look at any route map of any airline and those states are going to have the majority of the hubs.

Likewise, do more strikes occur during the DAY because there are more flights during the day? Based on page 5, looks like the best time to fly would be during rain, fog and snow. 🙂

Any chance you would share your data sources?

[ketan10]

Hi Todd!
Thanks for the constructive feedback. I can understand your curiosity regarding the numbers represented and the analysis done. This report is more of datastorytelling, using the underlying static datasources. I am reporting the numbers(strikes) as a percentage of grand total. As far as the numbers on the page 5 you have mentioned, again, it is just the representation of the data from FAA.
Sharing with you the link to the raw data source (Data Source). I believe this would make things more clearer 🙂

Cheers,
Ketan!

[ToddChitt]

Thanks for sharing the data source.

If you have any insights on where I could get baseling flight data, that would be helpful. I have searched DOT, FAA and data.gov sites to no avail.

[pmetaliya]

Very cool report Ketan. Which visualization you have used to crate table Heat Map on page 7? Is it Table Heat Map ? link

I tried Table Heat Map but coudn't make it as clean looking as you have. 

[ketan10]

Thanks @pmetaliya ! The "heatmap" is actually a "Matrix" visual. Intentionally used it to look like a heatmap. 

[pmetaliya]

Duh. Totally forgot about the conditional formatting in matrix. Thanks.

[AndrewDang]

Great Infographics.

Thanks;

Andrew

[ketan10]

Thanks Andrew ! I am glad you liked it.

Regards,
Ketan

[Anonymous]

Wow! That is pretty awesome. Would you be able to share the Pbix file? Totally understand if you can't

Thanks,

PK

[ketan10]

Hi,
Thank you for your kind words. I can share with you the underlying datasource. Here is the link

Cheers,
Ketan !