Data Hub

Turn fragmented property data into unified intelligence.
One dashboard. Every hotel. Real-time insights.
PMS
Extract
Transform
Normalize
Analytics
Export
The solution

Unified Data. Deeper Insights. Smarter Decisions.

Multi-Property Aggregation

Stop logging into each PMS separately. Hex aggregates data from all your properties into a single, normalized view. Compare performance across hotels, spot trends chain-wide, and make portfolio-level decisions.

Near Real-Time Intelligence

Every booking flows from your PMS to Hex daily. No waiting for month-end reports. No manual exports. See occupancy, ADR, revenue, and channel mix as it happens — not weeks later.

Your Data, Your Rules

Define custom BI rules per property — channel classification, agency tiering, rate code grouping. Hex applies them automatically across your entire portfolio. One configuration. Consistent reporting.

The engine

How Hex Works

Four stages. One seamless pipeline. From raw PMS data to actionable intelligence.

Hotel PMS
SFTP / Email / API
Hex Extractor
Data Pipeline
Daily Sync • Near Real-Time
01
Data Extraction

Every day, Hex extracts reservation and financial data directly from your Property Management System. No manual exports. No copy-paste. No delay.

  • SFTP: Secure file transfer for scheduled reports
  • Email: Automated parsing of booking confirmations
  • API: Direct system-to-system connections
  • Formats: XML, XLSX, CSV — validated and cleaned
02
Transform & Normalize

Raw PMS data is messy. Different properties use different codes, formats, and conventions. Hex cleans, transforms, and normalizes everything into a unified schema.

  • Field Mapping: Standardize rate codes, room types, agency IDs
  • Data Cleaning: Remove duplicates, fix inconsistencies
  • Currency Normalization: Convert with daily FX rates
  • BI Rules: Apply per-property classification automatically
Rate: BAR Best Available Rate
Room: DLX Deluxe
$1,247 USD $1,247 @ 1.085
Normalized • 12 properties • 1 schema
Occupancy Trend
Channel Mix
  • Direct 45%
  • OTA 30%
  • Agency 25%
Alert
ADR dropped 12% at Property X vs. last week
Updated
Today, 6:00 AM
03
Analytics Engine

Once data is normalized, Hex runs it through the analytics engine — generating insights, trends, and alerts across your portfolio.

  • Occupancy & ADR tracking: Daily, weekly, monthly with YoY
  • Channel mix analysis: Direct, OTA, agency, corporate
  • Trend detection: AI-powered anomaly detection
  • Custom alerts: Get notified when metrics shift
04
Export & Integrate

Insights are only valuable if you can act on them. Hex makes it easy to export, share, and integrate your data with the tools you already use.

  • Scheduled Reports: Daily, weekly, or monthly to your inbox
  • Custom Dashboards: Role-specific views for GM, Revenue, Finance
  • Data Exports: CSV, XLSX, JSON for deeper analysis
  • API Access: Pull data into your own BI stack
Email Report
Daily • 8:00 AM • 5 recipients
Dashboard
6 widgets • Last 30 days
Data Export
CSV • 12 properties • May 2026
API Access
GET /api/v1/analytics
Platform capabilities

Everything You Need to Turn Data into Decisions

Custom Dashboards

Build role-specific dashboards for GMs, Revenue Managers, and Finance teams. Drag, drop, and configure widgets to show exactly what each team needs.

Multi-Property Views

See all your properties in one place. Compare performance side-by-side, roll up chain-wide totals, or drill down into individual hotel metrics.

Historical Trends & Forecasting

Access years of normalized booking data. Spot seasonal patterns, measure campaign impact, and build data-driven forecasts.

AI-Powered Alerts

Machine learning models detect anomalies and trends automatically. Get alerted when occupancy drops unexpectedly or channel mix shifts.

The Journey of a Booking

Hotel PMS
Booking confirmed
Extracted
Within 24hs
Transformed
Cleaned & normalized
Analyzed
Metrics calculated
Visualized
Dashboards updated
Exported
Decisions made
Property: The Obsidian Veranda • Chain: White Sands Resorts • Reservations: 1,247 • ADR: $892 • Occupancy: 78% • Last updated: Today, 6:00 AM

Multi-Property View

One portfolio. One dashboard. One truth.

The Obsidian Veranda
  • Occupancy 82%
  • ADR $1,247
The Azure Cove
  • Occupancy 76%
  • ADR $892
The Crimson Peak
  • Occupancy 91%
  • ADR $1,534
Hex Dashboard
3
Properties
2,847
Reservations
$1,124
Avg ADR
83%
Occupancy

Compare, aggregate, and drill down across your entire portfolio.

PMS Integration

Built for Opera. Ready for everything else.

Opera On-Prem
Opera Cloud
...and more
  • Channels: SFTP, Email, API
  • Formats: XML, XLSX, CSV
  • Frequency: Daily (configurable)
  • Security: End-to-end encryption, GDPR-compliant

Ready to unify your hotel data?

See how Hex transforms fragmented property data into a single source of truth.

"We were logging into five different systems to understand our portfolio. Now we open one dashboard and see everything."
— Revenue Director, Multi-Property Hotel Group