07-13-2017 15:28 PM
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
Report Flow (Pages):
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.
PS: This report has been designed keeping in mind the theme - "Data Storytelling".
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.
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?
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 🙂
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.
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.