Hotel Booking Analysis

-















Goal of the project:

The goal of the projects to analysis the Hotel Bookings of last three years (2015-2017) and provide insights based on the analysis.

Data File:

Data file consists of one excel folder with 32 columns.

Tool Used:

Power BI

Before starting the Dashboard, I noted down few questions which I need to cover in this dashboard. In this particular challenge, it was not mentioned what is the requirement from this analysis or what questions to be solved as a analyst. The dataset contains 32 columns, which is huge, so though of categorizing my analysis in five different sections:

1. Booking and cancellation

2. Occupancy Rate

3. Customer Demographics

4. Customer Preference

5. Key Insights


As the analysis is about the Hotel Industry so, I need to cover the occupancy rate, average ADR, cancellation rate and return rate of customers. i have categorized this key indicators under different sections. In each sections i have mentioned some of the key KPI of Hotel Industry and then i did my analysis part. The dataset was huge so my intention was to sorted the data and create the dashboard in simple and easy format so that it will be easy to read and if the reader is not interested in any particular segment they can skip then read the rest of the part.

 

Comments

Post a Comment

Popular posts from this blog

How to create a Word Cloud in R

-
Image
I have seen Word-cloud in so many places such as magazines, websites, blogs, etc. however never thought of making it by myself. I would like to thank R that taught me such a wonderful technique which everybody would like to learn. I don’t know if there are any other free options are available to create word-cloud. Let me give a quick explanation about R first, R is a free source packages and very useful for statistical analysis. We can use R for various purposes, from data mining to data visualization. Word-cloud is a tool where you can highlight the words which have been used the most in quick visualization. If you know the correct procedure and usage, then Word Cloud is simple in R Studio. Further, a package called “Word-cloud” is released in R, which will help us to create word-cloud. You can follow my simple four steps mentioned below to create word-cloud. Those are new to R or Word Cloud, I would suggest first install R studio from the link rstudio.com Also, the following
Read more

Free Cash Flow to the Firm (FCFF) v/s Free Cash Flow to Equity(FCFE)

-
Shows both the Free Cash Flow to Firm (FCFF) and Equity components of the valuation of an enterprise. Free Cash Flow to the Firm v/s Free Cash Flow to Equity Inputs Earnings before interest and taxes (EBIT) = 100 E xpected growth for next 5 years = 20% Expected growth after year 5 = 5% Tax rate = 40% Debt ratio for the firm = 20% Cost of equity = 15% Pre-tax cost of debt = 9% Return on capital in high growth= 15% Return on capital in stable growth = 10% 0 1 2 3 4 5 Terminal Year Expected Growth rate 10% 10% 10% 10% 10% 5% Reinvestment rate 66.67% 66.67% 66.67% 66.67% 66.67% 50.00% EBIT(Earnings before interest & tax)
Read more

A Key Challenge for Apple's Quest for Carbon Neutrality

-
Image
  The Goal of the project: To visualize Apple progress towards becoming carbon neutral in 2030. In 2020, after announcing their corporate operations were officially carbon neutral, Apple pledged to make their products carbon neutral by 2030. To achieve this goal, they set their emissions for 2015 (38.4 million metric tons CO2e) as the baseline and will aim to reduce them by 75% by 2030. The remaining 25% of gross emissions (9.6 million metric tons CO2e) will be removed using carbon offsets, bringing the net emissions to 0. To find out the how much carbon emission is already reduced by Apple in 2022 and how it going to reduce the remaining by 2030. Key Insights: Based on the data and analysis, i have found these below points: Apple has reduced its carbon emission in corporates operations by 2020 The top three highest emission segments are manufacturing, transportations and product use How Apple will reduce the remaining emission by 2030? Apple already implementation many transformation
Read more

Global GDP Flow slowed down in 2022

-
Image
  I have only worked on Power BI but to use this voronoi treemap, I have chosen Tableau. I have mentioned the link below, if anybody would like to work on this. Please share your feedback, if you like it. :-) Veronoi treemap link: https://lnkd.in/gVqFuZ8M Thanks for reading.
Read more

Pizza Place Sales Analysis

-
Image
  A year's worth of sales from a fictitious pizza place, including the date and time of each order and the pizzas served, with additional details on the type, size, quantity, price, and ingredients. Recommended Analysis How many customers do we have each day? Are there any peak hours? How many pizzas are typically in an order? Do we have any bestsellers? How much money did we make this year? Can we indentify any seasonality in the sales? Are there any pizzas we should take of the menu, or any promotions we could leverage? Tool: Power BI
Read more

DOES GENDER MATTER IN SHARK TANK US?

-
Image
  We all know about the Shark Tank program, which has been running since 2009 and how its popularity is increasing day by day. Now many countries organize this program on their TV show and viewers show so much interest in this kind of reality show. Why not? when there are lots of entrepreneurs around the world and they need to raise funding and mentorship from top sharks for growth of their company. They wonder why nobody would miss this chance. Here is my analysis of Shark Tank US. We had a Data challenge from Onyx Data, where we got a database where you have all the information about the 12 seasons. You need to analyze the data and provide your input through data visualization tools. They also had a mini challenge where they partnership with ZoomCharts. So, in this mini-challenge you need to use their charts (minimum two) for the dashboard and submit your entry. I always like to create my dashboard with a strong purpose, which I usually find through initial analysis of data. And this
Read more

Great thought by Mrunal Nandankar

-
Success is not measured by how much a man has, But how much he has done, How far he has gone. Success is the basic human knowledge, Of how well a man has done. It is not taken lightly, Or as it shouldn't be. This is a serious task. One given to man by fate. Only you can determine your success. Only people can comment it. Push your self to the limit, Gas far as you can, Strive for it, For it is important, Your success. One of the most important traits of human kind, Taken for granted by the rich, And serious by the poor. We all have it in us, What it takes to be a success. We just have to reach in deep enough, And we will soon find the success in us, That has been lying there all a long. Success is key to all of life's compances, Enjoy it while it lasts. By Mrunal Nandankar...............
Read more

Highlights of Railway Budget: 2013-2014

-
Image
                                              Our Honorable Railway Minister Pawan Kumar Bansal has presented his maiden railway budget in the Parliament.                Key Highlights of Railway Budget: ·          No passenger fare hike ·          5% average increase in freight rates ·          More usage of agro-based and recycled paper and ban use of plastic in catering. ·          Railways have been annually disposing of scrap which not only generates revenue but also helps in de-cluttering the work space. The minister intends to institute a special drive during the year to take up disposal of scrap lying in stores depots, workshops, along the tracks and at construction sites. A target of Rs 4,500 crore has been set for 2013-14. ·          IR enters the 1 billion tonne Select Club joining Chinese, Russian and US Railways. ·          ‘Fuel Adjustment Component’ concept to be implemented linking tariffs with movemen
Read more