Airline Client — Operations & Performance BI
Centralized Aviation Analytics · Powered by Bivonix · CDG Hub 2024
SQL Server + Power BI
Star Schema · RLS
Live Feed
Executive Overview
Operations
Customer Experience
Revenue & Finance
Architecture
Executive Summary — All KPIs at a Glance
On-Time Performance
81.6%
▼ 1.2% vs last month
Ticket Sales
3.64M
▲ 8.4% YoY
CSAT Score
7.9/10
▲ 0.4 vs last qtr
Net Promoter Score
54
▲ 6 pts YoY
Avg Ticket Price
€235
▲ €12 vs last yr
Flight Delay Rate
14.3%
▲ above 12% target
Load Factor
84.7%
▲ 1.9% vs target
Utilization Ratio
88.2%
▲ 2.1% vs last qtr
Cancellation Rate
0.9%
▼ 0.3% improved
RASK
€0.087
▲ 3.1% YoY
Monthly Ticket Sales + Revenue Target Jan–Dec 2024
Ticket Sales (K) Revenue Target
Business Impact Post-Bivonix
60%
Faster reporting turnaround time
50%
Dashboard load time reduction
4 → 1
Siloed systems unified into one platform
Real-time
Operational visibility for leadership
Operations Dashboard — Flight Performance & Delay Analytics
OTP
81.6%
▼ below 85% target
Avg Delay
28 min
▲ 3 min vs last mo
Turnaround
42 min
▼ 3 min vs target
Gate Efficiency
91.4%
▲ 1.2% vs target
Fuel Efficiency
3.8 L/km
▼ −0.2 improved
All Flights
On-Time
Delayed
Cancelled
Live Flight Feed CDG departures — today
AF 011CDG→JFK10:15On Time
AF 354CDG→MAD11:30Delayed +35m
AF 082CDG→LHR12:00On Time
AF 472CDG→DXB13:20Cancelled
AF 664CDG→FRA13:50On Time
AF 228CDG→SIN14:10Delayed +18m
AF 116CDG→NRT14:45On Time
AF 390CDG→BOS15:00Delayed +52m
Delay Causes Breakdown
Weather 38% ATC 26% Technical 22% Crew 14%
Route OTP Performance Top 8 routes — CDG hub
CDG → LHR
92%
CDG → AMS
90%
CDG → JFK
88%
CDG → NRT
83%
CDG → FRA
81%
CDG → SIN
79%
CDG → MAD
76%
CDG → DXB
72%
OTP Trend — Monthly Jan–Dec 2024
Customer Experience — Satisfaction, NPS & Feedback
CSAT Score
7.9/10
▲ 0.4 vs last qtr
Net Promoter Score
54
▲ 6 pts YoY
Resolution Rate
89.3%
▲ 3.1% improved
Retention Score
73.2%
▲ 1.8% vs last yr
CSAT & NPS Trend 6-month rolling
CSAT /10 NPS /10 (scaled)
NPS Breakdown
Promoters
62%
Passives
22%
Detractors
16%
Avg response time4.2 hrs
Open complaints312
Resolved this week1,847
Satisfaction by Category
In-flight service
8.4
Check-in experience
7.8
Lounge quality
8.2
Delay communication
6.1
Baggage handling
7.0
Complaint resolution
7.5
Passenger Feedback Volume — Monthly Positive vs Negative
Positive feedback Negative feedback
Revenue & Financial Performance
Total Revenue
€856M
▲ 11.2% YoY
Ticket Sales
3.64M
▲ 8.4% YoY
Avg Ticket Price
€235
▲ €12 vs last yr
RASK
€0.087
▲ 3.1% YoY
Load Factor
84.7%
▲ 1.9% vs target
Revenue Trend + Forecast Jan–Dec 2024 · monthly
Actual revenue (€M) Forecast (€M)
Route Profitability
CDG → JFK
91%
CDG → LHR
88%
CDG → NRT
83%
CDG → SIN
79%
CDG → DXB
72%
CDG → MAD
65%
Revenue by Cabin Class 2024 split
Business 48% Economy 34% Prem. Economy 13% First 5%
Quarterly Performance
Q1 2024€188M+7.2% YoY
Q2 2024€214M+10.4% YoY
Q3 2024€256M+14.1% YoY
Q4 2024€198M+9.8% YoY
Occupancy Rate84.7%
Ancillary Revenue€62M
Data Architecture & Technical Stack
End-to-End Data Pipeline — Bivonix Implementation
Flight Ops
Systems
SAP CRM
& Sales
Customer
Feedback
GDS
Ticketing
Aircraft
Telemetry
↓ SSIS ETL Pipelines — Extract · Transform · Load · Validate ↓
Staging Schema
Raw Cleansed
SQL Server DWH
Star Schema
Fact: Flights
Sales · Feedback
Dims: Time
Route · Aircraft
↓ DirectQuery (Live Ops) + Import Mode (Historical) ↓
Power BI
Service
Exec Dashboard
Full Access
Regional Mgr
Route Filter RLS
Sales Team
BU Filter RLS
Power BI
SQL Server 2022
SSIS
DAX
Star Schema
Row-Level Security
DirectQuery
Import Mode
Incremental Refresh
Pre-Aggregated Views
Kimball Methodology
Data Refresh Schedule
Flight operationsReal-time
Ticket salesDaily 06:00
Customer feedbackWeekly Mon
Revenue & financeDaily 08:00
Aircraft telemetryNear real-time
Incremental loadsEnabled
DAX Measures Used
CALCULATE()KPI definitions
TOTALYTD()YTD revenue
DATEADD()Period comparison
DISTINCTCOUNT()Unique passengers
FILTER()Route segmentation
PREVIOUSMONTH()MoM delta
RLS Roles & Access
Executives
Full cross-functional access to all KPIs
Regional Managers
Filtered by route & region
Sales Teams
Restricted to business unit data
Customer Service
Complaints & satisfaction only
Performance Optimization Results Before vs After Bivonix
Before Bivonix After Bivonix