Skip to content

Latest commit

 

History

History
28 lines (18 loc) · 1.46 KB

README.md

File metadata and controls

28 lines (18 loc) · 1.46 KB

DataAnalystProject

Introduction

Hello! Welcome to my project, in this project , we will know more about Revenue Insight of Hospitality Domain by using Power BI

image

Here is my profile:

antonkomarev-profile-views-counter

ABOUT THE PROJECT

The key metrics by using DAX

image

To understand more about Hopitality Domain, we have to caculate the metric formulas like:

  • Revenue : To get the total revenue_realized
  • RevPar : Revenue Per Available Room , RevPAR represents the revenue generated per available room, whether or not they are occupied
  • DSRN(Daily Sellable Room Nights): This metrics tells on average how many rooms are ready to sell for a day considering a time period
  • Occupancy: Occupancy means total successful bookings happened to the total rooms available(capacity)
  • ADR(Average Daily rate): It is the ratio of revenue to the total rooms booked/sold.
  • Realisation: It is nothing but the succesful "checked out" percentage over all bookings happened.

Main DashBoard

z4344963881223_5d95d283ba63f6af859c08787ec42346