City Based Dashboard.pdf

An interactive business intelligence dashboard designed to analyze hotel booking patterns, city-wise spending behavior, and accommodation demand to support travel cost optimization and location-based planning.

Objective

Provides centralized visibility into hotel booking expenditure across cities, travel purposes, and accommodation types transforming raw data into actionable insights for cost control and travel planning optimization.


πŸ›  Tech Stack

Tool Purpose
πŸ“Š Power BI Desktop Data visualization & reporting
πŸ“‚ Power Query Data cleaning & transformation
🧠 DAX KPI & performance metrics
🧩 Data Modeling Relationships between cities, bookings & travel purpose
πŸ“ File Format .pbix for development & reporting

πŸ“‚ Data Source

Corporate hotel booking dataset covering accommodation usage across multiple travel destinations, including:


🎯 Dashboard Goals