Data analysis on Hospitality Domain in Power BI
Hotel Category
City
All
All
Room Class
All
% Occupancy
Total Revenue
.
ADR
.
-95.41%
.
28.11%
Realisation %
-0.68
0.02
0.00
55.99%
62.64%
70.13%
70.39%
57.87%
70.21%
71%
ADR
71%
70%
70%
Elite
70%
Property
ID
16558
12,800
-
0%
ADR
Standard
rs
ip
…
…
er
ey
ne
i
t
r
t
e
i
l
n
t
l
r
s
ff
g
n
th
ur
o
o
o
ou
o
rip
l
o
t
y
t
j
t
c
c
ke
re
re
a
i
i
d
d
m
Premium
12,600
26
27
28
29
30
31
RevPAR
32
%Occupancy
60%
Presidential
40%
5K
category
17559
Total
Property
Name
City
Atliq
Delhi
Grands
Atliq
Mumbai
Exotica
Atliq City
Delhi
Atliq Blu
Delhi
Atliq Bay
Delhi
Atliq
Delhi
Palace
Atliq
Mumbai
Grands
Atliq
Mumbai
E i
20%
0K
Luxury
1bn
(61.61%)
70%
50%
25
Trend by Key Metrics
Revenue by Category
-%
24
11.94%
1bn (38.39%)
%Realisation & ADR by Platform
% Realisation
23
22.70%
%Occupancy Realisation %
WeekDay 7,-,692.24
WeekEnd 7,-,732.11
7,-,703.55
Total
22
10K
7.35K 70.15% 2.53K
.
ADR
21
28.58%
20%
DSRN
.
RevPAR
20
3.95%
.
Day Type
19
May
36.78%
0%
RevPAR
June
Booking % by Room Category
57.87% 12.70K
2bn
July
20
25
Week No.
Business
Total capacity Revenue RevPAR
ADR
Realisa
tion %
%Occupancy DBRN
30
DSRN
%
Cancellation
Average
rating
4784
36M
7.54K
11.44K
70.03%
65.91%
34.27
52.00
25.06%
4.25
11132
118M
10.64K
16.14K
70.37%
65.92%
79.76
121.00
24.61%
4.32
-
55M
58M
56M
89M
6.29K
8.63K
6.26K
8.28K
11.71K
13.11K
11.71K
12.47K
71.13%
69.87%
69.29%
69.99%
53.70%
65.78%
53.46%
66.40%
-
-
24.12%
25.51%
25.27%
25.26%
-
9384
75M
7.96K
14.84K
69.92%
53.67%
54.74
102.00
25.66%
3.05
9292
94M
10.12K
15.30K
70.81%
66.10%
66.76
101.00
24.01%
4.32
232576
1709M
7.35K
12.70K 70.15%
57.87%
1,462. 2,-
24.83%
3.62
0%
Total Revenue by week No. and Day Type
Day Type
100M 98M
50M 42M
WeekDay
94M
35M
87M
39M
WeekEnd
94M
36M
85M
39M
99M
95M
86M
96M
98M
91M
76M
40M
34M
39M
42M
39M
34M
68M
32M
16M
0M
20
22
24
26
Week No.
28
30
%Occupancy by week No. and Day Type
Day Type
60%
WeekDay
67.01%
67.19%
67.90%
67.27%
66.97%
66.71%
67.29%
59.94%
59.63%
60.19%
59.67%
59.94%
59.78%
60.25%
50%
40%
WeekEnd
20
55.36%
55.46%
55.34%
55.32%
49.39%
49.72%
49.20%
49.24%
22
24
26
Week No.
28
30
ADR by week No. and Day Type
Day Type
WeekDay
WeekEnd
13,000
12,800
12,600
12,400
20
22
24
26
Week No.
28
30
RevPAR by week No. and Day Type
Day Type
WeekDay
WeekEnd
10K
5K
20
22
24
26
Week No.
28
30
%Realisation by week No. and Day Type
Day Type
WeekDay
WeekEnd
100%
80%
60%
40%
20
22
24
26
Week No.
28
30
DSRN by week No. and Day Type
Day Type
WeekDay
WeekEnd
3K
2K
20
22
24
26
Week No.
28
30