Six hotels, one dashboard: RevPAR up 9% after data unification.

The challenge

Each of the chain's six properties ran its own property-management system exports, its own POS reports, and its own Excel formats. Head office assembled a month-end picture by hand — it took the finance team most of a week, and by then the month was over.

Nobody could answer basic questions on demand: which property's occupancy was slipping this week, how OTA commissions compared across booking channels, or whether last weekend's pricing decision actually worked.

The solution

We built a central data warehouse pulling nightly from every property's PMS, the POS systems, booking channels, and expense sheets — normalized into one model where occupancy, ADR, and RevPAR are calculated one way for everyone.

Leadership got a live chain-wide dashboard with per-property drilldowns; general managers got a daily 8 a.m. flash report generated and emailed automatically. A simple demand-forecast layer now flags soft weeks 30 days out, giving revenue managers time to adjust pricing and promotions.

• Central warehouse fed nightly by all 6 PMS, POS, and channel sources
• One metric model — occupancy, ADR, RevPAR defined once
• Automated daily flash report to every GM at 8 a.m.
• 30-day demand forecast flagging soft weeks in advance