Hotel Analytics Intelligence

🔑 API Configuration — Masukkan token Anda

🤖 Google Gemini API Key (AI Studio) 👁

●Not tested

🧠 OpenAI API Key — Optional 👁

●Optional

🤖 Select AI Engine

🤖 Gemini Model

🔐 API keys otomatis tersimpan stored in this browser only (localStorage, encoded). Not sent to any server. Auto-loaded when you reopen the file in the same browser.

📁 Upload Laporan PMS (.xlsx)

📊

Upload Excel Files from PMS

Select files from one or multiple month folders. Supports 1–2 years of data. File & folder path auto-detected.

by Arrangement by Guest Type by Nationality by Source of Booking by Room Category

📋 MTD Columns Read

by Arrangement.xlsx

Package / Room Type

by Guest Type.xlsx

Travel Agent / OTA

by Nationality.xlsx

Guest nationality

by Source of Booking.xlsx

OTA / Direct / Walk-in

by Room Category.xlsx

Room type per segment

MTD: Arrangement, Guest Type, Nationality, Booking, Room Category
Arrival Detail: Lead Time = Create→Arrival · LOS = Arrival→Departure · Rate > 0 only
Auto-detect month from filename · Supports 1–24 months

📡 Live

—

📋 By Arrangement — Package & Room Type

Room nights & revenue per tipe/paket (MTD)

Arrangement

🏷️ Room Category Analysis

Performance per room type — Room Nights, Revenue & ADR (MTD)

Room Category

Room Nights by Category

All available months

Segment Mix

Distribution by segment

ADR by Category

Comparison across types

Detail Segment

Segment	Rooms	Pax	Revenue	ADR	Share	Volume

📈 Trend Room Nights & Revenue

—

Multi-Period

🔗 Source of Booking

Active month channel mix

🌍 Top Nationalitas

Room nights by country (top 12)

👥 Travel Agent & OTA

Room nights per customer (top 10)

💰 ADR per Nationalitas

Average Daily Rate IDR (min 5 rooms)

ADR Trend

—

YoY

🔮 Dynamic Forecast

6-Month Forward Projection

—

AI Forecast

🤖 AI Analysis — Gemini + Data PMS Anda

✨ AI Strategic Analysis

gemini-1.5-flash

Click 🔄 Generate AI to start a deep strategic analysis of your data.

📈 Trend Market & Forecast Intelligence

Market trend analysis, seasonality, and demand forecast based on your historical data + Bali market knowledge.

🎯 Strategi Promosi & Revenue Optimization

Specific promo recommendations per channel, nationality, and period — with ROI estimates.

⚡ 90-Day Action Plan

Concrete 90-day action plan: week by week, responsible parties, and measurable KPI targets.

📰 Briefing berita pariwisata Bali terkini — di-generate oleh AI berdasarkan pengetahuan market terkini

Click Generate AI for the latest Bali tourism news briefing.

💡 Data Intelligence

🗺️ Detail Nationalitas

Rooms, Pax, Revenue, ADR by country

📱 Source of Booking

Revenue & ADR per channel

📊

Upload Data PMS Anda

Upload .xlsx files from PMS, or click Demo for a demo.
After processing data, click 🤖 AI Analysis for deep insights.

📆 Upload Weekly Report — Excel (.xlsx)

📆

Upload Weekly Files

Same format as monthly report (by Arrangement, by Guest Type, by Nationality, by Source of Booking).
Filename must contain week information: e.g. "Week14_Apr2026_by Nationality.xlsx"

by Arrangement by Guest Type by Nationality by Source of Booking

📋 Weekly Filename Format

System detects week from filename:
Week14 atau W14 = Week 14
Year from: 2026 in filename

Contoh:
Week14_Apr2026_by Nationality.xlsx
W14-2026_by Arrangement.xlsx

💡 Columns read: MTD (Week-to-Date) — same columns as the monthly report.

📆

No Weekly Data Yet

Upload weekly .xlsx files from PMS, or click Demo Weekan

⚙️ Admin Dashboard

—

Total Users

—

Active Sessions

—

Monthly Records

—

Weekly Records

👥 User Management

Manage user accounts

#	Username	Name	Hotel	Role	Status	Last Login	Aksi
Loading...

📋 Audit Log

Recent activity

Waktu	User	Aksi	Detail	IP
Loading...