Hotel Performance Intelligence Power BI Report
Surya Sundar Kumar Surla
About the Project
This Power BI report was built as part of a technical assessment for the Business Intelligence Analyst role at Minor Hotels, one of the world's largest hospitality groups operating across 56 countries.
The brief required building a multi-page interactive dashboard from raw hotel booking data, a Python script to fetch exchange rates, and full supporting documentation. The dataset covered 35 hotels across three Gulf markets: UAE (17 hotels), Oman (10 hotels), and Qatar (8 hotels), with 65,146 booking records spanning January 2025 to December 2026.
What I Built
Landing Page
A full-screen HTML landing page with a video background, sound toggle, animated entrance, and an Enter Report button. Built entirely as a DAX string measure using the HTML Content visual with no custom visual or external file involved.
Page 1: Performance Overview
Portfolio-wide KPI cards showing Total Revenue, Room Revenue, Bookings, Cancellation Rate, and Room Nights, each with year-on-year and month-on-month comparison labels and conditional colour formatting. A field parameter slicer lets the viewer switch all visuals on the page between Total Revenue, Total Room Nights, and Total Bookings with a single click.
Page 2: Market Intelligence
Booking channel breakdown covering OTA, Online Direct, and Property channels, alongside cancellation rate by channel, Top 15 source markets, revenue by source region (GCC, Europe, and USA), and a global guest map. The key finding here is that OTA bookings cancel at 39.2% compared to just 12.1% for Property bookings.
Page 3: Revenue Management
ADR, RevPAR, Occupancy Rate, Average Length of Stay, and No Show Rate with year-on-year comparisons and a cancellation rate trend line. A sharp spike to 67.83% in March 2026 is one of the most critical findings in the entire report.
Page 4: Hotel Portfolio
A full 35-hotel scorecard matrix with revenue rank, revenue share, cancellation rate, and booking volume. Conditional formatting applies gold, silver, and bronze colours to the top 3 hotels by revenue, and a green, yellow, red traffic light system for cancellation rate bands.
Key Features
Currency Toggle
All revenue figures can be switched between local hotel currencies (AED for UAE, OMR for Oman, QAR for Qatar) and US Dollars in real time. The conversion uses the historical exchange rate on each booking's departure date, fetched from the Frankfurter API. When a country is selected and Local mode is active, the active filters strip also shows the specific currency code, for example Local · AED.
Dynamic Visual Titles
Every visual title updates automatically based on the selected metric and the active currency. There is no static text anywhere in the report. Titles such as Total Room Nights by Market (USD) are generated entirely by DAX measures.
Active Filters Strip
An HTML Content visual at the top of every page displays the currently applied slicers as colour-coded pill badges covering Year, Month, Country, Cluster, Channel, and Currency. It uses DISTINCTCOUNT comparison rather than ISFILTERED to correctly detect dropdown slicers that are set to All.
Custom Tooltip Pages
Seven custom tooltip pages appear on hover across key visuals, showing hotel profile cards, source market details, channel performance breakdowns, and a cancellation rate indicator that compares the hovered month against the portfolio average.