🏨 Hotel Revenue Analysis & Dashboard

📌 Project Overview

This project analyzes historical hotel booking data to understand revenue performance across years and compare City Hotels vs Resort Hotels. The analysis was performed using SQL Server, and insights were visualized through an interactive Power BI dashboard.

🧱 Dataset

• Historical hotel reservation and revenue data
• Two hotel types: City Hotel and Resort Hotel
• Time span: multiple years

🎯 Business Objectives

• Analyze year-wise hotel revenue trends
• Compare revenue contribution of City vs Resort hotels
• Track key metrics such as ADR, total nights, discounts, and parking demand
• Provide management with a high-level revenue dashboard

🛠️ Tech Stack

• Database: SQL Server
• Query Language: SQL
• Visualization: Power BI

📊 Key Analysis & Metrics

• Year-wise revenue aggregation
• Revenue comparison by hotel type
• Average Daily Rate (ADR) analysis
• Total nights booked
• Discount trends
• Parking space utilization

📈 Dashboard Highlights

• Interactive date, hotel type, and country filters
• Revenue trends over time
• Donut chart showing revenue split between City and Resort hotels
• KPI cards for quick executive insights

🔍 Key Insights

• City and Resort hotels show distinct revenue patterns over time
• A small number of high-demand periods contribute significantly to total revenue
• Resort hotels generate a substantial share of revenue despite fewer bookings

🚀 Outcome

• This project demonstrates the ability to:
• Perform business-focused SQL analysis
• Translate raw data into actionable insights
• Build executive-ready dashboards using Power BI