1. Summarise the essential findings and story in customer's demands from the table
2. Summarise the data mining process (Data cleaning, data merge, data selection, data modelling, etc.)
3. Analyse the data components (time series data components)
4. Select at least two (2) different forecasting methods to forecast the number of guests coming in the first quarter of 2023.
5. Then, illustrate the forecasting results in plot graphs.
6. Analyse and compare the forecasting result. Give your evaluations on the forecasting technique.
7. Determined all the critical findings and reflected on the customer's demands
8. Analysed the data components Market Segment

Online TA	16195 (40.43%)
Direct	5876(14.67%)
Offline TA/TO	4715(11.77%)
Corporate	1621(4.05%)
Groups	1615(4.03%)
Complementary	187

Distribution Channel

TA/TO	10886(27.17%)
Direct	4600(11.48%)
Corporate	2143(5.35%)

Number of Guest Type

Transient	14130
Transient-Party	3083
Contract	256
Group	161

Guest by Category

Babies	290
Children	2160
Adults	32021

Cancellations vs Non-Cancellations

Previous Booking not cancelled	5867
Previous Cancellations	4075

Deposit Type

No Deposit	38199
Non Refund	1719
Refundable	142

Guest by Country

Country	Guests
PRT	17630
GBR	6814
ESP	3957
IRL	2166
FRA	1611
DEU	1203
CN	710
NLD	514
USA	479
NULL	464
ITA	459
BEL	448
CHE	435
BRA	430
POL	333
SWE	304
AUT	210
RUS	189
ROU	177
FIN	151
CHN	134
NOR	123
AUS	87
LUX	80
MAR	75
DNK	65
ARG	57
HUN	47
LTU	46
IND	37
EST	33
LVA	33
ISR	28
CZE	27
AGO	24
TUR	23
UKR	23
ZAF	18
CHL	17
COL	16
PHL	16
NZL	14
GIB	13
DZA	12
SVK	12
TWN	12
ARE	11
GEO	11
HRV	11
OMN	11
SVN	11
GRC	10
MYS	10
NGA	10
JPN	9
KOR	9
PRI	9
CYP	8
URY	8
BLR	7
SRB	7
ISL	6
LBN	6
MDV	6
MEX	6
MOZ	6
THA	6
AND	5
BGR	5
CPV	5
IDN	5
IRN	5
JAM	5
KAZ	5
CUB	4
HKG	4
PAK	4
SGP	4
SUR	4
ALB	3
AZE	3
CAF	3
DOM	3
JEY	3
KWT	3
VEN	3
ARM	2
CIV	2
CMR	2
CRI	2
ECU	2
JOR	2
MLT	2
MWI	2
VNM	2
ZWE	2
BDI	1
BHR	1
BHS	1
BIH	1
BWA	1
COM	1
CYM	1
DJI	1
EGY	1
FJI	1
GGY	1
LKA	1
MAC	1
MDG	1
MKD	1
MUS	1
NPL	1
PER	1
PLW	1
QAT	1
SAU	1
SEN	1
SMR	1
SYC	1
SYR	1
TGO	1
TUN	1
UGA	1
UZB	1
ZMB	1
Total	40060

Assigned Room Type VS Reserved Room Type

Assigned room type	Count of Reserved room type	Count of assigned room type
A	23399	17046
D	7433	10339
E	4982	5638
C	918	2214
G	1610	1853
F	1106	1733
H	601	712
I	0	363
B	3	159
P	2	2
L	6	1