Skip to content

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.

Read the case study

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.

Book a meeting

Reservations, rooms and revenue from Mews in one model for each hotel

Discuss your hotel figures

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

  1. Definitions for each property

    Which rooms count as available, what counts as room revenue and how out-of-service rooms are accounted for.

  2. 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.

  3. 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?

Talk it through with us

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.

Book an introductory meeting

Our first conversation starts with which hotels are involved and which figures your revenue manager is currently missing

Stef Stoelwinder

Stef Stoelwinder

Business Development

Stef is your point of contact. In our first conversation, we’ll discuss your properties, your Mews package and the reports you’re currently missing.

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.

Enter a valid email address.

Let us know how we can help you.

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.