skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Getting started
      • Overview
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Microsoft Power BI Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power BI
    • Desktop
    • Service
    • Report Server
    • Power Query
    • Mobile Apps
    • Developer
    • DAX Commands and Tips
    • Custom Visuals Development Discussion
    • Health and Life Sciences
    • Power BI Spanish Community
    • Translated Spanish Desktop
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Training and Consulting
    • Instructor Led Training
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    • Ideas
    • Custom Visuals Ideas
    • Issues
    • Issues
    • Events
    • Upcoming Events
    • Community Engagement
    • T-Shirt Design Challenge 2023
    • Community Blog
    • Power BI Community Blog
    • Custom Visuals Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Hotel performance analysis

    Hotel performance analysis

    08-19-2020 09:10 AM - last edited 05-10-2021 10:58 AM

    Anonymous
    Not applicable
    2116 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Anonymous
    Not applicable
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Hotel performance analysis

    ‎08-19-2020 09:10 AM

    Description:

    • Contains Zebra BI visuals, which first and only IBCS®-certified solution for Microsoft Power BI
    • Contains most of the hotel metrics in a visual form. You can also configure metrics and visualizations
    • Intuitive interface
    • Easy filtering of data in the desired section (by month, year-to-date, by Departments)
    • The report can be sent to the end user as a link. The report opens directly in the Internet browser and does not require Excel or PowerPoint! This way, the General Manager can open the live report on the tablet
    • Great analytical capabilities:
      • KPI - the main hotel metrics by division, by month, and by Year-to-Date. In addition, KPIs may be reflected on users ' mobile phones. So you are always up to date with Occupancy, ADR or Revenue
      • Benchmarking - determining a hotel's place in a competitive set based on three indicators: Market Penetration Index, Average Rate Index, Revenue Generation Index
      • Standard USALI Profit and Loss statement by Actual / Budget / Past year, absolute and relative deviations
      • Range Analysis - if, in fact, the room categories were not sold as budgeted, you can analyze deviations in the assortment and number of rooms sold. This will give you an understanding of the reasons for the deviation of the actual revenue from the sale of rooms from the planned one
      • Calculation of the reasons for deviations of the actual gross operating profit from the budgeted one by divisions - Room Department, FB Department, OOD Department, Hotel. This makes it possible to digitize the results of the main divisions of the hotel and, consequently, the effectiveness of the managers of these divisions. The same calculation, but for the hotel as a whole, gives an understanding of the effectiveness of the General Manager of the hotel
      • Breakeven Analysis by division, by physical and monetary indicators gives a clear understanding of which months the hotel operates with a profit, and which with a loss, and how much you need, for example, to sell room-nights to go to profit
      • What If Analysis gives an immediate answer to the question, if we increase the Occupancy, for example, by 20% and decrease the ADR by 10%, what will be the Revenue, Gross Operating Profit and EBITDA? What If analysis can be a great help in forecasting the main indicators of the hotel for the next year

     

    eyJrIjoiOGE0YTJkNzktMTQ1Ni00ODc1LWIyNzgtMDg1ZTc3ODBhYTEyIiwidCI6IjdiMzc5OTYwLTBjMTUtNDk0Yi05NjhiLTQzZWMwMDdiOTQwMCIsImMiOjl9

    Labels:
    • Labels:
    • Business
    Message 1 of 2
    2,116 Views
    1
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    AnaStone_10
    AnaStone_10
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎08-05-2021 07:12 AM

    Very good Dashboard! Can you please share the example .pbix file? 

    Thank you!

    Message 2 of 2
    1,255 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices