This project takes a deep dive into a three-year hotel revenue dataset (2018, 2019, and 2020) using SQL and Power BI. We use SQL queries for data processing, uncovering insights about revenue trends and guest seasonality. Power BI complements this by transforming our findings into visually engaging presentations, enabling us to offer actionable recommendations for staffing arrangements based on the data's nuances. This analysis not only illuminates patterns but also acknowledges dataset limitations, striving to empower businesses in the hospitality industry with informed strategies for success.
Our journey begins with the ingestion of raw data from Excel file into SQL Server Management Studio (SSMS). This step ensures that the data is accessible and ready for analysis. Once the data is in SSMS, we embark on the iterative process of building SQL queries, allowing us to refine and shape the dataset to suit our analytical needs.
The attached SQL in the repository is used to connect with SQL server and Power BI.
While data analysis is an essential component of our project, effective communication of insights is equally vital. This is where Power BI takes center stage. Leveraging Data Analysis Expressions (DAX) functions, we create measures to generate visual representations of our findings. Power BI empowers us to produce stunning and interactive data visualizations. To further refine and transform our data, we harness PowerQuery within Power BI, allowing us to construct captivating visual narratives. Through visually engaging charts and graphs, we bridge the gap between raw data and actionable insights, making even the most intricate data comprehensible to our audience.
This is an interactive Power BI Dashboard , you can interact with this dashboard from https://www.novypro.com/project/hotel-data-analysis-power-bi
![image](https://private-user-images.githubusercontent.com/135998004/280945758-0397d12a-af55-4542-b829-ff1d87fa5a25.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ5NTk3ODcsIm5iZiI6MTcyNDk1OTQ4NywicGF0aCI6Ii8xMzU5OTgwMDQvMjgwOTQ1NzU4LTAzOTdkMTJhLWFmNTUtNDU0Mi1iODI5LWZmMWQ4N2ZhNWEyNS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI5JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyOVQxOTI0NDdaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0yNjU1OTA2NzYxNDA5NWFlODQ1MDk2N2NlNGMxOTgzNWJkZTA0MzE5OGQ3YTM2MTQ5ODgwMzQ3MjFhOTExMzkxJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.GkflVVfGra0Fr7dfabmUwIS7d8u2-dppQ6yDRgAogQc)
This project combines the power of SQL and Power BI to transform raw data into actionable insights. By exploring the hotel's revenue data, we aim to empower businesses to make informed decisions, optimize their operations, and enhance the guest experience. Our journey begins with data, but our destination is the betterment of the hotel's service and profitability.