Hotel Data Analyses

Caio Bauab

Business Analyst

Data Analyst

Data Visualizer

Microsoft Power BI

Python

SQL

Analytics

Data Project: Hotel Data Analyses

Interactive dashboard (Novy portfolio link)

Project description

The project focused on analyzing hotel booking data to provide actionable insights for stakeholders. The goal was to create a Power BI dashboard that would help answer key business questions related to revenue growth, parking lot utilization, and overall trends in the data.

Email request

Build a visual data story or dashboard using Power BI to present to your stakeholdes
“Is out hotel revenue growing by year?”
• We have to hotel types so it would be good to segment revenue by hotel type.
“Should we increase our parking lot size?”
• We want to understand if there is a trend is guest with personal cars.
“What trends can we see in the data?”
• Focus on average daily rate and guests to explore seasonality.

Data Analysis Project Pipeline

Build a DataBase .
Develop the SQL Query.
Connect Power BI to the Database;
Visualize;
Summarize findings.
Project Goal:
Develop a Database to Analyze & Visualize Hotel Booking Data.

SQL Query (Before connecting with BI)

Like this project
0

Posted Mar 10, 2025

The project focused on analyzing hotel booking data to provide actionable insights for stakeholders.

Likes

0

Views

0

Tags

Business Analyst

Data Analyst

Data Visualizer

Microsoft Power BI

Python

SQL

Analytics

Toman's Bike Share Dashboard
Toman's Bike Share Dashboard
Project Overview Dashboard
Project Overview Dashboard