Right now, the power to solve new global challenges across industries, is at your fingertips, no matter where you're working from. Create a new topic or reply to an existing thread to share your perspective.

Industry Discussions

Share resources, connect with others, and discuss industry-specific challenges.

Maximizing Airline Revenue & Predicting Failure Trends

10 - Fireball

Good Day Alteryx Transportation UG Members!


We are very close to the holiday season, only about a week and a half to go! As we all know it gets extremely busy around this time of year. We really appreciate and thank everyone who attended our Q4 Transportation User Group session earlier this week!


Additional thanks to our talented speakers, Sergiu Ispas, Revenue Management Analyst II from Alaska Airlines, and Nick Smith, Solutions Engineer from Alteryx.







We began the meeting with Sergiu’s use case: Maximizing Airline Revenue Through Targeted Overbooking. Sergiu explained the reasons and sensitivities behind overbooking and how he strives to find that balance between making revenues for the airline and ensuring top customer satisfaction.  The full presentation and recording are available for replay.





Following the use case, a few announcements were made:

  • Inspire will be taking place on June 10-14, 2019 in Nashville, TN. Alteryx is looking for speakers with use cases! If you are interested in presenting, please submit your request to the Alteryx Community Team by Friday, January 4th, 2019. If selected, you will receive a free pass to Inspire 2019!
  • If you missed any meetings, you can catch all recordings right on the Alteryx Community Page. All Industry User Group meetings are recorded and are available for replay.
  • For those Alteryx geeks who love to experiment, Alteryx has a BETA program where you can apply to test out the latest features and provide feedback!
  • Recently, Alteryx started an analytics podcast called Alter.Everything. Our very own Heather Harris was on the 1st Feel free to check out all episodes which are available on Community.



Our 2nd use case was on Predicting Failure Trends to Save Time and $$. Nick provided a real live example of a customer that uses Market Basket Analysis to associate part failures. Using this prescriptive correlation, the maintenance team can then optimize their maintenance schedule to limit downtime and future failures. The last step after the analysis was to output it to a Tableau dashboard.



The Transportation User Group is always looking for speakers who would like to share their use cases. If presenting to our Global audience interests you, please get in touch with Chris Shernaman at cshernaman@alteryx.com.


Let us know the topics you'd be interested in and what you are looking forward to most from this user group. Take a few moments to fill out our survey: https://www.surveymonkey.com/r/KC8CJ76


William Chan | @WilliamChan | LinkedIn

Alteryx Transportation and Montreal User Group Co-Leader

Business Analyst, Distribution and Payments | Air Canada


12 - Quasar



Great presentation! Thanks for posting!


Anything to share on how the airline industry has changed and has been impacted since the 2020 pandemic? 





10 - Fireball

Hi @jacob_kahn ,


From a business standpoint, airlines are running skeleton staff and have reduced their capacities by 90%. I actually left Air Canada in March for the pharma industry so I can't provide any recent insight, but I know it's not looking good there at all. Many CapEx projects are frozen and it's really about survival right now. The industry will recover but it will take some time before travellers feel confident about getting up in the air again.