ANALYSIS OF HOTEL BOOKINGS
DATA OF EXPEDIA
SHASHWATH SATISH MAHISHI
2019A4PS0523P
What our customers say
Customer case study
Industry overview
Our team
Our products and services
Pricing/packages
Company performance
Future offerings
Roadmap
Competitive comparison
OUTLINE Our proposal
Next steps
DATA OVERVIEW
The hotel bookings data has been given for 4 weeks, in 2 consecutive years. The following data points have been
provided -
Type of Platform used for booking - Desktop, mobile app, mobile web
The region and country that the traveller originates from
The country in which the property booked is present in
Booking window - Number of days between the customer booking and checking into the hotel
Net Gross Booking Value (USD) - The total $ amount that customers pay to [Link] for their hotel reservation
(after removing the value of cancelled bookings)
Net Orders - The total number of hotel bookings made - the number of bookings cancelled
ANALYSIS OF B OOKINGS BASED
ON PLAT FORM
NET ORDERS & GROSS BOOKING VALUE DIVIDED BETWEEN
PLATFORMS
NET ORDERS DIVIDED BETWEEN NET GROSS VALUE DIVIDED BETWEEN
PLATFORMS PLATFORMS
120000000
350000
100000000
300000
Desktop Desktop
80000000
250000 Mobile App Mobile App
200000 Mobile Web 60000000 Mobile Web
150000
40000000
100000
20000000
50000
0 0
2016- 2016- 2016- 2016- 2017- 2017- 2017- 2017- 2016- 2016- 2016- 2016- 2017- 2017- 2017- 2017-
W45 W46 W47 W48 W45 W46 W47 W48 W45 W46 W47 W48 W45 W46 W47 W48
Issues with data
There are some entries where the Net orders and/or Gross Booking Values are negative.
Inferences
The data is following a similar trend between the 4 weeks in both the years, with the 3rd and 4th week falling behind the first 2 weeks in terms of total net orders and
gross booking value
The total net orders has increased for 2017 by 30% while the net gross booking value has increased by just 17%
For Mobile App, the net orders has increased by 80% while the net gross booking value has increased by 30%
For Mobile Web, the net orders has increased by 58% while the net gross booking value has increased by 51%
CHANGE IN THE COMPOSITION OF NET ORDERS & GROSS
BOOKING VALUE
Change in the Composition of net orders &
gross booking value between 2017 and 2016
50%
40%
30%
20%
10%
0%
Desktop Mobile App Mobile Web
-10%
-20%
Net Orders Net Gross Booking Value
Inferences
Desktops have seen a drop in both the net orders and gross booking value, with a bigger drop in net orders
Mobile app has seen an increase in net orders composition, however it hasn’t seen a proportionate increase in gross booking value
Mobile web has shown a smaller increase in net orders composition, but a healthy increase in the composition of gross booking value
CHANGE IN THE COMPOSITION OF NET ORDERS & GROSS
BOOKING VALUE
Change in the Composition of net orders &
gross booking value between 2017 and 2016
50%
40%
30%
20%
10%
0%
Desktop Mobile App Mobile Web
-10%
-20%
Net Orders Net Gross Booking Value
Inferences
Desktops have seen a drop in both the net orders and gross booking value, with a bigger drop in net orders
Mobile app has seen an increase in net orders composition, however it hasn’t seen a proportionate increase in gross booking value
Mobile web has shown a smaller increase in net orders composition, but a healthy increase in the composition of gross booking value
TITLE GOES HERE
CONTENT GOES HERE
CUSTOMER
CASE STUDY
Lorem ipsum dolor sit amet,
consectetur adipiscing elit, sed do
eiusmod tempor incididunt ut
labore et dolore magna aliqua. Ut
enim ad minim veniam, quis
nostrud exercitation ullamco
laboris nisi ut aliquip ex ea
commodo consequat.
Duis aute irure dolor in
reprehenderit in voluptate velit
esse cillum dolore eu fugiat nulla
pariatur. Excepteur sint occaecat
cupidatat non proident, sunt in
culpa qui officia deserunt mollit
anim id est laborum.
OUR TEAM
Insert Name Insert Name Insert Name
Insert title here Insert title here Insert title here
Lorem ipsum dolor sit amet, consectetur Lorem ipsum dolor sit amet, consectetur Lorem ipsum dolor sit amet, consectetur
adipiscing elit, sed do eiusmod tempor adipiscing elit, sed do eiusmod tempor adipiscing elit, sed do eiusmod tempor
incididunt ut labore et dolore magna incididunt ut labore et dolore magna incididunt ut labore et dolore magna
aliqua. aliqua. aliqua.
OUR
PRODUCTS/SERVICES
1. Lorem ipsum lorem ipsum lorem ipsum
lorem ipsum lorem ipsum lorem ipsum
lorem ipsum
2. Lorem ipsum lorem ipsum lorem ipsum
lorem ipsum lorem ipsum lorem ipsum
lorem ipsum
3. Lorem ipsum lorem ipsum lorem ipsum
lorem ipsum lorem ipsum lorem ipsum
lorem ipsum
4. Lorem ipsum lorem ipsum lorem ipsum
lorem ipsum lorem ipsum lorem ipsum
lorem ipsum
PRICING/PACKAGES
Lorem ipsum lorem ipsum lorem
ipsum lorem ipsum lorem ipsum LOREM LOREM LOREM LOREM
lorem ipsum lorem ipsum IPSUM IPSUM IPSUM IPSUM
Lorem ipsum lorem ipsum lorem
ipsum lorem ipsum lorem ipsum
lorem ipsum lorem ipsum
Lorem Lorem Lorem Lorem
Lorem ipsum lorem ipsum lorem ipsum ipsum ipsum ipsum
ipsum lorem ipsum lorem ipsum
lorem ipsum lorem ipsum
Lorem Lorem Lorem Lorem
ipsum ipsum ipsum ipsum
Lorem Lorem Lorem Lorem
ipsum ipsum ipsum ipsum
COMPANY PERFORMANCE
Chart Title
14
12
10
0
Category 1 Category 2 Category 3 Category 4
Series 1 Series 2 Series 3
Lorem ipsum lorem ipsum lorem ipsum lorem
ipsum lorem ipsum lorem ipsum lorem ipsum
lorem
Lorem ipsum lorem ipsum lorem ipsum lorem
ipsum lorem ipsum lorem ipsum lorem ipsum
lorem
FUTURE Lorem ipsum lorem ipsum lorem ipsum lorem
ipsum lorem ipsum lorem ipsum lorem ipsum
OFFERINGS lorem
LOREM LOREM LOREM
IPSUM IPSUM IPSUM
Lorem Lorem Lorem
ipsum ipsum ipsum
OUR
Lorem Lorem Lorem
ipsum ipsum ipsum PROPOSAL
ROADMAP
Lorem ipsum dolor Lorem ipsum dolor Lorem ipsum dolor Lorem ipsum dolor Lorem ipsum dolor
sit amet, sit amet, sit amet, sit amet, sit amet,
consectetuer consectetuer consectetuer consectetuer consectetuer
adipiscing elit, sed adipiscing elit, sed adipiscing elit, sed adipiscing elit, sed adipiscing elit, sed
diam nonummy diam nonummy diam nonummy diam nonummy diam nonummy
nibh euismod nibh euismod nibh euismod nibh euismod nibh euismod
tincidunt ut tincidunt ut tincidunt ut tincidunt ut tincidunt ut
laoreet dolore laoreet dolore laoreet dolore laoreet dolore laoreet dolore
magnaSTAGE 01 magnaSTAGE 02 magnaSTAGE 03 magnaSTAGE 04 magnaSTAGE 05
COMPETITIVE COMPARISON
VS
TITLE GOES HERE TITLE GOES HERE
Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,
consectetur adipiscing elit, sed do consectetur adipiscing elit, sed do
eiusmod tempor incididunt ut labore et eiusmod tempor incididunt ut labore et
dolore magna aliqua. Ut enim ad dolore magna aliqua. Ut enim ad
minim veniam, quis nostrud minim veniam, quis nostrud
exercitation ullamco laboris nisi ut exercitation ullamco laboris nisi ut
aliquip ex ea commodo consequat. aliquip ex ea commodo consequat.
VIDEO SLIDE
OUR PROPOSAL
LOREM IPSUM LOREM IPSUM LOREM IPSUM
Lorem ipsum Lorem ipsum Lorem ipsum
Lorem ipsum Lorem ipsum Lorem ipsum
NEXT STEPS
First
Second
Third
QUESTIONS
LinkedIn
Link to Your LinkedIn Profile
Twitter
@yourhandle
CONTACT
US Email
youremail@[Link]
Phone
Your Phone Number