Thursday, May 28, 2020

Create Hotel Dashboard, Report On Power Bi











About:

Do you know how many rooms you have to sell to get break even?

What's the average daily rate for current Room nights to get break even?

Detailed monthly analysis of Sales, Variable costs, Contribution, Fixed costs and Profit. 



Monthly Operating performance analysing all the dimensions and measures.



What if analysis : 
If we change the average daily rate what will happen?How it will affect revenue, expenses, contribution, profit, break even sales, room quantity and occupancy.



The report can be created on Power Bi or Ms Excel. Power bi is better for presentantions.



3 Pages report. PnL report, Break even point - Cost volume profit and What if Analysis.

Reviews


:

Amazing Job

: : : :


No comments:

Post a Comment