Why It Matters: The hotel portfolio is complex, comprising different types of hotels managed through various systems. This workflow consolidates all financial and operational data to provide a single, comprehensive view of performance across the entire portfolio.
How It Works: We collect data from several sources: HotelBIS for US and UK full-service hotels, and the Aimbridge and Monarch systems for US select-service hotels. We also enrich this with market performance data from industry-standard STR reports. All this information is centralized in Cherre, where it is mapped to a standard property identifier. The system aggregates multiple records for a single property and carefully retains all historical versions to enable trend analysis.
Key Data & Transformations:
Data Sources: HotelBIS, Aimbridge, Monarch, STR Reports.
Key Data: Hotel Financials (Actuals, Budgets), Market Performance Data.
Detailed Transformations:
Record Aggregation: For certain sources, multiple records (e.g., different owner unit IDs) are aggregated into a single record for a property.
Versioning: Logic is applied to derive a Book + Forecast version. The system is configured to retain either the latest version or all historical versions depending on the downstream use case.
Property Mapping: Data is processed through a merged mapping that combines HotelBIS Property Mapping and Aimbridge Property Mapping into a single property_mapping_hotel logic.
Filtering & Subsetting: For egresses to other systems, data is filtered for the latest week or month, and specific columns are selected as required by the destination platform.
End Result: The unified dataset is used to create two primary outputs. The first is a comprehensive set of property cash flows sent to the HotelBIS platform for detailed operational analysis. The second is a specific feed for Anaplan that includes the latest STR data and monthly financials for high-level planning.