Hotel Revenue Management Data Analysis

A great opportunity to learn a valuable skill of being able to produce and calculate Revenue Management

Reports within Power BI.

  • Intro

Ends In:


Hello All,


“Hotel Revenue Management”

We are excited to introduce Challenge 22 now!

Challenge 21 “EDNA YouTube Channel Data Analysis” was succeeded by 62 entries, 240+ analysis pages, 550+ DAX measures, and 350+ Navigation buttons, bookmarks, and Tooltips. Thanks for everyone’s engagement and dedication.

EDNA data challenge LinkedIn Group:

Join LinkedIn Group Here


I just want to take a moment to cover of some admin around the challenge as we really want to see more of you getting involved.

To learn more about the challenge please see the link 

Learn More About Power BI Challenges

There is no need for me to mention the benefits of participating and the impact it can have on your development. We at Enterprise DNA genuinely believe that getting hands on and practicing with real scenarios is the fastest way to proficiency.

So, I again encourage you all to try and get involved with the challenge, any issues please let us know, we are more than happy to help.

Be sure to check out the previous challenge entries here.

While the learning and experience of participating in the challenge is very rewarding itself we also have some great loot on offer for category winners. Please see below the categories.

  • Overall, Winner all entrants are eligible.
  • First Time Participant winner open to any Enterprise DNA member who is taking part in the challenge for the first time.
  • Winning Non-member open to entrants not currently eDNA members.
  • Out of the Box Thinker for those digging deep into their analysis.
  • Creative Head for those bringing a bit of extravagance into their report and analysis.


There are some excellent prizes on offer from free subscription (for all category winners) and more – much more!!

Free Subscriptions to Enterprise DNA Learning Platform 

Other prizes.

And much more...

  • The chance to have your work showcased across the Enterprise DNA network. 
  • The chance to win a complimentary subscription. 
  • Receive personalized feedback around your development. 
  • Learn from peers and experts. 
  • Practice what the workplace is looking for enhancing your credentials as a Power BI expert. 
  • Get experience across different industries. 
  • Understand common pitfalls in solutions. 
  • Get involved in discussions around enhancing your solutions and learn about new features.
  • The Brief

After rolling out an excellent EDNA You tube Analysis, we are announcing Challenge 22.

“Hotel Revenue Management”

Report Developer Role

It is your job as an analyst to prepare a deep-dive analysis report about the Hotel Revenue Management dataset.

Special Client Requirements:

  • Client does not want an Intro Page but suggest vertical/horizontal navigation bars or pop-up menu.
  • Not scrollable or fancy shape reports. Preferred size 16:9.
  • Client likes KPIs.
  • Client is very much interested in Time analysis exploration (Seasonality, Festive periods, weekday vs weekend etc)
  • Client is interested in Agent’s performance, overview.
  • Client is interested in any other insights providing further information on Customers type (family with children, single or couples visitors) etc.

Reports are not limited by the number of pages or techniques. Feel free to use all the techniques at your disposal – tooltips, drill throughs, page navigations, etc.

That is all for the brief!

  • Dataset

About the dataset 


  • 2 Zip files,
  • Modelled (PBI File provided) and Unmodelled (Raw data) datasets.
  • One Excel Workbook – Hotel Revenue Management (100K+ Records)
  • PBI file – Data model provided.
  • Data Dictionary
  • Extended Calendar Version V2.01 - August 2022
  • Brief in PDF format
  • Submission of Entries

To be considered within the competition, entries are due no later than 23:59 UK Time (GMT+1) Thursday, September 19, 2022


If you are not already following Enterprise DNA on LinkedIn please do so and join our challenge group at 

How to submit: 


Email the completed PBIX file to :

[email protected]
[email protected]

Take an image of your report and post it to the Enterprise Challenges Group


If you are a platform member, take an image and the “Publish to Web URL” of your report, then post them to the Enterprise DNA forum. If you are not a member of Enterprise DNA learning platform do the same in the Enterprise DNA Challenges Group.

Take the image plus URL and post them on LinkedIn tagging Enterprise DNA to say, I accepted the Enterprise DNA challenge.”

Please use the following tags.

#EDNADataChallenge & #EDNAHotelRevenueManagement

We always encourage all participants to do a brief description of how they approach the project and share their experience of participating in the challenge and sharing it on the forum/social media.

If you need any help with publishing, please reach out to one of the team manager for assistance (post in the forum/LinkedIn group or email to [email protected]

A fantastic opportunity to learn a valuable skill of being able to produce and calculate Revenue Management Reports within Power BI.

The techniques covered here are massively reusable across the board. 

Get involved! 

Any issues or questions please reach out. 

Federico Pastor

Enterprise DNA