Phân Tích Phòng (Room Analytics)¶
Trang Phân Tích Phòng (Room Analytics) cung cấp insights chi tiết về hiệu suất hoạt động của phòng, bao gồm occupancy rates, revenue metrics, room utilization, performance trends và các chỉ số quan trọng khác giúp tối ưu hóa doanh thu và vận hành khách sạn.
Tổng Quan¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Trang tổng quan hiển thị:
- Key Performance Indicators (KPIs): Các chỉ số chính (Occupancy %, ADR, RevPAR, Revenue)
- Date Range Selector: Chọn khoảng thời gian phân tích
- Quick Filters: Bộ lọc nhanh theo room type, floor, status
- Dashboard Cards: Tổng quan nhanh các metrics quan trọng
- Interactive Charts: Biểu đồ tương tác với drill-down capability
- Export Options: Xuất báo cáo PDF, Excel, CSV
Key Metrics Explained¶
graph TD
A[Room Analytics Metrics] --> B[Occupancy Metrics]
A --> C[Revenue Metrics]
A --> D[Operational Metrics]
A --> E[Performance Metrics]
B --> B1[Occupancy %]
B --> B2[Available Rooms]
B --> B3[Occupied Rooms]
B --> B4[OOO Rooms]
C --> C1[ADR - Average Daily Rate]
C --> C2[RevPAR - Revenue Per Available Room]
C --> C3[Total Revenue]
C --> C4[TRevPAR - Total RevPAR]
D --> D1[Room Nights Sold]
D --> D2[No-Shows]
D --> D3[Early Checkouts]
D --> D4[Late Checkouts]
E --> E1[Performance by Room Type]
E --> E2[Performance by Floor]
E --> E3[Seasonal Trends]
E --> E4[Comparison vs Budget]Dashboard Overview¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Summary KPI Cards¶
Dashboard hiển thị 4 KPI cards chính:
| KPI | Công Thức | Mô Tả | Target |
|---|---|---|---|
| Occupancy % | (Occupied Rooms / Available Rooms) × 100 | Tỷ lệ phòng đang sử dụng | > 75% |
| ADR | Total Room Revenue / Rooms Sold | Giá trung bình mỗi phòng bán được | Tùy mùa |
| RevPAR | Total Room Revenue / Available Rooms hoặc ADR × Occupancy % |
Doanh thu trên mỗi phòng available | > Budget |
| Total Revenue | Sum of all room revenue | Tổng doanh thu phòng | Target MTD/YTD |
Example Display:
┌─────────────────────────┐ ┌─────────────────────────┐
│ Occupancy Rate │ │ ADR (Average Daily │
│ 82.5% │ │ Rate) │
│ ↑ 5.2% vs last month │ │ 2,500,000 VND │
│ Target: 75% │ │ ↑ 3.1% vs last month │
└─────────────────────────┘ └─────────────────────────┘
┌─────────────────────────┐ ┌─────────────────────────┐
│ RevPAR │ │ Total Revenue (MTD) │
│ 2,062,500 VND │ │ 450,000,000 VND │
│ ↑ 8.7% vs last month │ │ 95% of target │
│ On track │ │ Target: 475M │
└─────────────────────────┘ └─────────────────────────┘
Date Range & Comparison¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Quick Presets: - Today - Yesterday - Last 7 Days - Last 30 Days - This Month (MTD - Month to Date) - Last Month - This Year (YTD - Year to Date) - Custom Range
Comparison Options: - Compare to Previous Period - Compare to Same Period Last Year - Compare to Budget/Forecast - No Comparison
Occupancy Analysis¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Occupancy Trend Chart¶
Line chart hiển thị xu hướng occupancy theo thời gian:
Features: - Daily/Weekly/Monthly aggregation toggle - Multiple lines: Occupancy %, Available Rooms, Occupied Rooms, OOO Rooms - Hover tooltips: Chi tiết từng data point - Zoom & Pan: Phóng to và di chuyển timeline - Markers: Highlight special events (holidays, conferences)
Occupancy Breakdown¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
By Room Type:
| Room Type | Total Rooms | Available | Occupied | OOO | Occupancy % | vs Last Period |
|---|---|---|---|---|---|---|
| Standard | 50 | 48 | 42 | 2 | 87.5% | ↑ 5% |
| Deluxe | 30 | 29 | 25 | 1 | 86.2% | ↑ 3% |
| Suite | 15 | 15 | 10 | 0 | 66.7% | ↓ 2% |
| Villa | 5 | 5 | 4 | 0 | 80.0% | → 0% |
| Total | 100 | 97 | 81 | 3 | 83.5% | ↑ 4% |
By Floor:
Stacked bar chart hoặc table showing occupancy by floor level.
By Day of Week:
Heatmap hoặc bar chart showing: - Monday: 65% - Tuesday: 68% - Wednesday: 70% - Thursday: 75% - Friday: 92% - Saturday: 95% - Sunday: 80%
Occupancy Calendar Heatmap¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Calendar view với color-coded occupancy levels: - 0-50%: Light Blue (Low) - 50-75%: Yellow (Medium) - 75-90%: Orange (High) - 90-100%: Red (Very High) - 100%+: Dark Red (Full/Overbooked)
Click vào ngày để xem chi tiết breakdown.
Revenue Analysis¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Revenue Trend¶
Line/Area Chart showing: - Total Revenue (primary axis) - RevPAR (secondary axis) - ADR (secondary axis) - Rooms Sold (volume bars)
Aggregation levels: Daily, Weekly, Monthly, Quarterly
ADR Analysis¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
ADR by Room Type:
| Room Type | ADR | Min Rate | Max Rate | Avg Discount % | vs Last Period |
|---|---|---|---|---|---|
| Standard | 1,200,000 | 900,000 | 1,500,000 | 8% | ↑ 2.5% |
| Deluxe | 2,500,000 | 2,000,000 | 3,200,000 | 6% | ↑ 3.1% |
| Suite | 5,000,000 | 4,200,000 | 6,500,000 | 5% | ↑ 1.8% |
| Villa | 12,000,000 | 10,000,000 | 15,000,000 | 3% | → 0% |
ADR by Channel:
Bar chart comparing ADR across booking channels: - Direct Booking: 2,800,000 VND (highest) - OTA (Booking.com): 2,400,000 VND - OTA (Agoda): 2,350,000 VND - OTA (Expedia): 2,300,000 VND - Corporate: 2,200,000 VND (negotiated rates)
ADR Trend Over Time:
Line chart showing ADR fluctuation: - Seasonal patterns - Peak season spikes - Low season dips - Pricing strategy effectiveness
RevPAR Analysis¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
RevPAR Components:
Waterfall chart showing: 1. Starting Point: Budget RevPAR 2. Impact of Occupancy Change: +/- X VND 3. Impact of ADR Change: +/- Y VND 4. Actual RevPAR: Final value
RevPAR Index:
Comparison với competitors (nếu có data):
Your RevPAR: 2,062,500 VND
Market RevPAR: 1,950,000 VND
RevPAR Index: 105.8 (Outperforming market by 5.8%)
Revenue by Source¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Pie/Donut Chart: - Direct Booking: 35% (157,500,000 VND) - Booking.com: 25% (112,500,000 VND) - Agoda: 20% (90,000,000 VND) - Expedia: 12% (54,000,000 VND) - Other OTAs: 5% (22,500,000 VND) - Corporate: 3% (13,500,000 VND)
Table với Commission Impact:
| Channel | Revenue | Commission Rate | Commission Paid | Net Revenue | % of Total |
|---|---|---|---|---|---|
| Direct | 157.5M | 0% | 0 | 157.5M | 35% |
| Booking.com | 112.5M | 15% | 16.9M | 95.6M | 25% |
| Agoda | 90M | 18% | 16.2M | 73.8M | 20% |
| Expedia | 54M | 20% | 10.8M | 43.2M | 12% |
| Other | 22.5M | 15% | 3.4M | 19.1M | 5% |
| Corporate | 13.5M | 0% | 0 | 13.5M | 3% |
| Total | 450M | Avg 10.5% | 47.3M | 402.7M | 100% |
Room Performance¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Performance by Room Type¶
Multi-metric Table:
| Room Type | Rooms | Occ % | ADR | RevPAR | Revenue | Room Nights | Avg LOS | Performance Score |
|---|---|---|---|---|---|---|---|---|
| Standard | 50 | 87.5% | 1.2M | 1.05M | 52.5M | 1,312 | 2.1 | 92/100 ⭐⭐⭐⭐ |
| Deluxe | 30 | 86.2% | 2.5M | 2.16M | 64.8M | 775 | 2.3 | 95/100 ⭐⭐⭐⭐⭐ |
| Suite | 15 | 66.7% | 5.0M | 3.34M | 50.1M | 300 | 2.8 | 78/100 ⭐⭐⭐ |
| Villa | 5 | 80.0% | 12M | 9.6M | 48M | 120 | 4.0 | 88/100 ⭐⭐⭐⭐ |
Performance Score Calculation: - Occupancy vs Target: 40% - ADR vs Target: 30% - RevPAR vs Target: 30%
Bubble Chart: - X-axis: Occupancy % - Y-axis: ADR - Bubble size: Total Revenue - Color: Room Type
Top Performing Rooms¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Ranked list of individual rooms:
| Rank | Room | Type | Occ % | Avg Rate | Revenue | Nights Sold | LOS |
|---|---|---|---|---|---|---|---|
| 1 | 501 | Villa | 95% | 12.5M | 3.56M | 28 | 4.2 |
| 2 | 301 | Suite | 92% | 5.2M | 1.44M | 27 | 3.1 |
| 3 | 401 | Deluxe | 100% | 2.6M | 2.34M | 30 | 2.5 |
| 4 | 201 | Deluxe | 98% | 2.55M | 2.25M | 29 | 2.4 |
| 5 | 101 | Standard | 100% | 1.35M | 1.22M | 30 | 2.0 |
Underperforming Rooms¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Rooms needing attention:
| Room | Type | Occ % | Issue | Action Recommended |
|---|---|---|---|---|
| 105 | Standard | 45% | Low demand | Review pricing/promotion |
| 310 | Suite | 38% | Location (noisy) | Soundproofing upgrade |
| 205 | Deluxe | 52% | Maintenance issues | Immediate repair |
| 115 | Standard | 48% | Poor reviews | Guest feedback analysis |
Common Issues: - Location issues (noisy, far from elevator) - Maintenance problems - Poor reviews/ratings - Overpriced vs market - Lack of amenities
Booking Patterns¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Lead Time Analysis¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Lead Time Distribution:
Bar chart showing: - Same Day: 5% - 1-3 Days: 15% - 4-7 Days: 25% - 8-14 Days: 20% - 15-30 Days: 18% - 31-60 Days: 10% - 60+ Days: 7%
Average Lead Time: 12.5 days
By Channel: - Direct: 8 days (short lead time) - OTAs: 15 days (longer lead time) - Corporate: 5 days (last-minute)
Length of Stay (LOS) Analysis¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
LOS Distribution:
1 Night: ████████████████ 35%
2 Nights: ████████████████████████ 42%
3 Nights: ████████████ 15%
4 Nights: ████ 5%
5+ Nights: ██ 3%
Average LOS: 2.3 nights
By Room Type: - Standard: 2.1 nights - Deluxe: 2.3 nights - Suite: 2.8 nights - Villa: 4.0 nights (longest stays)
By Guest Type: - Leisure: 2.8 nights - Business: 1.8 nights - Group: 1.5 nights
Booking Pace¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Line chart comparing bookings on the books (OTB): - This Year (Current pace) - Last Year (Same period) - 2 Years Ago - Budget/Forecast
Future Occupancy Forecast:
| Date Range | Rooms on Books | Forecast Occ % | vs Last Year | Rooms to Sell |
|---|---|---|---|---|
| Next 7 days | 520 | 74% | ↑ 5% | 180 |
| Next 30 days | 1,850 | 65% | ↑ 3% | 1,060 |
| Next 60 days | 3,200 | 58% | → 0% | 2,620 |
| Next 90 days | 4,100 | 52% | ↓ 2% | 4,600 |
Guest Analytics¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Guest Segmentation¶
By Guest Type:
Pie chart: - Leisure (FIT): 55% - Business: 30% - Group: 10% - Corporate: 5%
By Market Segment:
| Segment | Room Nights | Revenue | ADR | % of Total |
|---|---|---|---|---|
| Domestic Leisure | 1,200 | 144M | 1.2M | 32% |
| International Leisure | 800 | 200M | 2.5M | 44% |
| Domestic Business | 600 | 75M | 1.25M | 17% |
| International Business | 150 | 30M | 2.0M | 7% |
Repeat Guest Analysis¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Metrics: - New Guests: 65% - Repeat Guests: 35% - Repeat Guest Revenue Contribution: 42% (higher ADR)
Repeat Frequency: - 2 Visits: 60% - 3-5 Visits: 30% - 6-10 Visits: 7% - 10+ Visits (VIP): 3%
Loyalty Program Impact: - Loyalty Members: 25% of guests - Member Revenue Contribution: 38% - Member ADR: +15% higher than non-members
Guest Geography¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Map visualization hoặc table:
| Country/Region | Room Nights | % of Total | ADR | Revenue |
|---|---|---|---|---|
| Vietnam (Domestic) | 1,800 | 60% | 1.2M | 216M |
| Korea | 350 | 12% | 2.8M | 98M |
| Japan | 250 | 8% | 3.0M | 75M |
| China | 200 | 7% | 2.5M | 50M |
| USA | 150 | 5% | 3.5M | 52.5M |
| Others | 250 | 8% | 2.0M | 50M |
Operational Metrics¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Arrival & Departure Statistics¶
Daily Arrivals/Departures Chart:
Stacked bar chart: - Arrivals (Green bars) - Departures (Red bars) - Stayovers (Blue area)
Metrics Table:
| Metric | Count | % of Total | Notes |
|---|---|---|---|
| Total Arrivals | 245 | - | Peak: Friday |
| Early Check-ins | 35 | 14% | Before 2 PM |
| Late Arrivals | 28 | 11% | After 10 PM |
| No-Shows | 5 | 2% | Track & charge |
| Total Departures | 238 | - | Peak: Monday |
| Late Checkouts | 42 | 18% | After 12 PM |
| Early Departures | 8 | 3% | Lost revenue |
Room Status Distribution¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Current Status Snapshot:
Pie chart với colors: - Occupied: 81 rooms (81%) - Green - Vacant Clean: 12 rooms (12%) - Blue - Dirty: 4 rooms (4%) - Yellow - Out of Order: 2 rooms (2%) - Red - Maintenance: 1 room (1%) - Orange
Historical Trends:
Line chart showing status distribution over time.
Housekeeping Performance¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Metrics: - Average Cleaning Time per Room: 28 minutes - Rooms Cleaned per Day: 85 - Inspection Pass Rate: 95% - Re-clean Rate: 5%
Turnaround Time: - Same-Day Turnaround: 92% (Target: 90%) - Average Turnaround: 2.5 hours after checkout
Comparative Analysis¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Period-over-Period Comparison¶
Side-by-side comparison table:
| Metric | This Month | Last Month | Change | This Year | Last Year | Change |
|---|---|---|---|---|---|---|
| Occupancy % | 82.5% | 78.3% | ↑ 4.2% | 79.2% | 75.8% | ↑ 3.4% |
| ADR | 2.5M | 2.43M | ↑ 2.9% | 2.38M | 2.28M | ↑ 4.4% |
| RevPAR | 2.06M | 1.90M | ↑ 8.4% | 1.88M | 1.73M | ↑ 8.7% |
| Revenue | 450M | 410M | ↑ 9.8% | 1.2B | 1.05B | ↑ 14.3% |
| Rooms Sold | 2,475 | 2,350 | ↑ 5.3% | 7,200 | 6,800 | ↑ 5.9% |
Variance Analysis:
Waterfall chart showing: 1. Last Period Revenue: 410M 2. Volume Impact (Occupancy): +40M 3. Rate Impact (ADR): +12M 4. Mix Impact (Room Types): -12M 5. Current Period Revenue: 450M
Budget vs Actual¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Monthly Performance:
| Month | Budget Rev | Actual Rev | Variance | % Achieved | Status |
|---|---|---|---|---|---|
| Jan | 380M | 395M | +15M | 104% | ✅ Beat |
| Feb | 360M | 355M | -5M | 99% | ⚠️ Short |
| Mar | 420M | 445M | +25M | 106% | ✅ Beat |
| Apr | 400M | 410M | +10M | 103% | ✅ Beat |
| May | 450M | 450M | 0 | 100% | ✅ On Target |
| YTD | 2,010M | 2,055M | +45M | 102% | ✅ |
Budget Tracking Chart:
Line chart với 3 lines: - Budget (Target line) - Actual (Performance line) - Forecast (Projected line for future months)
Competitive Set Analysis¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Competitive Position (nếu có data từ STR hoặc market reports):
| Metric | Your Hotel | Comp Set Avg | Index | Position |
|---|---|---|---|---|
| Occupancy % | 82.5% | 78.0% | 105.8 | Above market |
| ADR | 2.5M | 2.6M | 96.2 | Below market |
| RevPAR | 2.06M | 2.03M | 101.5 | Above market |
Market Share: - Occupancy Share: 105.8% (gaining share) - ADR Share: 96.2% (pricing below market) - RevPAR Share: 101.5% (overall winning)
Strategy Implication: - Currently trading volume over rate - Opportunity to increase ADR closer to market - Maintain occupancy leadership
Forecasting & Trends¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Demand Forecast¶
30/60/90 Day Forecast:
Line chart with confidence intervals: - Historical Actual (solid line) - Forecast (dashed line) - Confidence Interval (shaded area) - Budget/Target (reference line)
Forecast Accuracy Tracking:
| Period | Forecast | Actual | Variance | Accuracy |
|---|---|---|---|---|
| Last Month | 78% | 82% | +4% | 95% |
| 2 Months Ago | 75% | 73% | -2% | 97% |
| 3 Months Ago | 80% | 82% | +2% | 98% |
| Avg Accuracy | - | - | ±2.7% | 96.7% |
Seasonal Trends¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Monthly Seasonality Pattern:
Line chart comparing multiple years: - Current Year - Last Year - 2 Years Ago - 5-Year Average
Peak/Low Seasons: - Peak Season: Dec-Feb, Jul-Aug (Occ > 90%) - Shoulder: Mar-Apr, Sep-Oct (Occ 75-85%) - Low Season: May-Jun, Nov (Occ 60-70%)
Event Impact Analysis:
| Event | Dates | Occ Impact | ADR Impact | RevPAR Impact |
|---|---|---|---|---|
| Tết Holiday | Jan 20-30 | +25% | +40% | +75% |
| Summer Peak | Jul 1-31 | +20% | +30% | +56% |
| Christmas | Dec 20-26 | +22% | +35% | +65% |
| City Marathon | Mar 15 | +18% | +25% | +48% |
Advanced Analytics¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Price Elasticity Analysis¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Scatter plot: - X-axis: Price (ADR) - Y-axis: Demand (Occupancy) - Trend line showing elasticity
Insights: - Optimal Price Point: 2.4M VND (maximizes RevPAR) - Price Sensitivity: -1.2 (elastic demand) - Recommended Action: Increase rates during high demand periods
Revenue Optimization¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Optimization Opportunities:
| Opportunity | Current | Potential | Impact | Priority |
|---|---|---|---|---|
| Increase weekend ADR | 2.3M | 2.6M | +15M/month | High |
| Reduce OTA dependency | 57% | 45% | -8M commission | High |
| Upsell to higher room types | 12% | 25% | +10M/month | Medium |
| Extend average LOS | 2.3 | 2.6 | +8M/month | Medium |
| Increase direct bookings | 35% | 45% | +12M/month | High |
Total Potential Impact: +57M VND/month (+12.7% revenue increase)
Cohort Analysis¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Guest Retention by Booking Month:
Heatmap table: - Rows: Booking cohort (e.g., Jan 2024 guests) - Columns: Months since first booking (0, 1, 2, 3, 6, 12) - Values: % of guests who returned
Example:
Cohort Month 0 Month 1 Month 3 Month 6 Month 12
Jan 2024 100% 8% 12% 18% 28%
Feb 2024 100% 7% 10% 15% -
Mar 2024 100% 9% 13% - -
Insights: - 28% of guests return within 12 months - Highest return rate: Months 6-12 - Focus on 6-month reactivation campaigns
Custom Reports¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Report Builder¶
Step 1: Select Report Type - Occupancy Report - Revenue Report - ADR/RevPAR Report - Room Performance Report - Guest Analytics Report - Custom (Build from scratch)
Step 2: Choose Metrics
Available Metrics:
☑ Occupancy %
☑ Available Rooms
☑ Occupied Rooms
☐ OOO Rooms
☑ ADR
☑ RevPAR
☑ Total Revenue
☑ Room Nights Sold
☐ Average LOS
☐ No-Shows
☐ Early Checkouts
Step 3: Set Dimensions
Step 4: Apply Filters - Date Range: Custom - Room Types: All / Specific - Channels: All / Specific - Status: All / Occupied / Available
Step 5: Configure Output - Format: Table / Chart / Dashboard - Export: PDF / Excel / CSV / Email - Schedule: One-time / Daily / Weekly / Monthly
Saved Reports¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
List of pre-configured reports:
| Report Name | Type | Frequency | Last Run | Actions |
|---|---|---|---|---|
| Daily Performance Summary | Dashboard | Daily | Today 8:00 AM | Run, Edit, Delete |
| Weekly Revenue Analysis | Revenue | Weekly | Mon 9:00 AM | Run, Edit, Delete |
| Monthly Occupancy Trends | Occupancy | Monthly | 1st @ 10:00 AM | Run, Edit, Delete |
| Room Type Performance | Performance | On-demand | Yesterday | Run, Edit, Delete |
Export & Sharing¶
📸 Chụp từ: Click "Export" button
Export Formats¶
PDF Report: - Professional formatting - Include charts & tables - Executive summary - Company branding/logo
Excel Workbook: - Multiple sheets (by metric/dimension) - Raw data + Pivot tables - Charts embedded - Formulas preserved
CSV Files: - Raw data export - Easy import to other systems - Delimiter options (comma, semicolon, tab)
PowerPoint: - Chart slides - Summary slides - Ready for presentations
Email Scheduling¶
📸 Chụp từ: Export → Schedule Email
Configure Email Report:
Recipients: - Primary: manager@hotel.com - CC: revenue@hotel.com, gm@hotel.com
Frequency:
Content: - Report Type: Monthly Performance Summary - Include: Charts, Tables, Commentary - Format: PDF Attachment
Subject Template:
Body Template:
Dear Team,
Please find attached the monthly room analytics report for {Month}.
Key Highlights:
- Occupancy: {Occupancy%}% (Target: {Target}%)
- RevPAR: {RevPAR} VND
- Total Revenue: {Revenue} VND
Best regards,
Analytics System
Dashboards & Widgets¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics
Customizable Dashboard¶
Drag-and-drop widgets:
- KPI Cards (4 main metrics)
- Occupancy Trend Chart (Line chart)
- Revenue Breakdown (Pie chart)
- Room Performance Table (Top 10 rooms)
- Booking Pace (Line chart comparison)
- Guest Segmentation (Pie/Bar chart)
- Calendar Heatmap (Occupancy calendar)
- Alerts & Notifications (Warning cards)
Layout Options: - Single Column - Two Columns - Three Columns - Grid (2x2, 3x3) - Custom
Widget Settings: - Refresh interval (Real-time, 5 min, 15 min, 1 hour) - Date range - Filters - Color scheme
Dashboard Templates¶
📸 Chụp từ: Dashboard → Templates
Pre-built Templates:
- Executive Dashboard
- High-level KPIs
- Revenue trends
- Budget vs Actual
-
Forecast
-
Revenue Manager Dashboard
- Occupancy & ADR
- Booking pace
- Competitive analysis
-
Price optimization
-
Operations Dashboard
- Room status
- Arrivals/Departures
- Housekeeping performance
-
Maintenance tracking
-
Front Desk Dashboard
- Today's arrivals/departures
- Room availability
- VIP guests
- Upsell opportunities
Mobile Analytics¶
📸 Chụp từ: https://sazi.gp.mana.vn/rooms/analytics (trên mobile device)
Mobile-Optimized Views¶
Features: - Responsive design - Touch-friendly charts - Swipe navigation - Quick KPI cards - Offline access to recent data
Mobile Dashboard: - Simplified layout - Key metrics only - Tap to drill-down - Export via email
Tips & Best Practices¶
💡 Tip 1: Monitor Daily - Check KPIs every morning - Review booking pace vs last year - Identify revenue opportunities early
💡 Tip 2: Use Comparative Analysis - Always compare to previous periods - Track trends, not just absolute numbers - Understand seasonality patterns
💡 Tip 3: Segment Your Data - Analyze by room type to find winners/losers - Segment by channel to optimize mix - Break down by guest type for targeted marketing
💡 Tip 4: Forecast Regularly - Update forecasts weekly - Track forecast accuracy - Adjust pricing strategy based on pace
💡 Tip 5: Focus on RevPAR - RevPAR combines occupancy & rate - More important than either metric alone - Drive RevPAR through balanced strategy
💡 Tip 6: Leverage Automation - Schedule regular reports - Set up alerts for key thresholds - Automate data collection from PMS/Channel Manager
FAQs¶
1. Làm thế nào để cải thiện RevPAR?¶
Câu trả lời:
RevPAR = ADR × Occupancy %, vì vậy bạn có 3 strategies:
Strategy 1: Tăng Occupancy (giữ nguyên ADR) - Lower rates during low-demand periods - Run promotions/packages - Increase marketing spend - Expand distribution channels - Target new market segments
Strategy 2: Tăng ADR (giữ nguyên Occupancy) - Increase rates during high-demand periods - Implement dynamic pricing - Upsell to higher room categories - Add value-added services - Reduce OTA dependency (lower commission)
Strategy 3: Balanced Approach (Recommended) - Segment pricing by demand level - High demand → Focus on ADR (increase rates) - Low demand → Focus on Occupancy (volume) - Shoulder periods → Balance both
Example:
Current: 75% Occ × 2.0M ADR = 1.5M RevPAR
Option A (Occupancy focus):
85% Occ × 1.9M ADR = 1.615M RevPAR (+7.7%)
Option B (ADR focus):
70% Occ × 2.3M ADR = 1.61M RevPAR (+7.3%)
Option C (Balanced):
80% Occ × 2.1M ADR = 1.68M RevPAR (+12%)
Action Items: 1. Analyze current performance: Occ% vs ADR vs market 2. Identify low-hanging fruit (underperforming periods) 3. Set dynamic pricing rules 4. Monitor weekly, adjust monthly
2. Tại sao có gap giữa Budget và Actual?¶
Câu trả lời:
Common Causes của Variance:
Positive Variance (Beating Budget): ✅ Unexpected demand surge (events, holidays) ✅ Successful marketing campaigns ✅ Competitor closure/renovation ✅ Pricing strategy improvements ✅ New distribution channels
Negative Variance (Missing Budget): ❌ Economic downturn ❌ New competition ❌ Seasonality not properly budgeted ❌ Operational issues (maintenance, service) ❌ External factors (weather, natural disasters, pandemics)
How to Analyze:
-
Decompose the Variance:
-
Identify Root Cause:
- Compare actuals to last year (is it growth or budget issue?)
- Check market trends (is entire market up/down?)
-
Review specific dates (which days drove variance?)
-
Take Action:
- If beating budget consistently: Revise forecast up, increase rates
- If missing budget: Increase marketing, adjust pricing, cost control
Example:
Budget: 400M VND (80% Occ × 2.5M ADR)
Actual: 380M VND (78% Occ × 2.44M ADR)
Variance: -20M VND (-5%)
Breakdown:
- Volume Impact: (78%-80%) × 2.5M = -5M (Lost 2% occupancy)
- Rate Impact: (2.44M-2.5M) × 78% = -4.7M (ADR down 60K)
- Mix Impact: -10.3M (Sold more Standard, less Suites)
Root Cause: Corporate segment underperformed (COVID impact)
Action: Shift focus to Leisure, reduce Suite inventory
3. Metrics nào quan trọng nhất cần track hàng ngày?¶
Câu trả lời:
Daily Must-Track Metrics (Top 5):
1. Occupancy % (Today & Tomorrow) - Current: How full are we now? - Tomorrow: What's arriving/departing? - Use for: Staffing, inventory decisions
2. ADR (Actual vs Budget) - Are we achieving target rates? - Use for: Pricing adjustments
3. Booking Pace (On-the-Books for next 30/60/90 days) - How are future bookings trending? - vs Last Year, vs Budget - Use for: Forecasting, marketing urgency
4. Channel Mix - % Direct vs OTA - Commission costs - Use for: Channel strategy optimization
5. Revenue (Actual vs Budget, MTD & Forecast) - Are we on track to hit monthly target? - Use for: Revenue recovery actions
Weekly Review: - RevPAR trends - Guest segmentation - Top/Bottom performing rooms - No-show & cancellation rates
Monthly Deep-Dive: - All metrics in detail - Variance analysis - Competitive positioning - Forecast updates
Dashboard Setup:
Morning Dashboard (8:00 AM):
┌─────────────────────┐
│ Today's Occupancy │ 85% (Target: 80%)
│ Tomorrow's Occ │ 78% (92 arr, 88 dep)
│ ADR Today │ 2.3M (Target: 2.5M) ⚠️
│ Revenue MTD │ 285M / 400M (71%)
│ Pace vs LY (+30d) │ +5% ✅
└─────────────────────┘
Action: ADR below target, check pricing strategy
4. Làm thế nào để identify revenue opportunities?¶
Câu trả lời:
Revenue Opportunity Framework:
1. Analyze Gaps:
Low-Hanging Fruit: - Days with low occupancy but high ADR potential (events, weekends) - Room types with low occupancy (potential for discounts/packages) - Channels with low contribution (grow Direct, reduce OTA) - Underperforming time periods (shoulder seasons)
Example Analysis:
Finding: Sunday nights have 60% occupancy (vs 85% weekdays)
Opportunity: Promote Sunday-Monday packages
Potential: +20% Sunday occupancy = +5M revenue/month
2. Segmentation Insights:
Analyze by: - Room Type: Which room types underperform? - Suite occupancy 65% → Promote upgrades, packages - Channel: Where's the opportunity? - Direct booking 30% → Target: 40% (+10M commission savings) - Guest Type: Who should we target? - Leisure 60%, Business 30% → Grow Corporate segment - Geography: Which markets to focus? - Domestic 70% → Expand to International (higher ADR)
3. Competitive Gaps:
Compare to market:
Your ADR: 2.3M
Market ADR: 2.5M
Gap: -200K VND (-8%)
Opportunity: Increase rates by 100K → +25M/month revenue
Risk: Lose 2-3% occupancy
Net Impact: +20M/month
4. Operational Improvements:
- Upselling: Train staff to upsell (12% → 20% conversion = +8M/month)
- Length of Stay: Extend from 2.3 → 2.5 nights (+8.7% room nights)
- Early Bird Discounts: Capture bookings earlier (improve cash flow)
- Last-Minute Deals: Fill empty rooms (better than 0 revenue)
5. New Revenue Streams:
- Packages: Romance, Spa, Golf, Family packages
- Events: Wedding blocks, Corporate meetings
- Long-term Stays: Monthly rates for extended stays
- Ancillary Services: Airport transfer, Tours, F&B upsell
Prioritization Matrix:
| Opportunity | Impact | Effort | Priority |
|---|---|---|---|
| Increase weekend ADR | High (+15M) | Low | 1 - Do Now |
| Reduce OTA dependency | High (+12M) | Medium | 2 - Plan |
| Upsell training | Medium (+8M) | Low | 3 - Do Now |
| New market segment | Medium (+10M) | High | 4 - Long-term |
| Renovate underperforming rooms | Low (+5M) | High | 5 - Consider |
5. Forecast accuracy của tôi chỉ đạt 85%, làm thế nào để cải thiện?¶
Câu trả lời:
85% accuracy là acceptable, nhưng có thể improve lên 90-95%:
Factors Affecting Forecast Accuracy:
1. Data Quality: ❌ Poor: Manually updated spreadsheets ✅ Good: Automated PMS/Channel Manager integration ✅ Better: Real-time booking pace tracking
2. Forecast Methodology:
Basic Method (70-80% accuracy): - Historical average (same day last year) - Simple trend projection
Improved Method (85-90% accuracy): - Booking pace (on-the-books + expected pickup) - Seasonal adjustments - Day-of-week patterns
Advanced Method (90-95%+ accuracy): - Machine learning models - Multiple scenarios (best/worst/likely) - External factors (events, weather, holidays) - Competitive intelligence
3. Forecast Horizon:
| Horizon | Expected Accuracy |
|---|---|
| 0-7 days | 95-98% (very high certainty) |
| 8-30 days | 90-95% (high certainty) |
| 31-60 days | 85-90% (medium certainty) |
| 61-90 days | 75-85% (lower certainty) |
| 90+ days | 60-75% (low certainty, directional) |
Improvement Steps:
Step 1: Track & Measure
Create weekly forecast accuracy report:
Date Forecast Actual Variance Accuracy
Jan 15 80% 82% +2% 97.6%
Jan 16 78% 75% -3% 96.2%
Jan 17 85% 88% +3% 96.5%
...
Avg ±2.5% 96.8%
Step 2: Identify Patterns in Errors - Consistently over/under forecasting? - Specific days (weekends, Mondays)? - Specific room types? - Pickup rate assumptions wrong?
Step 3: Refine Assumptions
Pickup Rate (bookings added after initial forecast):
Current assumption: +5% pickup over 30 days
Analysis: Actual pickup varies:
- High season: +3% (less pickup, mostly booked)
- Low season: +8% (more last-minute bookings)
- Events: +10% (surge bookings)
Action: Use dynamic pickup rates by season/demand
Step 4: Incorporate External Factors
✅ City events calendar (concerts, conferences) ✅ Competitor activity (closures, renovations) ✅ Weather forecasts (beach resort example) ✅ Economic indicators (business travel correlation) ✅ Flight schedules (international markets)
Step 5: Use Multiple Scenarios
Don't just forecast one number:
30-Day Forecast for Feb:
- Pessimistic (P10): 72% occupancy
- Likely (P50): 78% occupancy
- Optimistic (P90): 83% occupancy
Use likely for planning, pessimistic for staffing/cost control
Step 6: Update Frequently
- Daily: Review today + tomorrow
- Weekly: Update 30/60/90 day forecasts
- Monthly: Full forecast refresh
Automation Helps:
- Auto-pull booking pace data
- Auto-calculate pickup rates
- Auto-flag anomalies (unusual variances)
- Dashboards update in real-time
ROI của Better Forecasting:
Example:
Scenario: Better forecast allows optimized staffing
Current (85% accuracy):
- Over-staff 20% of days (waste 5M VND/month labor)
- Under-staff 15% of days (poor service, lost upsells)
Improved (95% accuracy):
- Reduce over/under staffing
- Savings: 4M labor + 3M recovered upsell = 7M/month
- Investment: 2 hours/week forecasting = minimal cost
ROI: 84M/year benefit
6. Dashboard có quá nhiều metrics, tôi nên focus vào đâu?¶
Câu trả lời:
The "Rule of 5-3-1":
5 Daily Metrics (Monitor every day): 1. Occupancy % (today + tomorrow) 2. ADR (actual vs target) 3. Booking Pace (OTB for next 30 days vs LY) 4. Revenue MTD (actual vs budget %) 5. Channel Mix % (Direct vs OTA)
3 Weekly Metrics (Deep-dive weekly): 1. RevPAR trend (7-day rolling average) 2. Room Type Performance (which types over/underperforming) 3. Forecast Accuracy (review last week's forecast vs actual)
1 Monthly Metric (Comprehensive review monthly): 1. Net Revenue (after commissions & costs)
Simplified Executive Dashboard:
┌─────────────────────────────────────────────┐
│ TODAY'S SNAPSHOT Jan 22, 2025 │
├─────────────────────────────────────────────┤
│ Occupancy 82% ✅ (Target: 75%) │
│ ADR 2.4M ⚠️ (Target: 2.5M) │
│ Revenue MTD 285M / 400M (71%) ✅ │
├─────────────────────────────────────────────┤
│ FORWARD BOOKING PACE (vs Last Year) │
│ Next 7 days: +5% ✅ │
│ Next 30 days: +3% ✅ │
│ Next 90 days: -2% ⚠️ (Action needed) │
├─────────────────────────────────────────────┤
│ TOP PRIORITY ACTIONS │
│ 1. Increase ADR by 100K (promo ending) │
│ 2. Boost bookings for Mar (pace -2%) │
└─────────────────────────────────────────────┘
Dashboard by Role:
GM/Owner (Strategic): - RevPAR vs Budget - Net Revenue (after costs) - Market Share (vs competitors) - Guest Satisfaction scores
Revenue Manager (Tactical): - Occupancy, ADR, RevPAR (detailed) - Booking pace by segment - Price positioning vs market - Forecast accuracy
Front Desk (Operational): - Today's arrivals/departures - Room availability - VIP arrivals - Upsell opportunities
Housekeeping (Operational): - Dirty rooms count - Expected checkouts today - Turnaround times - Maintenance requests
Customization Tips:
- Start Simple: 5 metrics dashboard
- Add Gradually: As you get comfortable, add 1-2 more
- Remove Noise: If a metric never drives action, remove it
- Color-Code: Green (good), Yellow (watch), Red (action needed)
- Include Context: Always show vs Target, vs Last Year, vs Trend
The Key Question:
For every metric on your dashboard, ask:
"If this number changes, will I take a different action?"
If the answer is NO → Remove it (it's just noise) If the answer is YES → Keep it, make it prominent
Liên Kết Liên Quan¶
- Danh Sách Phòng - Quản lý danh sách phòng
- Timeline Phòng - Xem timeline đặt phòng
- Trạng Thái Phòng - Quản lý trạng thái phòng
- Loại Phòng - Cấu hình loại phòng
- Xung Đột Đặt Phòng - Xử lý xung đột
- Quản Lý Đặt Phòng - Hệ thống đặt phòng
Cập nhật lần cuối: 2025-01-22 Phiên bản: 1.0