DATA ANALYSIS - ADVENTUREWORKS
DATA ANALYSIS PROJECT POWER BI DASHBOARD FOR HOTEL REVENUE
Hotel Revenue
This project involves analyzing hotel revenue data from City Hotels and Resort Hotels using Microsoft Excel, SQL, and Power BI. The objective is to track key performance indicators (KPIs) such as revenue, average daily rate, total nights booked, and discounts to identify trends and support data-driven decision-making.
ABOUT
The dataset contains information about hotel reservations, revenue, and guest details, allowing for in-depth analysis of performance across different hotel types:
- City Hotels: Located in urban areas, these hotels tend to have higher occupancy rates during weekdays, catering primarily to business travelers.
- Resort Hotels: These hotels are typically located in vacation destinations and experience peak bookings during weekends and holiday seasons.
Year
2025
Client
City Hotel
Services
Data Analysis
Project
Dynamic
Description
Data Cleaning & Transformation
- Loaded raw CSV data into Microsoft Excel and performed initial data cleaning.
- Used SQL queries to filter, aggregate, and structure the data for analysis.
- Created relationships between different tables to establish a relational data model in Power BI.
Data Analysis & Calculations
- Developed calculated columns and measures in DAX for revenue, average daily rate (ADR), and total nights booked.
- Created KPIs to analyze discounts, occupancy trends, and seasonal variations in revenue.
Dashboard Development
- Designed an interactive Power BI dashboard displaying:
- Total Revenue ($10.23M)
- Average Daily Rate ($104.47)
- Total Nights Booked (367.78K)
- Average Discount Applied (25.81%)
- Added filters for hotel type, country, and reservation status for deeper insights.
- Designed an interactive Power BI dashboard displaying:
Insights & Business Impact
- Identified revenue trends across different seasons and hotel types.
- Provided recommendations on pricing strategies based on discount patterns.
- Highlighted opportunities for improving occupancy rates in Resort Hotels during off-peak seasons.
