This project involves analyzing hotel revenue and trends using SQL and Power BI. The analysis focuses on revenue growth, parking lot usage, and data trends. An interactive dashboard was created to visually present the findings.
- Examined if hotel revenue is growing year-over-year.
- Segmented revenue trends by two hotel types to identify key growth areas.
- Evaluated parking lot usage for 2018 and 2019.
- Determined that parking percentage remained consistent across years, making it challenging to justify expanding parking space.
- Explored various trends in the dataset.
- Created an interactive Power BI dashboard to display insights, facts, and figures dynamically.
SELECT: For data retrieval.LEFT JOIN: To combine tables and analyze related data.GROUP BY: For segmenting data by attributes such as hotel type and year.
Key features of the dashboard include:
- Year-over-year revenue analysis.
- Revenue segmentation by hotel type.
- Parking lot usage trends.
- Dynamic visualizations to support data-driven decision-making.
- SQL: Data import and querying.
- Power BI: Data visualization and dashboard creation.
- Excel: Demo dataset source.
- Access the interactive dashboard: Hotel Revenue Dashboard.
- Explore the visualizations to analyze:
- Revenue trends over the years.
- Parking lot usage by year.
- Trends segmented by hotel type.
- Revenue segmentation reveals which hotel types contribute most to growth.
- Parking lot trends suggest no immediate need for expansion.
- An interactive dashboard simplifies trend analysis for stakeholders.
Have questions or feedback? Feel free to reach out or open an issue in the repository.