Presentation Flashcards
(7 cards)
Introduction
Good afternoon, everyone. Today I’ll be presenting an interactive visualisation dashboard focused on the “Additional Businesses and Group Functions” segment of the Lufthansa Group. This segment includes AirPlus, Lufthansa Aviation Training, Lufthansa Systems, and several group service companies. Using Tableau, I’ve developed six analytical charts to explore their financial and operational performance from 2019 to 2023 and incorporated them into the dashboard above.
Chart 1
Starting with operating income and expenses: From 2022 to 2023, both additional businesses and group functions showed an increase in income, which suggest an improvement overtime. However the margin between income and expenses narrowed for group functions, highlighting growing cost pressures. Additional businesses still operated at a loss, saw their margin improve by over 45%, indicating improving financial performance.
Chart 2
Next, the trendline compares total revenue between the Lufthansa Group and our segment. The Group experienced a sharp 62.7% revenue drop in 2020 due to COVID-19, while the segment saw a smaller 33.9% drop. This smaller impact shows that many of the segment’s services like IT and financial services were less reliant on travel, allowing them to adapt better during lockdowns.
Chart 3
To reinforce this, I compared the segment to Austrian Airlines another business in the Lufthansa Group. Austrian Airlines saw a 78% drop in revenue during COVID-19 due to flight suspensions, while our segment dropped only 34%. Interestingly, in 2021, Austrian Airlines recovered rapidly as borders reopened, but the segment’s revenue continued to fall, suggesting delayed effects or a shift in group priorities.
Chart 4
Looking at adjusted EBIT, performance varied. LAT improved significantly going from a -1 million EBIT in 2022 to +16 million in 2023 thanks to increased training volumes and VR-based course offerings. AirPlus and Lufthansa Systems also saw strong EBIT growth due to higher billing and new clients. However, group functions declined due to rising IT and staffing costs.
Chart 5
This heatmap utilises the red-blue colour gradient to compare adjusted EBIT against EBIT for 2019 to 2023. Red tones in 2020–2021 show the segment’s losses during the pandemic. Across all years, adjusted EBIT appears to have less volatility in colour shade compared to EBIT, implying that it’s a more stable performance indicator.
Chart 6
Finally, capital expenditure remains low and steady across all years. Operating income consistently exceeds CapEx, suggesting a cautious investment strategy. While this supports short-term profitability, it may indicate underinvestment in infrastructure or innovation.
