
🧱 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