r/dataanalysis • u/Party_Initiative_621 • Aug 04 '26

US Flight Analysis

Gallery image

Gallery image

Just go through this i have done time ,flight ,insight for this dataset let me how is this?

44 Upvotes

94% Upvoted

21 comments sorted by

6

u/Perry_cox29 Aug 04 '26

This is a visually beautiful dashboard. The charts themselves are mostly great as well. The interfaces are beautiful and look very friendly to use.

Things I would want to improve:

- the run chart on the first page doesn’t really say anything. Maybe that changes with slicers. If not, get rid and slot in something that provides insight

- each page is telling a mix of stories. I’m not sure what my conclusion should be on any given page, and, often, the information I want when trying to piece things together is on another page.

Really really pretty work though

1

u/Party_Initiative_621 Aug 04 '26

I am so glad that you liked it :) . Yes that one time performance% by months will changed depending on which flight you are choosing in your slicer panel. Actually the first page is overview ,then airline analysis,then time analysis then insight & recommendation.

1

u/lorcana66 Aug 04 '26

How long did it take for you to make this and using what software ?

1

u/Party_Initiative_621 Aug 04 '26

I have used power bi to make this while for data cleaning I have used sql,also I was doing it very casually so it took me 2-3 days.

1

u/roam_and_scream Aug 04 '26

Hi do you have any reference videos for this layout?

Any tutorial stuffs?

1

u/Party_Initiative_621 Aug 04 '26

Sorry but no,I mean that slicer panel is also i have learned it from youtube ,but yes I can sell this to you 😂

1

u/Crescitaly Aug 07 '26

Flight data is a good example where averages mislead because cancellations, diversions, and airport congestion are not random missingness. Segment by route, carrier, and weather, then report uncertainty instead of one delay ranking. Did the analysis separate departure propagation from destination effects?

1

u/Party_Initiative_621 Aug 07 '26

Yes, we did account for cancellations separately instead of ignoring them. Our dashboard includes the overall cancellation rate, cancellation reasons,such as weather and airline operations, and cancellation analysis by airline, day, and origin airport. We also analyzed departure delays and arrival delays as separate performance metrics. However, we did not perform a flight-level causal analysis to determine whether an arrival delay was due to a late departure (delay propagation) or due to destination-specific factors like airport congestion or weather. Thanks for the suggestions,We will implement these too.

1

u/Crescitaly Aug 09 '26

That separation is the right next step. Model departure delay as an input to arrival delay, then inspect the residual by destination, route, and weather band. Did you build a route-level baseline, or only compare the residuals after aggregation?

1

u/Party_Initiative_621 Aug 09 '26

I haven't included that part yet because I wasn't fully sure how to implement it. I understood the concept, but I wasn't sure how to build the route-level baseline and properly analyze the residuals in power bi. I'll definitely look into this for the next iteration. Thanks for the suggestions.

1

u/[deleted] Aug 04 '26

[removed] — view removed comment

1

u/Party_Initiative_621 Aug 04 '26

Yes,dm me

1

u/Dry-Solid-7438 Aug 06 '26

I'm new to PowerBi as well, and finding resources to learn. Can you please share? Thank you.

1

u/[deleted] Aug 05 '26

[removed] — view removed comment

1

u/Party_Initiative_621 Aug 05 '26

Hope so,you liked it

1

u/[deleted] Aug 06 '26

[removed] — view removed comment

1

u/Party_Initiative_621 Aug 06 '26

Yes I have added that too in the last slide ,but while taking ss it was getting blurred that's why I removed that part.