skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Aircraft Wildlife/Bird Strikes in USA

    Aircraft Wildlife/Bird Strikes in USA

    06-01-2017 01:16 AM - last edited 06-13-2017 11:54 AM

    ketan10
    Resolver I
    14147 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    ketan10
    ketan10 Resolver I
    Resolver I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Aircraft Wildlife/Bird Strikes in USA

    ‎06-01-2017 01:16 AM

    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

    Preview file
    129 KB
    Labels:
    • Labels:
    • Education
    • Entertainment
    • Other
    Message 1 of 15
    14,147 Views
    17
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    maxkaoppp
    maxkaoppp Helper II
    Helper II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-17-2022 11:50 PM

    What a great work! Can you please share this pbix file? thanks a lot

    Message 15 of 15
    361 Views
    0
    Reply
    deanne
    deanne
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎03-01-2018 04:58 PM

    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?

    Message 14 of 15
    6,318 Views
    0
    Reply
    Anonymous
    Not applicable
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎02-05-2018 11:22 PM

    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

    Message 13 of 15
    6,328 Views
    0
    Reply
    CS
    CS
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎01-20-2018 08:52 AM

    I like your artistry.

    Message 12 of 15
    6,358 Views
    1
    Reply
    ToddChitt
    ToddChitt Solution Sage
    Solution Sage
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-17-2017 05:47 AM

    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?

    Message 9 of 15
    13,470 Views
    0
    Reply
    ketan10
    ketan10 Resolver I
    Resolver I
    In response to ToddChitt
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-17-2017 10:11 PM

    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!

    Message 10 of 15
    13,444 Views
    0
    Reply
    ToddChitt
    ToddChitt Solution Sage
    Solution Sage
    In response to ketan10
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-19-2017 06:37 AM

    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.

     

    Message 11 of 15
    6,426 Views
    0
    Reply
    pmetaliya
    pmetaliya
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-13-2017 10:20 AM

    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. 

     

     

    Message 2 of 15
    13,867 Views
    0
    Reply
    ketan10
    ketan10 Resolver I
    Resolver I
    In response to pmetaliya
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-13-2017 11:33 AM

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

    Message 3 of 15
    13,859 Views
    0
    Reply
    pmetaliya
    pmetaliya
    Frequent Visitor
    In response to ketan10
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-13-2017 11:41 AM

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

    Message 4 of 15
    13,854 Views
    0
    Reply
    AndrewDang
    AndrewDang Helper IV
    Helper IV
    In response to pmetaliya
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-13-2017 03:28 PM

    Great Infographics.

     

    Thanks;

    Andrew

     

    Message 5 of 15
    13,613 Views
    0
    Reply
    ketan10
    ketan10 Resolver I
    Resolver I
    In response to AndrewDang
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-13-2017 11:13 PM

    Thanks Andrew ! I am glad you liked it.

    Regards,
    Ketan

    Message 6 of 15
    13,610 Views
    0
    Reply
    Anonymous
    Not applicable
    In response to ketan10
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-16-2017 03:56 PM

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

     

    Thanks,

    PK

    Message 7 of 15
    13,529 Views
    0
    Reply
    ketan10
    ketan10 Resolver I
    Resolver I
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-17-2017 10:14 PM

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


    Cheers,
    Ketan !

    Message 8 of 15
    13,443 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices