TwD
Chat
Hello Singapore Airlines Revenue Department. I'm TwD, your data analytics assistant. How can I help you analyze your data today?
Show me the revenue trends for premium economy class for the last 6 months
SA
Here's the revenue trend for premium economy class over the past 6 months:
Premium Economy Revenue (Last 6 Months)
January
$4.2M
February
$4.8M
March
$3.5M
April
$5.6M
May
$7.2M
June
$6.9M
Visualization Panel
Top Routes by Revenue
SIN-LON
4.2M
SIN-SYD
2.8M
SIN-NRT
0.5M
SIN-LAX
$9.2M
SIN-HKG
$8.1M
SIN-JFK
$7.7M
Last updated: 2 hours ago · Revenue Q2 2023
Revenue by Class
First Class
$42.3M
Business
$56.7M
Premium Economy
$32.1M
Economy
$51.9M
Last updated: 2 hours ago · Revenue Q2 2023
Premium Economy Monthly Trend
January
$4.2M
February
$4.8M
March
$3.5M
April
$5.6M
May
$7.2M
June
$6.9M
Last updated: 2 hours ago · Data from SIA Revenue System
Passenger Growth YoY
First Class
+18%
Business
+32%
Premium Economy
+42%
Economy
+25%
Last updated: 1 day ago · Comparing 2022 vs 2023
+29.3%
Overall Growth
Data Table View
Query Results
Revenue by route and class for Premium Economy, Q2 2023
142 rows
7 columns
|
Route ID
|
Origin
|
Destination | Class | Month | Passengers |
Revenue (USD)
|
|---|---|---|---|---|---|---|
| SIN-LON-001 | Singapore (SIN) | London (LHR) | Premium Economy | April | 1,245 | ,245,680 |
| SIN-LON-001 | Singapore (SIN) | London (LHR) | Premium Economy | May | 1,376 | ,430,240 |
| SIN-LON-001 | Singapore (SIN) | London (LHR) | Premium Economy | June | 1,298 | ,350,920 |
| SIN-SYD-002 | Singapore (SIN) | Sydney (SYD) | Premium Economy | April | 983 | $756,910 |
| SIN-SYD-002 | Singapore (SIN) | Sydney (SYD) | Premium Economy | May | 1,058 | $814,660 |
| SIN-SYD-002 | Singapore (SIN) | Sydney (SYD) | Premium Economy | June | 1,129 | $870,530 |
| SIN-NRT-003 | Singapore (SIN) | Tokyo (NRT) | Premium Economy | April | 867 | $590,776 |
| SIN-NRT-003 | Singapore (SIN) | Tokyo (NRT) | Premium Economy | May | 921 | $627,722 |
| SIN-NRT-003 | Singapore (SIN) | Tokyo (NRT) | Premium Economy | June | 982 | $668,904 |
| SIN-LAX-004 | Singapore (SIN) | Los Angeles (LAX) | Premium Economy | April | 724 | $905,000 |
Rows per page:
1-10 of 142
Query & Code View
Generated SQL Query
Premium Economy Revenue by Route for Q2 2023
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
SELECT
r.route_id,
a1.airport_code AS origin,
a1.airport_name AS origin_name,
a2.airport_code AS destination,
a2.airport_name AS destination_name,
f.class_name,
DATE_TRUNC('month', b.booking_date) AS month,
COUNT(b.passenger_id) AS total_passengers,
SUM(b.fare_amount) AS total_revenue
FROM bookings b
JOIN flights f ON b.flight_id = f.flight_id
JOIN routes r ON f.route_id = r.route_id
JOIN airports a1 ON r.origin_airport_id = a1.airport_id
JOIN airports a2 ON r.destination_airport_id = a2.airport_id
WHERE f.class_name = 'Premium Economy'
AND b.booking_date BETWEEN '2023-04-01' AND '2023-06-30'
GROUP BY r.route_id, a1.airport_code, a1.airport_name, a2.airport_code, a2.airport_name, f.class_name, month
ORDER BY total_revenue DESC;
Generated in: 0.5s
Time to execute: 1.2s
Dashboard Creator
Top Routes by Revenue
Q2 2023 · Premium Economy
SIN-LON
4.2M
SIN-SYD
2.8M
SIN-NRT
0.5M
SIN-LAX
$9.2M
SIN-HKG
$8.1M
SIN-JFK
$7.7M
Revenue by Class
Q2 2023 · All Routes
Business Class
$56.7M (31%)
Economy
$51.9M (28%)
First Class
$42.3M (23%)
Premium Economy
$32.1M (18%)
Monthly Trend
Q2 2023 · Premium Economy
$4.2M
$4.8M
$3.5M
$5.6M
$7.2M
$6.9M
$7.0M
Add Visualization
Key Metrics
Total Revenue
+12.4%
$32.1M
Passengers
+8.7%
38,214
Avg. Fare
+3.2%
$840
Settings
Profile Settings
SC
Interface Preferences
Theme
Choose your preferred interface theme
Default Dashboard
Select which dashboard to show on startup
Language
System interface language
Chat Interface
Customize how the chat appears and behaves
Data & Privacy
Default Data Format
Choose your preferred data export format
Query History
Manage your past queries