🧱 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