A fully parameterised Power BI reporting suite built on Oracle Opera PMS export data — designed to give hotel leadership instant visibility across revenue, reservations, and sales performance.
All data flows from scheduled Opera PMS exports — no live database connection required. Files are dropped into watched folders and Power BI picks them up automatically on refresh, with deduplication logic ensuring the most recent version of each record always wins.
Every page is designed around a specific decision-maker and the questions they need answered at the start of their day — not a generic KPI dump.
Single-screen operational overview with all critical KPIs for the current business date. Revenue by category breakdown and MTD trend chart. Designed to be the first screen a GM opens every morning.
8-day forward view of packaged vs room-only reservations. Shows F&B cover forecast, revenue uplift per package type, and occupancy contribution by package code. Allows F&B to plan staffing and procurement up to 8 days out.
Full account production overview for a selected period. Includes a ranked account table with conditional formatting on cancellation rates and revenue contribution, revenue concentration risk indicator, segment donut chart with custom tooltip, and owner performance chart. Drill-through enabled from other pages.
Morning dashboard for the sales and reservations team. Shows overnight booking activity, current rooms-on-books position, a 30-day booking pace chart with trend line, and an arrivals table for the next 7 days with VIP highlighting. All TODAY() based — refreshes automatically each day.
Built to professional BI standards — the same patterns used in enterprise hotel chains, packaged into a template that can be deployed at an independent property in hours rather than months.
The model is fully parameterised: hotel name, room count, currency symbol, date format and fiscal year start month are all controlled from a single parameters table. Deploying for a new client requires updating folder paths and parameters only — no query or DAX changes needed.
Every hotel is different. Your Opera export column names, your segment structure, your fiscal year, your brand colours — this template is designed to absorb all of that. I can take this foundation and deliver a production-ready reporting suite tailored to your property in a fraction of the time a build-from-scratch engagement would take.