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
Project image

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