A multi-brand travel group was operating with fragmented reporting across 6 business units — each maintaining its own spreadsheet-based reporting and running on different systems. Executive leadership had no consolidated view of performance. We built a unified data platform and Power BI reporting layer that gave every stakeholder the insight they needed, in a single, trusted environment.
The Challenge
Six business units. Six different booking systems. Six separate finance tools. The Group CFO was receiving contradictory numbers from different teams and had no way to reconcile them. Month-end board packs took two weeks to compile and were out of date by the time they were distributed. Revenue management decisions were being made without reliable demand data.
Our Solution
We deployed an Azure-based data platform with Azure Data Factory orchestrating ingestion from all six source systems into a centralised Snowflake data warehouse. dbt handles transformation and enforces a shared data model across all brands. Power BI Premium is connected directly to Snowflake, with DirectQuery for operational dashboards and import mode for complex analytical models. A single semantic model ensures every stakeholder sees consistent numbers.
Unified Data Model
The hardest part of a multi-brand consolidation is reconciling conflicting definitions. What counts as a 'booking'? When is revenue 'recognised'? We ran a data governance workstream in parallel with the technical build — documenting agreed definitions, applying them in dbt, and socialising them with finance and commercial teams before go-live.
Self-service Analytics
Beyond the executive dashboards, we built a self-service layer that allows commercial analysts to slice and dice performance data by route, channel, brand, and time period — without requiring data team support. Training and documentation ensured adoption was high from day one.
Revenue Intelligence
A dedicated revenue management module integrates booking pace data, competitor pricing, and historical demand patterns — surfacing yield opportunities and pricing anomalies that the commercial team can act on daily.
Technology Stack
Want results like these for your business?
Let's discuss your data and AI challenges and design the right solution for your business.