Mews Power BI dashboard
We bring reservations, channels and departmental revenue from Mews into Power BI for each property. For See Tickets, we brought ticketing and behavioural data together on Azure.
We brought See Tickets’ ticketing and behavioural data together on a scalable Azure platform to deliver personalised recommendations to fans
See Tickets wanted to keep fans engaged for longer and offer them relevant, personalised recommendations at the right time. We developed recommendation models that learn continuously, tested them in practice and refined them based on real-world results.
How can we compare occupancy, room rates and revenue by department across all our hotels?
Mews Analytics already shows occupancy, ADR and RevPAR in Power BI dashboards, but you can only export aggregated data. To compare it with point-of-sale, accounting or budget data, or use your own definitions, you need to bring the data into your own model via the Connector API.
Reservations, rooms and revenue from Mews in one model for each hotel
Occupancy, ADR and RevPAR
Occupied and available rooms, average room rate and revenue per available room by day, using the same net definitions as Mews so the figures match.
Reservations and cancellations by channel
The source, channel, business segment and travel agency for each reservation, plus which reservations were cancelled and why.
Revenue by department
Accommodation, breakfast, bar, restaurant and spa revenue by accounting category and outlet, based on the revenue items Mews records for each service.
Returning guests
Repeat visits by segment and channel, as we did for See Tickets when we brought ticket and behavioural data together to keep fans engaged for longer.
First we define what counts as an available room and as room revenue; the charts come later
-
Definitions for each property
Which rooms count as available, what counts as room revenue and how out-of-service rooms are accounted for.
-
Access and the first report
Access to the Connector API, tested in the demo environment, followed by one report checked against the figures in Mews.
-
Hotels and historical data added
More properties in the same model, figures fixed for closed periods, and a designated owner for data refreshes and access rights.
Is Mews Analytics enough for our hotels, or do we need our own Power BI model?
A good fit if
You manage multiple hotels or departments, want to see Mews data alongside point-of-sale, accounting, budget or marketing data, or need the underlying reservations rather than just summary figures.
Not a good fit if
You manage a single property and the dashboards in Mews Analytics or the multi-property dashboard answer your questions. In that case, the benefits of your own model do not outweigh the work of managing it.
What determines the scope
How many properties are involved, whether you have portfolio-level access, which other sources you want to include, how far back you want to look and who will manage the model.
Can we build our own integration with Mews?
Mews calls this a private integration. The property needs the Connectivity Add-on or the Enterprise package, and Mews reviews the integration in the demo environment before issuing production tokens.
Mews Analytics, per-report exports or your own model built on the Connector API?
Mews Analytics
Choose this if the Mews dashboards meet your needs. Mews Analytics runs on Power BI within Mews Operations; you can export aggregated data, but not the underlying data.
Per-report exports
Choose this if you work with one property and occasionally compare a report in Excel with your budget. Each new period still requires manual work.
Your own model built on the Connector API
Choose this if you need to bring together multiple properties or data sources. Our advice: load closed periods as fixed snapshots and refresh the current period separately.
Bringing visitor data from different sources together on one platform is familiar territory for us
Data Science Lab has been building data platforms, models and dashboards since 2016 as a Microsoft Partner and Databricks Partner. For See Tickets, we brought ticketing and behavioural data together on a scalable Azure platform.

Our first conversation starts with which hotels are involved and which figures your revenue manager is currently missing
Stef Stoelwinder
Business DevelopmentStef is your point of contact. In our first conversation, we’ll discuss your properties, your Mews package and the reports you’re currently missing.
E-mail info@datasciencelab.nl
Phone +31 (0)20 3636 724
How many properties do you manage in Mews, and what would you like to compare their data with?
Tell us which properties and Mews package you use, and which POS system or accounting software you use alongside it. We’ll reply by email or arrange an initial call.
Message sent
Thanks for your message. We’ll be in touch as soon as possible.
Frequently asked questions
Through the Mews Connector API, which Mews describes as the general API for accessing data and services in Mews Operations. Each request uses a ClientToken and an AccessToken for each property. A data-loading step retrieves the data, which we then use to build the Mews Power BI model.
For large volumes, Mews also offers a bulk export, currently in beta. To work out which questions a dashboard should answer first, read about Power BI dashboards.
According to the Mews help centre, Mews Analytics is a BI tool within Mews Operations, built on Microsoft Power BI. It includes dashboards such as Manager analytics for revenue, occupancy, ADR and RevPAR. You need an Enterprise subscription or the add-on to use it.
You can export aggregated data from it, but not the underlying data. A model of your own is worthwhile if you want to combine Mews with other sources or need your own definitions.
Mews calculates occupancy by dividing the number of occupied rooms by the total number of rooms, ADR by dividing room revenue by the number of occupied rooms, and RevPAR by dividing room revenue by the total number of rooms. Mews uses net amounts, excluding VAT.
Our model uses the same definitions, so Mews and your own report show the same figures. We record rooms that are temporarily out of service separately.
Every booking in Mews has a source, such as a channel manager or Mews Operations itself. It can also have a business segment, a travel agency and a booking number from the channel, for example an online travel agency. A cancelled booking has a cancellation time and a reason.
This lets you compare bookings, cancellations and room revenue by channel, and see which channels have relatively high cancellation rates.
Mews records revenue against a service, such as accommodation, breakfast or parking, and each service has an accounting category. Purchases paid for directly at a bar, restaurant or spa are recorded against an outlet. Revenue items are linked to the guest profile; only accommodation products can be linked to a booking.
If you want to track revenue, margin and cash flow for finance, read about the financial dashboard in Power BI.
Mews Multi-Property is an optional feature for managing a portfolio of properties from one place. A Portfolio Access Token provides access to all properties in that portfolio. Not every API request supports it, and Mews says the feature is not available to all clients.
Without a portfolio, we retrieve the data for each property using a separate token and combine it in the model.
Mews uses an Editable History Window: a period during which bills and bookings can still be changed after they have been closed, with separate settings for accounting and operations. After that, they are final.
We load closed periods as fixed snapshots and refresh the current period separately, so last month’s figures do not change unnoticed. We configure access rights for each hotel and the refresh schedule as described on the Power BI consultant page.
If you have one property and Mews Analytics answers your questions. Or if room types, services and segments are configured differently at each hotel: in that case, data quality is the first step, because a report is only as good as the setup behind it.
If you mainly want to track revenue by customer, company or salesperson, read about the sales dashboard. If we find that an export is sufficient, we will recommend that.
Which finance and sales metrics belong alongside occupancy and room rates?
- Power BI dashboardsWhy every dashboard starts with the decision someone needs to make using it.
- Financial dashboard in Power BIRevenue, margin, cash flow and budget versus actuals, in one model for finance and management.
- Sales dashboard in Power BIRevenue and orders by customer, product and channel, with targets versus actuals.