Written and Made by Shibendra B Bhattacharjee
HOTEL BOOKING ANALYSIS
The aim of this project is to analyze Hotel Booking Data and identify and Visualize Business Insights pertaining to revenue
Problem Statement
Business Problem
Data of Hotel Booking is given we need to identify business questions relating to
Identify hotel revenue growth
Segment Hotel Revenue
Comment about the Bookings
Data
The data consists of five tables
Revenue Data of year 2018,2019,2020
Market Segment Data
Discount Data
SQL DATABASE
Exploratory Data Analysis
Uses MS SQL to run queries to identify required tables
Joined required tables to create a unified dataset
Isolated the dataset on identified KPIs
Get the data ready to load to Power BI
POWER BI DASHBOARD
Identification of KPIs for Revenue Growth by creating 2 new measures
Segmenting the Revenue based on Hotel Type, Timeframe, Market Type
Identification of 3 KPIs for identifying trend in Bookings.
Filtering the data based on Country and Hotel Type
Dashboard building